I’ve been building an app through the free trial and have hit a snag. I’m aware Airtable won’t let you create new Linked Records in a form. Fillout doesn’t have the capacity for a price my boss is willing to pay. I’ve been using Gemini quite a bit which has been helpful, and they suggested something that would work but I wanted your opinion (Confidently incorrect AI’s and all that).
My tables in question are “Customers” which can have many “Locations” and “Contacts”. Locations can have many “Jobs”. If I create a job and the customer doesn’t exist, I have to leave to make the customer, only to remember that I don’t have the contact or location, so I have to leave and do those, repeat ad-nauseum.
Gemini’s suggestion is to create a master intake table. For the customer, I could select from a dropdown (as usual), but if it’s a new customer, I would fill in new fields for the customer information. Repeat with Location, Contacts, and the Job details. Then use automation to parse the data and create the relevant records in the appropriate tables.
This would work, but I’m afraid it’s clunky and a pain to maintain. If I decide to track contacts birthdays, I then have to remember to also add that information to the intake form.
I would then also have to do this for materials used, tracking visits to site, etc. etc.
Is waiting for native Airtable allowing adding new linked records my only other option?




