cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Implement Quota feature in Nintex Form

Jump to solution

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!

Labels: (1)
0 Kudos
Reply
4 Replies
Workflow Hero

Re: Implement Quota feature in Nintex Form

Jump to solution

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...

Reply
Workflow Hero

Re: Implement Quota feature in Nintex Form

Jump to solution

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!

0 Kudos
Reply
Workflow Hero

Re: Implement Quota feature in Nintex Form

Jump to solution

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:

Formula Builder
Formula Builder
If(Is New Mode,length(lookup(List Name,"Title_Hidden","N/A","ID",True)),Custom_Count)

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...  

Reply
Workflow Hero

Re: Implement Quota feature in Nintex Form

Jump to solution

Dear Philip,

I tried and work perfectly. Thanks a lot. ^^

Reply