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
Hi @Daisy_Ramirez,
I believe you may wish to add a few more details for community colleagues to share relevant inputs.
Could you please add details such as
since category in filter table is in detail view , is it set as a quick edit column ?
When you mention “other screens”, does it mean a combination of detail view(s) from filter table and deck (or other) view(s) from some other table(s) put together in say various dashboard views? Or do you mean multiple users using the same view or screen.
Do all users use one single record and set of fields from the filter table to set the filters?
since category in filter table is in detail view , is it set as a quick edit column ? Yes, set as quick edit.
When you mention “other screens”, does it mean a combination of detail view(s) from filter table and deck (or other) view(s) from some other table(s) put together in say various dashboard views? Or do you mean multiple users using the same view or screen. multiple users using the same view or screen.
Do all users use one single record and set of fields from the filter table to set the filters? Yes, one single record for the app can be used by multiple uers
Thank you. It sounds that since multiple users are using the same record /fields, their settings could overlap. One thing you may wish to try is having a different record for each user in the filter table.
A similar requirement is discussed in the post mentioned below. In that post, please take a look at the discussion related to creation of user table. Hope this helps.
[Mutiple users interfering with each others actions](https://community.appsheet.com/t/mutiple-users-interfering-with-each-others-actions/17655) Questions
Hi, I have an order entry system and actions that allow a user to bulk change delivery dates for orders. I have a reference table which the user can edit to select the new chosen delivery date. Once that has been selected they then click an action button to change the select orders delivery dates to the new one. Is there a commonly used way of stopping another user from changing/interfering with the new chosen date in the time it takes the original user to select the new date and implement it…
Aha! I was just testing with USERSETTINGS - Thanks Steve!
Here’s the thing - I’m looking to have the data from the USERSETTINGS table appear as a field in my detail form. Can I reference USERSETTINGS in a SELECT statement so I can display the options?
Hi Suvrutt, thank you. Unfortunately, this is a publisher pro community app. USERSETTINGS would work perfectly, if only I could access the table and have the category field selection stored there from a detail form. The category field would be the most frequently used field in the app and users would not naturally go to Settings to continuously update the field.
Unfortunately, you cannot give the user access to modify a user setting from another table’s views; user settings can only be modified from the user settings form.
