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 whe...
In the form edit view, a record selector shows multiple fields, nicely formatted:
But with the same data, the actual form only shows the index field:
How come I can’t show the better, fuller selector that is displayed in the edit view on the live f...
I’m a big fan of Airtable, and I think I have convinced my boat club to use it as our place for member data, sail plans, etc. But, our club has about 20 people who have a task of reviewing and approving of volunteer work chits. I can easily see how...
So, I made a calendar view based on a calculated field. Everything in the calculation seems correct and items appear in the proper spots within the calendar. But every entry on the calendar begins by showing the month in the date calculation. Why? ...
I would like to create a form that lets my club members update their own information and then use Zapier to update their actual record. The 3 step Zap example for this works fine, but I don’t want to require my members to populate the fields that do...
So here’s my workaround… I created a table chits. Chits are created by volunteers (club members.) Each Chit includes a formula field for a prefilled form. When a new chit is created, a ZAP sends a message to the appropriate approver with a link fo...
Thanks, but my goal isn’t to make sure that each record in the Chit Approvals is unique. My goal is to ensure that each prefilled form link can only generate one record in the Chits Approval table. If I could use the Record_ID() from the chit recor...
Thanks! This looks promising. I will give it a try. So, I’m going to end up with a table of submitted chits and another, near-identical table with all the same fields and an additional approval field. That’s not too painful. I like the fact that ...
Thanks very much. I’m going to give it a try, but I see a couple problems with this:
Filtering the records: Each approver would want to see only their records, but there doesn’t seem to be a way to filter the selections. I could of course grant the...
