How to restrict the end user to enter the duplicate emails or mobile?

Question

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!

Peter Lewis · Accepted Answer

Here's an example of how you could set it up for a phone number: 
 a!localVariables(
 local!phoneNumber,
 
 /* Determines how many existing records */
 /* have the same phone number */
 local!phoneNumberMatching: if(
 a!isNullOrEmpty(local!phoneNumber),
 0,
 
 /* Run a query with a filter by phone number. */
 /* This could also use a!queryEntity() */
 a!queryRecordType(
 recordType: recordType!Employee
 fields: {
 recordType!Employee.fields.name,
 recordType!Employee.fields.phoneNumber
 },
 pagingInfo: a!pagingInfo(
 startIndex: 1,
 batchSize: 1
 ),
 filters: a!queryFilter(
 field: recordType!Employee.fields.phoneNumber
 operator: "=",
 value: local!phoneNumber
 )
 ).totalCount
 ),
 
 /* Checks that the there are no matches */
 local!phoneNumberIsValid: and(
 a!isNotNullOrEmpty(local!phoneNumber),
 local!phoneNumberMatching = 0
 ),
 a!formLayout(
 label: "Form",
 contents: {
 a!textField(
 label: "Text",
 labelPosition: "ABOVE",
 saveInto: local!phoneNumber,
 value: local!phoneNumber,
 refreshAfter: "UNFOCUS",
 validations: {
 if(
 local!phoneNumberIsValid,
 null,
 "This phone number has already been taken, please enter a different phone number"
 ),
 }
 )
 },
 buttons: a!buttonLayout(
 primaryButtons: {
 a!buttonWidget(
 label: "Submit",
 submit: true,
 style: "PRIMARY",
 loadingIndicator: true,
 )
 },
 )
 )
) 
 Keep in mind that validations for phone numbers can get fairly tricky - often different users will include dashes, parentheses, dots, etc to separate the values of the phone number, so you may either want additional validations to account for those cases or use some kind of cleaning to make sure that you're only comparing the numbers.

GopalK · Answer

Hi Shubham, you can get all email ids from db in a local variable and then configure the validation parameter of the text field using an expression (use "contains" function) which will check if entered value exists or not in the local variable you pulled of email ids. And the. Conditionally you can show some message to the user.

How to restrict the end user to enter the duplicate emails or mobile?

Top Replies