Adding meta data to an existing database

[kcratty]

II have a Connect App to be used to submit data to a workflow. When it is submitted, the user would enter information that would be a part of the metadata. I am looking for a script to add the metadata to the existing database on every record.'



Example:

meta data: Presorted



Data as submitted:



Name,Address,city,state,zip

John Doe, 123 doverLane, Lanham, MD, 20008

Jane Doe, 123 doverLane, Lanham, MD, 20008



After script

Name,Address,city,state,zip,Indicia,background

John Doe, 123 doverLane, Lanham, MD, 20008,presorted,imageA

Jane Doe, 123 doverLane, Lanham, MD, 20008,presorted,imageA



Is this possible with Javascript?

[freddyp]

It is possible. It is easier with the Database Module because then you do not have to script anything. You can directly call the database with the "Database connect" element.



Freddy

[dkelly]

You mention that the metadata from Connect will contain the presorted information. Where does the other data come from? Are you updating existing database records or insert new ones?