Constraining a Sum of Values in Survey123 Connect - with file

1826
1
09-24-2020 10:07 AM

Constraining a Sum of Values in Survey123 Connect - with file

Hello. We are using Survey123 forms for volunteers to register for a cleanup event. We are including in the from a place for the volunteer to choose Tshirts by several sizes. I want to restrict the total of the Tshirt values by size chosen by the volunteer to not be greater than the total number of volunteers. (Example: if there are 3 volunteers they should not be able to choose 4 or more tshirts on the form). Each Tshirt by size  (example., TShirtS, Tshirt2XL, etc) field is an integer and there is a Total Number of Volunteers field that is an integer as well. 

 

I tried this and it didn't allow ANY number. 

(${TshirtS})+(${TshirtM})+(${TshirtL})+(${TshirtXL})+(${Tshirt2XL})+(${Tshirt3XL})+(${TshirtYM})+(${TshirtYS})<=(${NumberVol})  

 

I feel like I'm on the right track. Please advise. 

My xlsform is attached called Site 1.

Barbara Webster

Thanks,

Shari

Attachments
Comments

Thanks! See my reply in the main thread: Constraining a Sum of Values in Survey123 Connect.

Version history
Last update:
‎09-24-2020 10:07 AM
Updated by:
Contributors