Feb 07, 2024 02:01 PM
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. 🥹
Feb 07, 2024 07:57 PM - edited Feb 07, 2024 07:57 PM
Hmm, I'm not too sure what's wrong with your automation, but here's a working example setup of what I think you're looking for:
And you'll have to change the display to ID like so:
And here's a link to the base so you can view the automation
Feb 08, 2024 02:17 AM
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