Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Join two tables together

Topic Labels: Automations
586 1
cancel
Showing results for 
Search instead for 
Did you mean: 
chris102
4 - Data Explorer
4 - Data Explorer

I have two tables with the same fields

Table 1. Current Data (Read-only)

Table 2. Proposed Draft (Read/Write)

I want users to be able to edit records in the second table. Table 2 can then be submitted to a workflow. If approved, data from Table 2 will be joined to Table 1.

Essentially, is it possible to join (concatenate) one table to another with the same fields? 

1 Reply 1
Saravanan_009
8 - Airtable Astronomer
8 - Airtable Astronomer

Here's a simple approach:

Link the Tables: Create a linked record field in Table 2 that connects to Table 1. This allows you to reference and combine data between the tables.

Use Automation: Set up an automation that triggers when a record in Table 2 is approved. The automation would copy or move the data from Table 2 to Table 1, effectively updating Table 1 with the new data.

Concatenation: To "join" or concatenate records, use a formula field in Table 1 that combines values from the linked records. You can also use rollups to aggregate data from Table 2 into Table 1.

Scripted Solution: If more complex concatenation is required, use Airtable's scripting block to write a script that merges the data from Table 2 into Table 1.

This setup allows you to keep your current data in Table 1 untouched until changes in Table 2 are reviewed and approved.