We just rolled out a change to how you configure filtering data by the signed-in user (aka Per user data). Previously we had a dedicated checkbox to do that:
As a bonus you can now also show only the rows that do not match the signed-in user. As another bonus, you can also use the email filter in component visibility conditions.
We’ve also recently changed where you can set the email address to use to preview the app in the builder. It’s now in the “Preview as” button on the left panel:
This is fantastic. I already have a use case for the ‘isn’t signed-in user’.
I also foresee a lot of potential with using it in the visibility condition. People can add a relation on their sheets to an Admin sheet, use a lookup to get a list of admin emails, then set visibility to only show the components if the signed in user is in the list of admin emails.
From what I can see, single value only pulls the column value from the first row. It also won’t pull from an array column. No big deal though, because relation and lookup would still work.
This is great. Just need a public app now with sign in option. This signed In user will have been set up as admin (By app owner) so they can view, edit, delete their own entries (yeah we are never happy
