How to make independent the filter data of multiple users

[DaGi07]

Hello to everyone,

I have two tables. 1 data search (detail display with quick modification) and 1 slice that filters the searched data (in view table). I have shared the app with multiple users but when I search for the data, the other user sees the data I searched for. Instead I would like to make the research independent.

example: If User_1 searches for "A" , User_2 should not see "A" in the table view based on the slice.

I hope I have been clear

Thanks!

[Gustavo_Eduardo · Accepted solution]

You can use security filters. For example, create a column called [UserID] and set its formula expression to USEREMAIL().

Then, in the table’s security filter, write:

[UserID] = USEREMAIL()

This ensures that each user only sees the records they have entered.

Note:

• Make sure that every record in the table contains the corresponding user’s email and that the data is properly synced.

Alternative Approach Without Security Filters:

If you don’t want to use security filters, you can work with a slice:

[UserID] = "userName" OR USEREMAIL()

You can also use FILTER():

FILTER(
    "Table",
    [UserID] = "userName"
)

Hope this helps!

[Gustavo_Eduardo · Accepted solution]

You can use security filters. For example, create a column called [UserID] and set its formula expression to USEREMAIL().

Then, in the table’s security filter, write:

[UserID] = USEREMAIL()

This ensures that each user only sees the records they have entered.

Note:

• Make sure that every record in the table contains the corresponding user’s email and that the data is properly synced.

Alternative Approach Without Security Filters:

If you don’t want to use security filters, you can work with a slice:

[UserID] = "userName" OR USEREMAIL()

You can also use FILTER():

FILTER(
    "Table",
    [UserID] = "userName"
)

Hope this helps!

[Suvrutt_Gurjar · Accepted solution]

In general, you would need a Users table where there is one record for each app user to store her /his filter criteria. Each user's record should also have user's email. This arrangement ensures that each user's filter selection does not interfere with the other user.

Limit users to their own data using security filters - AppSheet Help

Now filtering records itself in some other table's based on user selection that is stored in Users table, you could use slice filters or security filters.

Both slice and security filters have distinct uses. With security filters , the filtered out data does not reach the user's device. So it  is a more secured mechanism to prevent non intended data from reaching a user's device. 

In case of slice filters entire table data reaches user's device but the app creator can create various views based on slice filters such as approved or WIP orders on an Orders table and so on.

Scale using security filters - AppSheet Help