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

Add data to data pulled from a table

Avatar

Level 6

I am generating a form against a table of 50 location names in a  database.  I don't have access to the database but thought I could add  the location address and phone number to the form based on the location  pulled from the application.
 
Thought a simple script could do the trick:
 
if (xfa.event.newText=="LocationName")
{form1.bodyPage1.address1.rawValue="11 Main Street"
form1.bodyPage1.address2.rawValue="Anytown, USA"
form1.bodyPage1.phone.rawValue="123 456 7890"}
 
The first line is the location pulled from the table.
I would add the address and phone with the script.
 
The form does correctly pull the location name from the table but no address or phone.
 
Is this doable?

1 Reply