Hi gang… Wondering if my thinking is correct here and if anybody can help. Thanks in advance!
My app has users who can create simple contacts.
When they then create new items in the app they are each associated to a contact.
In the backend my app just writes a temporary email placeholder for these contacts in the items for the time being.
The catch is - users can then choose to link to their contacts by adding their email address. This then "syncs " items across users and their linked contacts.
When user chooses to link with their contact I need to go back via a relation (eg. “all items associated with contact”) and update the correct linked email address to replace the temporary one. This is so that the now linked contact can also become a row owner and view the item.
The issue I seem to be running into is that the set columns action can’t (yet??) work with multiple relations? It would be sooo painfully simple if this did.
Is there another fancy way that essentially “find and replaces” all the old temporary email placeholders with the updated email address when the contact profile is updated?