Create an aggregate table of other different tables

2235 4
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Per the title, I would like to create a table (could be in a separate base if that is easier) that automatically or at least periodically updates with any new or changed rows from other tables.

Individual teams are going to be using project-specific tables that are formatted more or less the same so I would like to be able to automatically dump any new rows into one centralized table. The goal is to be able to use the API to dump the aggregated table into an RDS database and I worry that once multiple project teams are using it, I imagine it will become much more difficult to pull all of the new and changed records.

Is there a good way to go about solving this?

4 Replies 4
5 - Automation Enthusiast
5 - Automation Enthusiast

I’m also interested in this.

4 - Data Explorer
4 - Data Explorer

Hi Rob, did you find a solution to this?? I’m also very interested. Thanks

10 - Mercury
10 - Mercury

This is a common scenario people solve with our On2Air: Actions product.

You could also automate this with Zapier or Integromat.