

- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
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.