You are viewing limited content. For full access, please sign in.

Question

Question

Database Lookup

Forms
Updated March 25, 2015
asked on March 25, 2015

We have a form that pulls the AD log in name for the user using a javascript.  This works great!  On the same form we want to look up into a sql database to fill in the phone number, department, and email fields.  This also works if we manually enter the log in name.  However, the data is not pulled from the log in name supplied by the javascript.  how can I modify the either the script or the database lookup to use the automatically supplied log in name?

0 0

Replies

replied on March 25, 2015

when a value is changed, what triggers the SQL lookup?  

 

0 0
replied on March 25, 2015

You will need to trigger an event since javascript isnt doing it all alone.

 

after assigning the field a CSS class, say triggerme to the following at the end of the javascript code

$('.triggerme input').trigger("change");

That will tell it to trigger that field as changed, so other actions can proceed

0 0
replied on March 25, 2015

that did it, thank you!

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...