🖋 Conditions for Edit and Delete

You can now set conditions on which items can be edited or deleted. For example, you might want all user profiles to be visible to everybody, but only editable by the user they belong to.

22 Likes

This is Huge! Nice addition, @Mark et. all!!!

3 Likes

Wow just stumbled upon this in one of my apps and thought I was seeing things. HUGE!

Create column: Role in a Profile sheet… relate/lookup that value from another sheet… Add edit condition based on that Lookup value in another sheet. Boom!

Edit… This doesn’t really work the way I want it to… the user who created the row is what is going to be related with… not necessarily the signed in user (who would be the Admin Role). There almost needs to be a way in the editor to get the value of the signed in user at any given time.

1 Like

:+1:t2::+1:t2::+1:t2:

We might be working on something like that :wink:

7 Likes

What about conditions for adding items?

What condition would you set for adding items?

is-admin based on admin rights set in a profile sheet

This is easily the happiest day for me on this platform. With 5 sheets in my Spreadsheet based on Query Copy functions to create non-editable vs editable versions, this one addition will cut the bulkiness of my Spreadsheet nearly in half and make further building on the app less stressful.

I can’t imagine a happier day… well the day the character limiter for text fields arrives, that may surpass it for me :wink:

Keep crushing it Glide Team!!!

5 Likes

Thanks !! I my requirement fulfill by this… :star_struck: :heart_eyes:

2 Likes

Already used this feature in a new app I’m working on! Fantastic!

2 Likes

We’ll get there.

2 Likes

:+1: :+1: :+1:

1 Like

This is massive…just in time for a soft launch of an app I am creating. Need to have a play around with it to get it working (clearing my diary for tomorrow) keep smashing it. Adalo and bubble watch you back glide is in town!

4 Likes

:laughing:

For this new function to be really useful, the login option must be optional. For users who are not registered, you can view the data without editing it.

3 Likes

Care to share?

Sneak peak:

4 Likes

Nice one :point_up:

Just curious what didn’t work? I think your relate/lookup situation would work just fine to get an array of admin emails. Then set up 2 filters with an OR to check if the signed in user is the creator of the row, or the signed in user is in the array of emails from the lookup to a sheet that lists the admins.
image