Help

Re: Is there a way for an automation to create multiple records?

32 0
cancel
Showing results for 
Search instead for 
Did you mean: 
hsat
4 - Data Explorer
4 - Data Explorer

Hi there,

I'm working on a Table where I input weekly sales figures and each Monday of every week. The columns are as follows: Sales > Shows (Linked Records to another Table) > Date.

Ideally, I'd like an automation to run to create say 30 new records with the date and Shows populated. This format stays the same every week, it's just that I want to remove the need to copy and paste, creating these from scratch every Monday, so all I need to do is enter the sales figures.

Any help would be greatly appreciated 🙂

1 Reply 1

Yeap you have a couple of options, all of them with the same trigger of "Run every Monday":
1. 30 "Create Record" actions
2. Have a table called "Template" where you set all the records / data templates, and have the automation use a "Find Record" step followed by a repeating group with a "Create Record" step: https://support.airtable.com/docs/repeating-groups-of-automation-actions
3. (If all the created records are linked to a single other record) Using a record template: https://support.airtable.com/docs/using-record-templates-in-airtable