Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Data To/From Database

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
pguerett
Level 10
Level 10
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.
Not applicable
email is bherbert@imcu.com



Thanks
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
pguerett
Level 10
Level 10
You will have to create an empty record first ...then do an update to add your values.
Not applicable
Did you get a chance to send me the email with the example script?



bherbert@imcu.com



Thanks,

Brad
pguerett
Level 10
Level 10
Sorry it slipped my mind ....just sent it