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.
maybe my error is to create a copy of the previous record?
For example, on the first Table I created this automation, but I want that even between Table 2 and Table 3 there's a connection to the same Record.
So I would that all the Table use the same record, some with more record column, other with less, other with different one. (because one I want to use for Marketing, so for example it needs more on contact information. When one of it is "accepted", and so I received the payment, I would like that the marketing team could change the status so on this change it will update the record on Backend table