Return name after input of card number

Carmiel 01 Oct, 2019
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
GreyHead 02 Oct, 2019
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
healyhatman 02 Oct, 2019
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.
Carmiel 07 Oct, 2019
Hi, thank's for answers.
I did not success anything, I gave up and did simpler.
Regards
This topic is locked and no more replies can be posted.