Looking to reset Detail View "Search" field to blank once user selects from children

[Daisy_Ramirez]

Hello, I’m looking to reset a “search” field (Route Barcode) to blank once the user moves away from the screen.

-I’ve tried to use a set value action from the child table (execute an action on a set of rows) but it nothing happened.
-I attempted to use Reset on Edit but not sure it applies as its not until the user selects from the child records and moves to another screen that we’ll need the “search” box to reset to blank.

Any ideas or ways I can accomplish this?

[Marc_Dillon]

Daisy_Ramirez:

-I’ve tried to use a set value action from the child table (execute an action on a set of rows) but it nothing happened.

Let’s see what this looks like. This is probably how I’d do it in this situation. Setup a Grouped action for On Row Select of that child (inline?) table, to clear the value, then navigate to the child.

[Daisy_Ramirez]

Hi Matt, ok here goes:

[Marc_Dillon]

Looks like your grouped action has the navigation action first. Try to put it second. Any action after a navigation action won’t run.

[Austin]

I think they just run later to some degree or whatnot cause I had a similar thing ? not 100%

[Daisy_Ramirez]

Hi Marc, thanks for the tip but no luck. I did find some validations on the Route Barcode caused the field from populating but can now run the action on the form directly. Just can’t seem to run the set value action successfully from the child record.

Will keep at it. Thanks so much

[Steve]

In a grouped action, processing stops after the first navigation action performed. If your grouped action has a navigation action, make it the last action.

An action of type Data: set the values of some columns in this row must be performed by the row whose column values will be set. One row cannot directly set the values of columns in some other row.

To reset the parent’s search field, the child must use an action of type Data: execute an action on a set of rows referencing the parent row to perform a separate action of type Data: set the values of some columns in this row to clear the search field.

[Daisy_Ramirez · Accepted solution]

RESOLVED
Looks like I needed to be a bit more specific on my Referenced Rows so I replaced the “[Related Parameters Users]” with a SELECT statement:

Thanks everyone for the brain triggers