Waiting list numbering

Topic Labels: Base design
899 2
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

Hey all, thanks for the help in advance.

I want to maintain a waiting list in Airtable and can’t figure out how.

I have a client list with a single-select: “active” and “waiting” are the two relevant options here. I’d like each client with the “waiting” option selected to be assigned a number, each one integer larger than the last. Then I could use that number in formulas to estimate the waiting time for each person given their spot on the waiting list.

If I use the autonumber option I can’t exclude “active” clients, so the waiting list formula would skip numbers. For example,

John - active - 1 (shouldn’t have a number, but autonumber gives him one, anyway)
Mary - waiting - 2 (should be number 1 on the waiting list)
Frodo - active - 3 (shouldn’t have a number)
Sam - waiting - 4 (should be number 2 on the waiting list)

Does anybody know of a workaround for this, such that my list would read like this?

John - active - blank
Mary - waiting - 1
Frodo - active - blank
Sam - waiting - 2

2 Replies 2

Hi @Sigurdur_Hermannsson ,

Welcome to Airtable Community !

You might wanna use a script for that, because Im assuming you want to change the 2 to 1 once 1 is set to Active?

6 - Interface Innovator
6 - Interface Innovator

Yeah Mohamed, that’s exactly what I want. Guess I’ll go and learn about scripts, then! Thanks 😃