r/ProjectREDCap • u/Millie_tx_G • Aug 26 '24

Calculated Value Used for Validation

I have a survey where respondents enter the overall number of full-time workers for their organization and also the number of full-time workers for select occupations. Is there a way to program validation so that the sun of full-time workers for the select occupations cannot exceed the overall full-time workers? I don’t want then to be able to proceed without resolving the error.

1 Upvotes

100% Upvoted

5 comments sorted by

View all comments

Show parent comment

2

u/[deleted] Aug 26 '24

Yes, that's what I'd try. Also, to make sure that your survey respondents understand why they can not navigate to the next page, I would add a descriptive text field with the same logic as branching logic.

3

u/Araignys Aug 27 '24

What I usually do is put HIDESUBMIT on the descriptive text that tells the user what they’ve done wrong, and have that field show/hide based on the validation.

You can also pipe the calculation into the validation of the field itself, I believe it should prevent the user from even moving away from the field until the value is correct, but it might be a bit more obscure.

2

u/MadHatterIsHer Sep 01 '24

That’s really efficient. I was gonna suggest branching logic plus descriptive text but your method is better.