Creating an incrementing number

milad · August 10, 2016, 1:43pm

Hey Guys,

I’m making a signup sheet for an event and I want to assign a number value to each signup so I can give them different arrival times based on their “Queue number”.

So I wanna use the number to say: first 50 should arrive at 4pm, next 50 at 5pm. etc.

How do I make a field that auto-increments each time someone signs up and thus functions as their unique number?

vega.andrew · August 10, 2016, 3:40pm

Step 1 - Create a unique number column in the user table of type number and populate at least one user

Step 2 - When you are in your workflow (this one is triggered by a button), you will assign the current user’s Unique Number (column from previous step) to be “Search for User - Unique Number : max” and then add 1

milad · August 10, 2016, 4:34pm

Thanks!

christopheneel · February 8, 2017, 10:44pm

Hi, is there a special way to put “:max + 1” because i do not have the option…
best regards

luke2 · February 19, 2018, 2:03pm

The expression is specified within the workflow. However just make sure that the value you are changing incrementally is set as a number, in the data type fields. Using a text field I believe is not possible in this instance.

Hope this helps - I too was stumbling to try and find the fix

Best