When data is not appearing where you expect it to

[calebsg]

Hi,

I suppose I have two questions. The first is, how can I view the app and troubleshoot from a user’s perspective? The ‘Preview as’ in the simulator does not appear to work for me. I cannot find any documentation about this.

The second question is related to my specific issue here. We have two tables (parent-child) called consults and referred_to that are referenced. I want the user to see any data in consults where their user ID is in the AssociateID column on that table. Or if their user ID is in the AssociateID column on the referred_to table. So in practical terms they can see their own consults as well as consults being referred to them.

I have this security filter on the consults table:
IF(USERSETTINGS(“My Consults Only”),
OR(
[referred_by]=USERSETTINGS(“UserID”),
IN([consult_id],
SELECT(referred_to[consult_id], [AssociateID] = USERSETTINGS(“UserID”))
)
),
TRUE)

And I have one view of Waitlisted consults that is shown in a slice with this filter:
AND([AssociateID]=USERSETTINGS(“UserID”),[Referral Status] = “Waitlisted”)

My challenge is that this all works fine for me as an Admin user but it does not work for my non-admin users. Using a SQL query on the database I can determine that there should be data showing for my users.

Thanks for any tips/ideas!