Results visible in app - from other users?

T_R_C
New Member

Hi all - I am brand new to Appsheet and have developed my very first basic app.

I wanted to find out how to modify the results seen per user of the app. Currently when users are entering dragon IDs and doing the calculation to see the battle results - they see all other users results in the table. I would like them to see only their individual results. Hope that makes sense?

Any help would be greatly appreciated.

0 1 101
  • UX
1 REPLY 1

Welcome to the community!

First, you will want to tag each data row with the users login email to be able to identify it as โ€œbelongingโ€ to that user.


Then, there are two ways to filter the rows depending on your needs.

  1. If you simply want to create a View where the logged in user sees only their info BUT in other views may want to see their results compared with others, such as a ranking list, then I would recommend using a Slice that is filtered by the currently logged in user. The view you wish would use this Slice as its datasource.

  2. Maybe you wish the user to only ever see their info and never anyone elseโ€™s. While you still could use the Slice approach above, the downside is that all of those other user info is needlessly downloaded onto the device. In this case, I would recommend using Security Filters which will only download the rows that match the criteria - in this case the currently logged in user.


In both options above, you need to filter by the current user. There is an AppSheet Function named USEREMAIL() which provide this ability. It would be an expression as simple as

USEREMAIL() = [Data Row Email]

The same expression can be used either in the Slice filter criteria or the Security Filter criteria.

I hope this helps!!

Top Labels in this Space