Can you create new records in multiple tables via 1 interface page?

Hi Andrea!

This is what the Interfaces are for, there you can handle creating multiple new dogs for a specific owner easily:

1. Owners List interface

Create a new List Interface page based on the Owner table and configure it to open a detailed record view of the Owners when you click (expand) one of the owner records.

2. Add a Linked Record Field for Dogs

On the Owner Detailed Record Interface page, you can add a linked record field that shows all of the Dogs associated with that Owner. Then change the display option to "View" and show as a list and select which fields to show.

3. Enable Inline Record Creation

When configuring that linked record section, enable the option to “Allow users to create new records” directly from the interface. This way, your team can click “+ Add” right from the Owner view and immediately create and link a new Dog to the Owner—all on one screen.

This is how you set-up / upgrade Airtable to be used as an App for internal processes.

This setup removes the need for scripting unless you want to batch-create multiple Dog records at once. If you're just creating a few at a time, this inline creation approach is fast and user-friendly.

Thank you, ​@mtrebinonixon . I feel real dumb because that is still not making sense to me.

Here’s the parent grid view and you can see some records have “Field Enrollment Data.” I have selected “Enable Inline Record Creation” but I’m not seeing where to do that. When I click on the “+” in the linked field, I’m only able to see records that are already created, I don’t have the option to create new ones. 

This is the same for when I expand the record. It says “+ Add Record” but again, that is just those already created. I’d like to be create a new one. 

Eureka! This is actually a synced table so I had to change those settings! THANK YOU!

As a direct response to your last post... 

• Have you enabled ad/delete records inline?
• You need to type some text for Airtable to “create” the record, until you add something it keeps the + greyed out. 
• If the primary field for the Field Enrollment table is a formula, it doesn’t take direct input, and so there’d probably be issues with adding new records in-line.

Now for the overall question, tbh I was going to suggest what you’re doing, a script or automation to generate the blank records to fill in. What I’d really suggest is playing around with some of the other interface templates to make something more approachable for general users. Taking your Owner->Dog example, perhaps a record review of the owner table, which you can configure to your liking. In those elements you can add an overall button that runs a script at the top of each review page, and you can also use the Button field type to run scripts from the extension dashboard, and those Button field types are functional in interfaces.

Forms-wise, Airtable doesn’t do linked record creation. You can look at Fillout for that (which is fabulous and is mentioned all the time here haha) if you really want to do this in a form manner.