Hi all,
I am working on a project, I want to restrict the end user to enter the duplicate email ids or mobile numbers. I mean, end user cannot enter the email or mobile number if it's already exist in the Database.
It should show an error message if user entered existed email id on the interface.
Solutions would be highly appreciated.
Thank you in advance!
Discussion posts and replies are publicly visible
Do you want to see if this user has already entered the same phone number / email or any user? If it's only for this user, it's probably easiest to query on loading the form to return all of this user's existing emails / phone numbers. Then, you could do a comparison in a validation to check if the user has already entered this value or not.
If you're looking to see if this phone number / email is unique across all of your data, you should likely query after the user has entered the data to check and see if there are any rows in the database with that exact email / phone number.
Hi, thanks for replying.
Yes! I am looking for the second, which means, email or mobile number that must be unique across the application. How can apply it to the interface... at the time of entering... it should show an error message.
Every input field has a "validations" attribute. You can invoke a rule here, and in that rule you can use the value entered by the user to search the existing values in your database table. If you find a corresponding value you can return an appropriate message, else return null.