Expand my Community achievements bar.

Radically easy to access on brand approved content for distribution and omnichannel performant delivery. AEM Assets Content Hub and Dynamic Media with OpenAPI capabilities is now GA.

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