Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Apr 23, 2021 12:48 AM
Hi to the Community,
My issue concerns 2 tables, which are linked to each other :
What I’m trying to do is the following : let’s say the client buys Object A and Object B. I would like to automatically update the field “Status” (which is a Single select) in the “Objects” table for BOTH of the objects to “Sold”.
I tried many different things but it seems like it doesn’t work when multiple objects are selected…
Any chance someone could help ?
Thanks a lot !
Iris
Apr 23, 2021 11:37 AM
Why not have your Automation trigger based on the [Objects]
table instead? The trigger might by: when the {link to Transaction table} field is not empty
Or just use a Formula field for the {Status}
field instead to do this without an Automation. The formula might be: IF({link to Transaction table}, "Sold", "Not Sold")