We would like to implement a form for users to join activity. But the activity has head count and we would like to prevent user to submit the application when the quota is reached.
We have tried few ways to implement but the feature is still not working. For example, finding the count function, set the default quota in form.
I would like know is there any work around to implement this feature? Thanks!
Dear Dorothy Fan,
1-Create a list for Quota "QuotaList" containing a field of type Number called "Nbr".
2-Create an item in this list with the below values:
Title=N/A
Nbr=0
3-On submitting of a form, if it's in new mode, increment the "Nbr" field by 1 through the Workflow.
4-Add a calculated value to the form having a lookup function as formula:
Formula Builder
lookup("QuotaList","Title","N/A", "Nbr") |
5-Add a formatting rule to the save button. Ex: disable it if the value of the lookup is equal to 100
Cheers... 
Dear Philip,
Thanks for your reply. I will try about it. I would like to know is there any other way to do it without using workflow? Thanks!
Dear Dorothy Fan,
1-Create a field called "Title_Hidden" with default value "N/A".
2-Create a field of type Number called "Custom_Count" with 0 as default value.
3-Use the following formula:
4-Attached you can find the settings of the calculated value control.
5-Use the calculated value control to justify the save button formatting.
Cheers...
Dear Philip,
I tried and work perfectly. Thanks a lot. ^^
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.