Forums

Hi dears,
I try to do something that should be very simple.
table ##_cb_comprofiler contain : id, user_id (same value), lastname, firstname and a card number field called "##_cb_numcarte".
I want the user to input the card number value of any other user in a text field and get the name (lastname + firstname) in a text field called name of the Form (or the field name of the table ##_users)
Input card value et get name of the user.
Thank's for help

Hi Carmiel,
​
After the form is submitted you can use the Card Number in a DB Read action to look up the matching name etc.
​
If you want to do this in the browser then you could set up an Ajax Query to link to a separate form event that does the lookup.
​
Bob

If it's on CFv5 you'll have to make your own jQuery functions.
​
If it;s on CFv6 just put a button next to the field, in the events for the button do on click -> reload and tell it to reload a container area, which contains a custom html block with something like {var:read_data#.model.field}. Everything else just follow the dynamic field demo.

Hi, thank's for answers.
I did not success anything, I gave up and did simpler.
Regards