Airtable Scripting — Create More Than 50 Records at a Time

Hi friends of Airtable! In this video you'll learn how to create more than 50 records at a time.

Useful links:

Keep building good stuff!
-----------------------------------------------

[transforminghate]

Hi Rupert, thank you for videos about scripting.

I was wondering if you can help with an issue using the new tool "Record Templates" As you might know it allows creating records with due dates, and dependencies, but I came across an issue: creating records is limited to 100 records per base.

We are a small company, and need this feature to automate our processes, and cant go to Enterprise account.

So I was wondering about ways to keep using the Record Template feature beyond the 100 record limit.

The issue is that we need to save different working templates for different cases in our business processes but we dont actually use them all the time, or even at the same time.
Having a record template is for us a way to have transparent processes saved, and they get rolled out when triggered. So we actually need to save way more options for Record Templates than 100.

1. Idea
Create different other bases with each 100 record template records, and sync the bases after the templates were used. This can already work, but it seems a bit complicated

2. Create Record Templates only with Automation and delete the template after it was used
The idea is to not save Record Templates, but instead create the template in the moment it gets selected (by any condition, like single select field). In that moment we would tell Airtable to create a specific record template, with the pre-specified tasks and to run all the tasks, and after to delete the template again. This way more templates could be pre-defined but dont actually get saved. Any ideas if this is possible, with scripting?

Looking forward to your feedback and ideas

Best
Yonatan