Check If Data Exists In Table On Submit Form

[crazedwombat]

Hi, I have a basic submission form with an email address field.

 

My goal is when the email field is filled out, it will check whether it exists in the table.

 

If it exists then it will not allow the submission to happen because they already have an account.

 

It can be either on the click of submission or onchange in the email field, both ways work for this situation. Thanks.

[crazedwombat]

For those interested in how I worked around this. With help, I created a cascading text field hidden from view that would populate from the table in a visible search field. If the data existed I would alert onsubmit. Otherwise, it didn't exist and move forward as new user.

[Walter]

I checked the field as Unique in the Table Design, when I needed to prevent adding the same data more than once. Then the system does not allow to create the recored with the same value.

It's a column of checkboxes that is named "Unique" in the Table Design screen.

[crazedwombat]

That would work normally, however in my case, the table itself is allowed multiple email addresses, but for that one particular form I want them to have a unique address.

 

Once the form is submitted, I create an account for them where they can fill out another form that writes to the same table.

 

However, I dont want multiple accounts.

 

Basically, its a 'is username available' check.

[NailDyanC]

Hello, just want to add in the previous comments above, here's a sample article on how to check duplicate values in the table and present a warning message: