Hello, I have a detail view designed for users to select a category from a dropdown and view the results in a deck view. The filter field is based directly on a table (filters table) so when the user makes their selection, that selection is stored in the filter table. When the same filter is used in other screens their last selection is still in the field causing a bit of confusion for the user and others using the app.
How can I set it up so when the user moves away from the form, the field is cleared or somehow not store the data to begin with since the user is simply using it as a filter? I’ve tried Reset on Edit but the field is the only one being accessed so no other edits to the “record” exists.
Appreciate any ideas on this one - stumped. Thanks