Happy New Year, Airtabletons. I hope 2022 is good to you all.
Here is my scenario. I have a table which is populated with all our employees, freelancers and contacts. Using a combination of manual entry and linked records I then populate a 2nd table with only our employees and freelancers which is then used to construct an org chart.
My question is, is there a way to automatically copy the contents of a cell from the master table to the 2nd table IF the record contains a certain company name within it’s record?
So for example: If a record within TableA contains “CompanyA” or “CompanyB” I want to have the first cell of that record entered into a new line on TableB.
I hope that makes sense guys.
Thanks in advance for your time.