Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Am I taking the right approach?

Topic Labels: Base design
359 1
Showing results for 
Search instead for 
Did you mean: 


I’ve created a base for tracking creating and programming events

Tab 1 - List of Events
Tab 2 - List of Event Costs
Tab 3 - Each cost is linked to an individual event i.e (‘Event 1 Travel Costs’) which creates a ledger for attaching paperwork etc

At the moment, when an new record is created in tab one, an automation creates around 80 new records which links each cost to the new event.

Is this the correct or is there a simpler or better way to do this?

1 Reply 1

Where is the automation creating the new records?

Based on the description you provide, I’m not sure why you need the 3rd tab. I would think you could link Events (tab 1) to Event Costs (tab 2).

Honestly, I will need more context for any more insight.