# 🖋 Conditions for Edit and Delete

**URL:** <https://community.glideapps.com/t/conditions-for-edit-and-delete/5225>\
**Category:** General\
**Created:** [March 6, 2020, 12:13am UTC](https://community.glideapps.com/t/conditions-for-edit-and-delete/5225 "2020-03-06T00:13:32Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [March 6, 2020, 12:13am UTC](https://community.glideapps.com/t/conditions-for-edit-and-delete/5225/1 "2020-03-06T00:13:32Z")

</div>

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.

 ![2020-03-05 16.11.06](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/f198cfa15b002f5a519bd905f3fd9283915a3c85.gif)

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [March 6, 2020, 12:14am UTC](https://community.glideapps.com/t/conditions-for-edit-and-delete/5225/2 "2020-03-06T00:14:37Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [March 6, 2020, 12:20am UTC](https://community.glideapps.com/t/conditions-for-edit-and-delete/5225/3 "2020-03-06T00:20:16Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Christophe\_HK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christophe_hk/32/4161_2.png) [@Christophe\_HK](https://community.glideapps.com/u/Christophe_HK)\
**Post date:** [March 6, 2020, 12:44am UTC](https://community.glideapps.com/t/conditions-for-edit-and-delete/5225/4 "2020-03-06T00:44:03Z")

</div>

👍🏻👍🏻👍🏻

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [March 6, 2020, 1:05am UTC](https://community.glideapps.com/t/conditions-for-edit-and-delete/5225/5 "2020-03-06T01:05:08Z")

</div>

> [@kyleheney](#):
>
> There almost needs to be a way in the editor to get the value of the signed in user at any given time.

We might be working on something like that 😉

---

<div class="post-metadata">

**Author:** ![gila](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gila/32/2961_2.png) [@gila](https://community.glideapps.com/u/gila)\
**Post date:** [March 6, 2020, 1:24am UTC](https://community.glideapps.com/t/conditions-for-edit-and-delete/5225/6 "2020-03-06T01:24:13Z")

</div>

What about conditions for adding items?

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [March 6, 2020, 1:24am UTC](https://community.glideapps.com/t/conditions-for-edit-and-delete/5225/7 "2020-03-06T01:24:52Z")

</div>

What condition would you set for adding items?

---

<div class="post-metadata">

**Author:** ![gila](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gila/32/2961_2.png) [@gila](https://community.glideapps.com/u/gila)\
**Post date:** [March 6, 2020, 2:10am UTC](https://community.glideapps.com/t/conditions-for-edit-and-delete/5225/8 "2020-03-06T02:10:11Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![John\_Cabrera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/john_cabrera/32/2066_2.png) [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)\
**Post date:** [March 6, 2020, 2:26am UTC](https://community.glideapps.com/t/conditions-for-edit-and-delete/5225/9 "2020-03-06T02:26:54Z")

</div>

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 😉

Keep crushing it Glide Team!!!

---

<div class="post-metadata">

**Author:** ![Bhupendra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bhupendra/32/788_2.png) [@Bhupendra](https://community.glideapps.com/u/Bhupendra)\
**Post date:** [March 6, 2020, 4:00am UTC](https://community.glideapps.com/t/conditions-for-edit-and-delete/5225/10 "2020-03-06T04:00:01Z")

</div>

Thanks !! I my requirement fulfill by this… 🤩 😍

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [March 6, 2020, 4:28am UTC](https://community.glideapps.com/t/conditions-for-edit-and-delete/5225/11 "2020-03-06T04:28:35Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [March 6, 2020, 4:30am UTC](https://community.glideapps.com/t/conditions-for-edit-and-delete/5225/12 "2020-03-06T04:30:20Z")

</div>

> [@gila](#):
>
> is-admin based on admin rights set in a profile sheet

We’ll get there.

---

<div class="post-metadata">

**Author:** ![gila](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gila/32/2961_2.png) [@gila](https://community.glideapps.com/u/gila)\
**Post date:** [March 6, 2020, 4:31am UTC](https://community.glideapps.com/t/conditions-for-edit-and-delete/5225/13 "2020-03-06T04:31:04Z")

</div>

👍 👍 👍

---

<div class="post-metadata">

**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\
**Post date:** [March 6, 2020, 7:02am UTC](https://community.glideapps.com/t/conditions-for-edit-and-delete/5225/14 "2020-03-06T07:02:45Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\
**Post date:** [March 6, 2020, 8:53am UTC](https://community.glideapps.com/t/conditions-for-edit-and-delete/5225/15 "2020-03-06T08:53:06Z")

</div>

😆

---

<div class="post-metadata">

**Author:** ![Alex\_Calandrino](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alex_calandrino/32/335_2.png) [@Alex\_Calandrino](https://community.glideapps.com/u/Alex_Calandrino)\
**Post date:** [March 6, 2020, 1:04pm UTC](https://community.glideapps.com/t/conditions-for-edit-and-delete/5225/16 "2020-03-06T13:04:32Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\
**Post date:** [March 6, 2020, 7:10pm UTC](https://community.glideapps.com/t/conditions-for-edit-and-delete/5225/17 "2020-03-06T19:10:12Z")

</div>

Care to share?

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [March 6, 2020, 7:24pm UTC](https://community.glideapps.com/t/conditions-for-edit-and-delete/5225/18 "2020-03-06T19:24:22Z")

</div>

Sneak peak:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/90fc0c387480e45948fdca0e4d8831240cf29d79.jpeg)

---

<div class="post-metadata">

**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\
**Post date:** [March 7, 2020, 4:17am UTC](https://community.glideapps.com/t/conditions-for-edit-and-delete/5225/19 "2020-03-07T04:17:42Z")

</div>

Nice one ☝

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [March 7, 2020, 9:53pm UTC](https://community.glideapps.com/t/conditions-for-edit-and-delete/5225/20 "2020-03-07T21:53:54Z")

</div>

> [@kyleheney](#):
>
> 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.

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](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/5/54db2d0f9c7c438f40ec9d222af934f08f38c166.png)

[Next page](https://community.glideapps.com/t/conditions-for-edit-and-delete/5225.md?page=2)
