AnsweredAssumed Answered

Constraining a Sum of Values in Survey123 Connect

Question asked by shariforbes on Sep 16, 2020
Latest reply on Sep 17, 2020 by bwebster-esristaff

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. 

Thanks,

Shari

Outcomes