Action to update another table - not working

[Anna_Pedersen]

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

[Steve]

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]))

[Anna_Pedersen]

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?

[Steve · Accepted solution]

Anna_Pedersen:

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:

1. The user taps a button attached to the action.
2. The saving of a form invokes an action.
3. A workflow rule recognizes a trigger condition.

Each of these must be specifically configured to use a defined action.

Have you configured anything to invoke your actions?

[Anna_Pedersen]

Hi Steve,

Oh what an idiot! i completely forgot about workflow to trigger it!

Thank you, thank you