Constraining integers in a group

Hi there, I need constraining integer responses within a group. For example, I am asking what people do with scales and have provided different options with fields to collect values (proportions for each category), whose sum must be 50. I want to ensure that surveyors do not mistakenly enter more or less than 50. https://docs.google.com/spreadsheets/d/1Faoiu_5eqRaExGB5XAHEn_FG710SMUf1/edit?usp=sharing&ouid=109355821027404963770&rtpof=true&sd=true I can’t upload a file as a new user, so I am sharing a Google Drive link of my form. thank you.

palatability - Copy.xlsx (18.0 KB)

Welcom @cemogor,
Often the search function of this forum (and Help Center articles) can provide solutions, e.g. https://community.kobotoolbox.org/search?context=topic&context_id=31979&q=constraint%20for%20sum&skip_context=true.

2 Likes

@cemogor, this post discussed previously should help you solve your issue:

This post, too should be helpful:

1 Like