Select to view content in your preferred language

Constraining a Sum of Values in Survey123 Connect - with file

1933
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
BarbaraWebster1
Esri Regular Contributor

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