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! Go to 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
User | Count |
---|---|
15 | |
12 | |
9 | |
8 | |
4 |