I have multiple tables - one is the master table, the other tables are child tables. Records from the master table should be automatically linked to the child tables when they are created, based on a field that contains a matching value for the child table.
For example, I have tables:
Master, Project 1, Project 2, Project 3.
Master project contains a list of companies and field that lists their projects.
Project 1's table is supposed to contain *only* companies that are associated with Project 1
Within the master table there is a field labeled "Projects", which contains zero, one or more of "Project 1", "Project 2", "Project 3".
If the field contains "Project 1", it should be linked to the table named "Project 1"
If the field contains "Project 1" and "Project 2", it should be linked to both "Project 1" and "Project 2" tables.
Hoping to do this within Airtable Scripting, so that it is dynamic and able to update based on the table names.
My current code looks like this (using a button to create a new table for a project, and link records associated):
Solved! Go to Solution.
Hi Karen, is the intent to basically duplicate the entire table except records that don't match the project?
E.g. if the table has Field 1, Field 2, Field 3, two records of "Project 1" and one record of "Project 2", when clicking said button for one of the records of "Project 1" your desired output would be the entire table plus those two "Project 1" records?