I’m trying to use air table to keep track of the production of limited edition objects.
For instance, my table is a limited edition of 30, numbered from 1 to 30. When I have a new order, I would like to be able to affect one of the remaining numbers to that order. For instance, if I have already sold 5 tables, numbers 1/30 to 5/30 cannot be selected anymore, and I should be able to pick the next remaining available value, in this case 6/30. Or even better the table could auto fill it for me.
How could I achieve this?