I have a table (let’s call it Table 2), with multiple records, each record represents a company ie. Apple, Google, Microsoft and each record has multiple fields with associated company information.
These records are copied from another table (let’s call it Table 1) [which is a synced table].
I have setup an automation where:
If a record is updated on Table 1, the corresponding record is found on Table 2 and is overwritten with information from the updated record.
So, if company information on (say) Apple changes on Table 1, Apple is found on Table 2 and updated.
This automation works fine - it’s a “When record is updated on Table, find record (using Record ID) & update record on Table 2”
Annoyingly, it breaks whenever there is more than one Apple on Table 2 (we have several instances of the same company listed - but with different tags attached)
Is it possible to setup a script that will find and update each record, one after another … so if there’s 3 records with Apple as the company name, it will go through and update them one after the other.
Any help would be massively appreciated!
As an alternative, you could perhaps try the following instead:
With reference to your example above, that one
Apple record from Table 1 will now be linked to all the instances of
Apple on Table 2 that have different tags attached
Have another automation that has a trigger of “When record matches conditions” and looks at the records in Table 2, where the linked field to Table 1 is not empty
I believe this should do what you’re looking for when record for
Apple in Table 1 is updated, all the records in Table 2 for
Apple will also be updated
(You can also hire me to set up either the script or the above automations for you too!)