I am struggling with a trigger, that should add all possible IDs from another table’s row to a specific record. When activated, the ‘visibility_all’ trigger should fill in all possible regions via an automation:
The automation method I use is “When a record matches conditions”, see here:
Everything works perfectly as long as I add the IDs manually from the other table, see here:
My question: Is there a way I can solve this not only more elegantly but maybe completely dynamic via either the correct way to use this automation or via script? (there are other visibility triggers like ‘teams’, that could grow in numbers and therefor would need manual updates in the future)
thank you in advance!