Short version: Why can’t airtable enforce unique entries for record IDs? This is an important feature and not having it is screwing me up.
Long version: Continuing to spend most of my time working around Airtable’s billing policy. I’ve got a table where users will create work chits indicating they’ve worked x volunteer hours doing whatever. I’ve got 20 chit approvers and I really can’t afford to pay for 20 more users who will only doing approvals a few times per year. So, I’ve got a field in the Chit table that concatenates a URL which is then used to generate a link that goes in an email to the approver. When the approver clicks the link, it opens a new form for a new Approved Chit table and prefills the inputs with the values from the corresponding Chit record.
I was really hoping to use the autonumber from the chit table to populate the Record ID for the Chit Approval table. My plan was to turn on unique enforcement for the Chit Approval table. But just realized that this feature doesn’t exist. My thinking was that by requiring uniqueness on the Chit Approval table, I would ensure that each chit can only generate one chit approval record.
I’m not sure how to work around this one. Any suggestions mightily appreciated. But tired of spending all my energies to work around billing policies and really wishing that there was some policy based on usage rather than number of users.