email id

Question

I have a form where a user needs to fill it. I have an email id field in it. So, now when a user enters the email I need to check whether the entered email id is already there in the records or not. If email id already presents it should throw an error in the interface saying "email id already exists".
Can anyone please let me know how to apply this scenario in my interface!

harshas2775 · Answer

You can simply query your table, filtered based on the entered email Id. If any record is found (totalCount>0) then you can throw the validation.

E.G.

a!localVariable(
local!checkEmailID:a!refreshVariable(
value:a!queryentity(
entity:cons!EXAMPLE_YOUR_ENTITY,
query:a!query(
filter:a!queryfilter(
field:"emailId",
operator:"=",
value:local!emailIdInput),
pagingInfo:a!pagingInfo(1,1))),
refreshonVarChange:local!emailIdInput),
a!sectionlayout(
contents:{
a!textField(
label:"Email ID",
value:local!emailIdInput,
saveInto:local!emailIdInput,
validation:if(
local!checkEmailID.totalCount>0,
"Validation Message",
"")
)
}
)
)

Sign up

Login with SSO

Login to the community

Login with SSO