How to check whether first name and last name entered on the form already exist or not ?

Venkatesh43
Tera Contributor

Hi experts,

I have two fields on the form, first name and last name and I have a back end table in which all user attributes are present including first name and last name.Once the user enters first name and last name I would like check whether combination of first name and last name already present in table or not, if present give an alert message. Find the below image

find_real_file.png

if a user with same first name and last already exist then have to give a pop-up message in the form.I wrote two scripts, onchange of first name and onchange of last name but it is leading to an infinity loop as both are working one after another. Is there any better idea to fulfill this requirement ??

Regards,

Venkatesh

5 REPLIES 5

sachin_namjoshi
Kilo Patron
Kilo Patron

You should use GlideAjax to implement this requirement as best practice.

Script include should return response for your parameters from client script.

Please check below for more details

 

https://snprotips.com/blog/2016/2/6/gliderecord-client-side-vs-server-side

 

Regards,

Sachin