Hey everyone! So I’m having some issues with a series of On Save Form actions… Was wondering if you had any thoughts?
Here’s my setup:
-I have a table of bands, and a table for user logs.
-I’ve setup an action in the bands table which resets a few columns to blank
-I’ve setup an action in the user logs table which fires the bands table action.
In my dash when when I select the “Resolve action” in the detail view of a band, the user is taken to the user logs form asking the result of the interaction.
If the user selects “Reset data” under the [Result] column in the above form then upon save the app is supposed to fire the aforementioned User logs action, which then fires the clear data action in the bands table.
There are other [Result] options which do other things, which is why it’s setup this way.
But my issue is that upon save, the actions don’t appear to be firing?
The user logs action is listing all rows where the column [BID] is equal to the [ID] Column of the bands table using : FILTER(Bands,[ID]=[_THISROW].[BID])
And The condition is [Result]=“Reset Data”
That should fire the action at the referenced band in the bands table correct?
Am I missing something? Thanks everyone for your time, and help over the past few months!