- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 13, 2024 09:16 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 13, 2024 11:54 AM
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.
