I have a table that gets a lot of log data – about 8,000 records per month. Since a table can only hold 50,000 records and a base can only hold 100,000 records, I’d like to move the table to another base (on a given date or after a specified amount of time or when it reaches near capacity).
Is there a way to do this programmatically? Also, is there a way to create a base or table programmatically?
There is no easy way to do this programmatically.
You could use a synced table that retains the records after the originals are deleted. But when that table fills up, you need to manually sync to a different base.
You could use the REST API to copy data to a different target base, but you you still need a way to determine which target base to use as the target base fills up.
You could use our On2Air Actions app to copy the records into another table via an Upsert or our Create multiple records options.
We also have a bulk Delete records action, so once the data is duplicated, it’s deleted from the original table.
You can run it from an Airtable automation or Zapier.
We don’t currently have anything to create new tables, so you would just need to direct to a new table a couple of times a year.