Change data in select rows when one is changed

For a little homemade CRM, I have one table listing in- and outbound emails. The table contains, among other things, the GMail message ID (key) and the thread ID.

I am manually sorting these mails to the respective projects by changing the project ID field.

Now, if I change this information (project ID) for ONE mail, I want my Bot to do the same for all other mails in the same thread. I'm assuming that will be done by running an action on a set of rows, BUT I can not figure out how to set up this action.

Bot trigger: Data change

Condition: [_THISROW_BEFORE].[ProjectID]<>[_THISROW_AFTER].[ProjectID]

Process: Run a data action

Referenced rows: select(Mails[Key];[ThreadID]=[_THISROW].[ThreadID])

Referenced action: ???

 

Any hints that might remove the blockage in my head would be appreciated, thanks!

Solved Solved
0 4 384
1 ACCEPTED SOLUTION

I never did it for update. But you must create an action that do this update. The problem is i think you can't pass parameter to your action. if it's effectively impossible, just create a table to store temporarily your new project id, that you will use in your update action

View solution in original post

4 REPLIES 4
Top Labels in this Space