Filter by signed-in user

Hey Gliders!

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:

2020-01-16 11.46.16

Now it’s integrated into the filter UI:

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:

2020-01-16 11.51.06

Let us know what you think!

Cheers!

5 Likes

This is great, thanks. The previous version keeps working?

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.

1 Like

Your existing filters are converted to the new configuration.

1 Like

Yes, you can do that. A Single Value would probably be easier than a Lookup, though.

1 Like

Ahh, great point. Does a single value allow for an array of values, in the case of multiple administrators?

1 Like

Yes, Single Value should work on all column types.

1 Like

Glide features = Getting better all the time.

4 Likes

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.

I’ll look into it.

1 Like

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 :smiley: