I Create a validation query that check if the emails exist in the RDBMS, if email does not exist the validation shown like this,
but I struggle in the multiple message because I used a!foreach for that.How this text make as one only?
Discussion posts and replies are publicly visible
Try replacing the text "Couldn't find your Account" with true() and wrap the a!foreach() with or() to check if any of the emails are not in the database.
So if your condition is
Validation: a!foreach(array, if(fv!item not in database, "Couldn't find your Account", null)
Replace it as:
Validation: if(or(a!foreach(array,if(fv!item not in database, true, false)) = true, "Couldn't find your Account",null)
validations : a!foreach( items: rule!checkEmails(emails: ri!email),expression: if(fv!item.emails = ri!emails, null, "Couldn't find your account")) Here's my actual code
Hi Try like this
if( isnull(rule!checkEmails(emails: ri!email)), "Couldn't find your account", "" )