Hello everybody,
I start on Appian, and I would like to control the mail adress format on an interface (presence of @, followed by a point ...).
How to do ?
Thaks for your help
Discussion posts and replies are publicly visible
You can use following to validate an Email Address as Mike mentioned above
if( or( len(trim(ri!address)) > 255, length(split(trim(ri!address), " ")) > 1, count(split(ri!address, "@")) <> 2 ), false(), with( local!localPart: split(trim(ri!address),"@")[1], local!domainPart: split(trim(ri!address),"@")[2], if( or( length(split(local!domainPart, ".")) < 2, contains(split(local!localPart, "."), ""), contains(split(local!domainPart, "."), ""), not(isnull(stripwith(lower(local!domainPart), "abcdefghijklmnopqrstuvwxyz1234567890-."))), not(isnull(stripwith(lower(local!localPart), "abcdefghijklmnopqrstuvwxyz1234567890-._+'&%"))), not(isnull(cleanwith(right(local!domainPart,1), "1234567890-"))) ), false(), true() ) ) )