Hello! I wanted to add validation criteria for the question of email and it needs to be case insensitive, Does somebody know how to do that? for example: It works for both mur@gmail.com and Mur@gmail.com . I have around 500 emails need to be in the validation criteria, so if there is an easy way it would be appreciated! Thanks
Welcome to the community, @murtiza ! We have some workarounds in the community which should help you solve your issue:
@mkmortera , maybe you could do it as outlined in the image shared below using this regex code regex(., ‘^([\W\d\D]+[@][\D]+[.][\D]{3}[.][\D]{2})+$’):
In the survey tab of your xlsform:
[Image 1]
Data as seen in the server:
[Image 2]
Data as seen when downloading in XLS format:
[Image 3]
Reference xlsform:
Email Regex.xlsx (8.6 KB)
And this one too …
Welcome back to the community @msupriya ! You could do the same as outlined in the image below:
In the survey tab of your xlsform:
[Image 0.0]
Data entry screen as seen in Enketo: when a wrong entry is made
[Image 0.1]
Data entry screen as seen in Enketo: when a correct entry is made
[Image 0.2]
Reference xlsform:
Email Regex.xlsx (8.6 KB)
And this one too …
Maybe you could do it as outlined in the image below:
In the survey tab of your xlsform:
[Image 0]
Data entry screen as seen in Enketo: when a wrong entry is made
[Image 1]
Data entry screen as seen in Enketo: when a correct entry is made
[Image 2]
Reference xlsform:
Email Regex.xlsx (8.7 KB)
To understand more on Regex, you could have a look at our support article Restricting Text Responses With Regular Expressions which has plenty of examples that could be helpful for your day to day wor…
We also have a support article Restricting Text Responses With Regular Expressions on regex which should help you better understand how to build a regex code by yourself.
1 Like