Expand my Community achievements bar.

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