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