Here is what I have managed so far:
• In the first table, when I confirm that the record is eligible through a single-select option, I have been able to:
1. Copy it to a second table dedicated to Marketing.
2. Copy it to a third table dedicated to the Backend.
What I am unable to do is:
1. When I activate a trigger in the Marketing table, I would like the record to update in the Backend table as well.
I have tried both reproducing the tables manually and individually copying the columns and using the "link to another record" function with tables in lookup.
The error I encounter is that sometimes it doesn't find the record, and other times it indicates that the input entered is not feasible.
In the end, it just needs to update a single-select field, nothing complicated. 🥹