Issue
I want to add a conditional logic to my registration table so that if this condition is not met, the registration table cannot be submitted. e.g. I want my field "Ratio" to equal to 100.
Environment
Notebook, Registration table
Cause
This logic should be set up in the notebook template
Resolution steps
1. Create a notebook template with your registration table of interest
2. Add at least one boolean-type (TRUE/FALSE) custom column
3. Use a combination of functions (ISBLANK, ISERROR, AND, OR, IF) to create desired logical expression referencing other table cells inside the boolean-type custom column
- Valid submissions: Logical expression should output to “TRUE” in the boolean custom column
- Non-valid submissions: Logical expression should NOT output to “TRUE”, preventing the user from submitting the table - DO NOT use "FALSE" but a different string (e.g. "Invalid", "Please submit a different value")
4. Lock the custom column so that users are unable to change the templatized function
5. Create entry from this template - the table should be locked for submission until the condition is met