Check for Specific Email Domain on REDCap Survey
- Christopher Sorensen
Purpose: Demonstrate how to use the “right” function to check for an @wustl.edu email address which can be used in branching logic, survey queue logic, etc. This can be adapted to any email domain.
Practical Examples:
Using Branching Logic to have non-university employees enter a guest ID
Allowing only people from WashU to submit an application
For more information about the “right” function, see REDCap Functions to use with Text values on the REDCap Special Function Explanations page.
Demonstration Video:
Practical Examples:
Using Branching Logic to have non-university employees enter a guest ID
Allowing only people from WashU to submit an application
Using Branching Logic to have non-university employees enter a guest ID
Click the Branching Logic icon on the field you would like to appear if the email is an @wustl.edu email.
Click in the Advanced Branching Logic Syntax box and enter an equation with the “right” function so that REDCap checks if the final 10 characters of the email address entered to the field are equal to @wustl.edu and click Save. For example, if the variable name of the email field is [email], the formula will be: right([email],10) = '@wustl.edu'
Create a record and enter an @wustl.edu email address into the field to confirm the field with the Branching Logic appears (note: you may need to remove your cursor from the field after typing the address for the hidden field to appear):
Then enter a non @wustl.edu address to confirm that the field hidden by Branching Logic does not appear:
To check for a non @wustl.edu email using Branching Logic:
Click the Branching Logic icon on the field you would like to appear if the email is not an @wustl.edu email.
Click in the Advanced Branching Logic Syntax box and enter an equation with the “right” function so that REDCap checks if the final 10 characters of the email address entered to the field are equal to @wustl.edu and click Save. For example, if the variable name of the email field is [email], the formula will be: [email] <> '' AND right([email],10) <> '@wustl.edu'
The [email] <> '' portion of the formula is stating that the field will only appear if the email address field is not blank. Technically, when the email field is blank, the field does not have an @wustl.edu email in it and the Non-WUSTL email message field will appear if the field is blank. By adding the additional portion of the formula, we ensure the message does not appear until there is an email address in the field that is not an @wustl.edu address.
Create a record and enter a non @wustl.edu email address into the field to confirm the field with the Branching Logic appears (note: you may need to remove your cursor from the field after typing the address for the hidden field to appear):
Then enter a @wustl.edu address to confirm that the Non-WUSTL email field hidden by Branching Logic does not appear:
