Table with USEREMAIL() Security Filter shows record temporarily

[Daisy_Ramirez]

Hello, i have a dashboard screen where users enter in filter data on the left (quick edit detail view on parameters table) and the data displays on the right. Since I have a multi-user application, its important I allocate a dedicated row per user in that parameters table so they do not conflict user-to-user so I’ve decided to use USEREMAIL().

In the parameters table I have a record for each user email in the company and then set the security filter on the table to access the right user by using USEREMAIL(). When the user accesses the dashboard, they should see only their parameter record. The setup works great except they periodically lose visibility of the filter (quick edit detail view on parameters table)

What would cause the parameters record to no longer be visible in the dashboard screen?

[Aleksi]

Do you have a printscreen what that Dashboard view shows then?

[Daisy_Ramirez]

Hi Aleksi, unfortunately I do not have a screenshot as they say it happens sporadically. If I remember correctly the word Filters (in the above shot) is in place but the fields are missing.

[Aleksi]

Have they tried to refresh the browser in that situation?

[Daisy_Ramirez]

Yes, they mentioned having to do that over and over again.

Thanks Aleksi

[Daisy_Ramirez]

Hi Aleksi, is there anything else you can think that would cause this?

[Daisy_Ramirez · Accepted solution]

RESOLVED
Duplicate values in the key column caused the system some confusion on which record to display of course so the system continued to display the first record on the list. It required the user to view only their record (USEREMAIL()) so as one user would make a selection (into that first record) they would see it fine as the email address on the record would change to their email address but other users attempting to use the same record would see their record disappear.

Key column was expected to be unique but we reverted to a system generated unique id.