Join two tables together

[chris102]

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? 

[Saravanan_009]

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.