04-28-2020 11:54 AM
That was an overly complicated way of asking if there is a way to verify if an email submitted on a form is valid.
Here is the situation:
We collect information on a shared form. The information collected includes an email keyword that is used in the workflow for notifications, both in system events and ad-hoc tasks. When the email address is not formatted as an email address should be (basically, no
I hope this makes sense!
Thanks!
04-28-2020 12:32 PM
Hi Devine,
You can use a script that checks if an email provided is valid or not at the unity form level. If you are looking for something that validates when the form is submitted using regular expressions you can use this.
You can replace %Vvalue with the email KW(%K000) and execute it.
Thanks,
Ram.
04-28-2020 01:36 PM
Hi Devine,
If you want to validate at form level
1) Create 2 fields in the hidden section one for copying the value entered in the email field and other to write the value from the script (Valid/Not Valid)
2) Using custom action copy the email field value to the created field and execute a script when field not empty and get the value valid/not valid from the script.
3) If the script returns Invalid make the field as invalidate using a custom action and display a msg something like "Please input a valid email address"
NOTE: This validates only if the email maintains the standards for email format but not if this email exists or not?
Thanks,
Ram.
04-29-2020 05:15 AM
I like both of these answers for different reasons - I think I will be able to use them for a lot of things in the future. If I want to check both the symbol (sorry, when I try to type it now, it brings up your names) and a '.') can I do both in one script with an &. Sorry I don't know the scripting very well.
04-29-2020 09:40 AM
You can look for both the "@" and "." in the same expression in work flow and in the same Script
Thanks,
Ram
04-28-2020 12:32 PM
Hi Devine,
You can use a script that checks if an email provided is valid or not at the unity form level. If you are looking for something that validates when the form is submitted using regular expressions you can use this.
You can replace %Vvalue with the email KW(%K000) and execute it.
Thanks,
Ram.
04-28-2020 01:24 PM
THANKS! I will test this tomorrow, first thing.
How can I test this at the form level (if I might sneak another question in...)
04-28-2020 01:36 PM
Hi Devine,
If you want to validate at form level
1) Create 2 fields in the hidden section one for copying the value entered in the email field and other to write the value from the script (Valid/Not Valid)
2) Using custom action copy the email field value to the created field and execute a script when field not empty and get the value valid/not valid from the script.
3) If the script returns Invalid make the field as invalidate using a custom action and display a msg something like "Please input a valid email address"
NOTE: This validates only if the email maintains the standards for email format but not if this email exists or not?
Thanks,
Ram.
04-29-2020 05:15 AM
I like both of these answers for different reasons - I think I will be able to use them for a lot of things in the future. If I want to check both the symbol (sorry, when I try to type it now, it brings up your names) and a '.') can I do both in one script with an &. Sorry I don't know the scripting very well.
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.