# 🖋 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:** 1\
**Showing post:** 24

<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 8, 2020, 2:33pm UTC](https://community.glideapps.com/t/conditions-for-edit-and-delete/5225/24 "2020-03-08T14:33:38Z")

</div>

@kyleheney What I’m doing in my example is what you describe in your Edit2. Have an “admin” value in the sheet, create a multiple relation to an admins sheet that has the same “admins” value, then create a lookup that pulls all the admin emails. You have to make sure the admin records are in rows instead of columns. You would only have one email column in the admins sheet.

In my screenshot, Email 1 is just a single email column of the row owner. Lkup-Admins is a lookup array of multiple values from a sheet that has multiple rows.

Filtering by signed in user works great with an array created from a lookup

I’ve had a problem in the past with what @Robert_Petitto is saying. I wasn’t able to successfully do a lookup into an array to create a super-array inside the lookup.  
I haven’t tested this, but I’m assuming this may be the issue you have had with doing a lookup into an array column on the related sheet.

> [@Lookup against an array of column](https://community.glideapps.com/t/lookup-against-an-array-of-column/3352):
>
> I’m not sure if this is a bug, but I have a sheet with 2 email columns ‘Email 1’ and ‘Email 2’. I am attempting to create a relation column within the same sheet that links the Email array to the same Email array. I know this seems weird, but I’m doing this to pull back a relation of all rows that contain at least one of the two emails. The relation appears to be working just fine. What I want to do is then create a Lookup column against the relation that pulls back every email, from the Ema…

---

_[View the full topic](https://community.glideapps.com/t/conditions-for-edit-and-delete/5225)._