Expand my Community achievements bar.

Elevate your expertise and be recognized as a true influencer! Nominations for the exclusive Adobe Community Advisor program 2023 are now OPEN.

Data To/From Database

Avatar

Not applicable
I know that there is a way to do this just can find the best way. I want my employees to be able to key in an account number and the database return necessary information. There will be 6 or 7 fields that will populate. I have created an ODBC connection to the source. After the form is complete I want my employees to be able to hit the submit by email button and the form be emailed as well as saved back to a different Database.



Thanks

Brad
6 Replies

Avatar

Not applicable
If you post your email address I will send you a sample of how to do the population part.



You will need to set the delayed opening on the DB connection and then control all aspects the data connection through script.

Avatar

Not applicable
I cant seem to figure out the proper scripting for that. Do you have an example? I want to write it to a SQL Database.



Thanks

Avatar

Not applicable
You will have to create an empty record first ...then do an update to add your values.

Avatar

Not applicable
Did you get a chance to send me the email with the example script?



bherbert@imcu.com



Thanks,

Brad