Hi Team,
I am trying to get a referenced action to work, however it just isnt working. I am thinking it is to do with my referenced rows formula, as the individual action works great.!
Any help is greatly appreciated
Solved! Go to Solution.
Actions are commonly triggered in one of the following ways:
Each of these must be specifically configured to use a defined action.
Have you configured anything to invoke your actions?
When in Expression Assistant for the Referenced Rows expression, have you tried Test?
Is the ID column of the Quotes table the tableโs key column?
No, never mind all that. Your SELECT() expression is missing a reference to _THISROW:
SELECT(Quotes[ID],[ID]=[_THISROW].[Contract]))
Hi Steve,
That didnโt work unfortunately, and the ID column of the Quotes table is the key column.
The data is being recorded correctly, but for some reason the ref action is not firing.
In the expression builder the result is correct (the quote ID) of the line with or without using [_thisrow]
And to double check i simplified the original action to be [visits left]-1, but that hasnโt helped, so it really is the ref action not firing. I have set the condition to be โtrueโ, but what an underlying question is, what should cause the ref action to fire? Any changes to the visit_register table?
Actions are commonly triggered in one of the following ways:
Each of these must be specifically configured to use a defined action.
Have you configured anything to invoke your actions?
Hi Steve,
Oh what an idiot! i completely forgot about workflow to trigger it!
Thank you, thank you
User | Count |
---|---|
43 | |
30 | |
26 | |
14 | |
14 |