# Specific email in an array **URL:** \ **Category:** Ask for Help\ **Created:** [May 2, 2020, 7:25pm UTC](https://community.glideapps.com/t/specific-email-in-an-array/8364 "2020-05-02T19:25:32Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Dr\_Renee\_Volny\_Darko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dr_renee_volny_darko/32/4492_2.png) [@Dr\_Renee\_Volny\_Darko](https://community.glideapps.com/u/Dr_Renee_Volny_Darko)\ **Post date:** [May 2, 2020, 7:25pm UTC](https://community.glideapps.com/t/specific-email-in-an-array/8364/1 "2020-05-02T19:25:32Z")
Hi everyone, I’m creating an array using emails. But, I’d like one of those emails to always be set to the email of a specific user. Example. User 1 is signed-in user. User 2 is [jane@gmail.com](mailto:jane@gmail.com) Any insights? TIA! ---
**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:** [May 2, 2020, 8:02pm UTC](https://community.glideapps.com/t/specific-email-in-an-array/8364/2 "2020-05-02T20:02:09Z")
I would use an arrayformula to set the User 1 value on all rows within the sheet. Unfortunately you can’t create an array column within glide. Just be sure to delete any empty rows and add an if to the array formula to only fill the email if another column has a value in it. Otherwise you’ll run into other issues. ---
**Author:** ![Dr\_Renee\_Volny\_Darko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dr_renee_volny_darko/32/4492_2.png) [@Dr\_Renee\_Volny\_Darko](https://community.glideapps.com/u/Dr_Renee_Volny_Darko)\ **Post date:** [May 4, 2020, 1:25am UTC](https://community.glideapps.com/t/specific-email-in-an-array/8364/3 "2020-05-04T01:25:48Z")
Thank you, I’m not sure how to do this. How do I set an array formula on all the rows? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 4, 2020, 1:47am UTC](https://community.glideapps.com/t/specific-email-in-an-array/8364/4 "2020-05-04T01:47:01Z")
Hi, if I get you and Jeff’s idea right, this would be the set up I recommend: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/2/272297017875aca33ec9e198e8c7c81d347feda0.png) The first column is the user type, set “User 1” to any rows you want to set a fixed “[jane@gmail.com](mailto:jane@gmail.com)”, other rows can be anything. The second column is the signed-in email, which is automatically captured. The third column contains the formula: =ARRAYFORMULA(IF(A2:A\<\>"",IF(A2:A=“User [1","jane@gmail.com](mailto:1%22,%22jane@gmail.com)”,B2:B),"")) This fills the column if: - Column A is not blank - If column A is set to “User 1” then the final fixed email will be [jane@gmail.com](mailto:jane@gmail.com) - If column A is anything other than “User 1” then it will grab the signed-in email. Make sure you delete empty rows before doing this. Feel free to correct me if I got any of those points wrong. ---
**Author:** ![Dr\_Renee\_Volny\_Darko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dr_renee_volny_darko/32/4492_2.png) [@Dr\_Renee\_Volny\_Darko](https://community.glideapps.com/u/Dr_Renee_Volny_Darko)\ **Post date:** [May 4, 2020, 1:54am UTC](https://community.glideapps.com/t/specific-email-in-an-array/8364/5 "2020-05-04T01:54:22Z")
Ok… That makes sense. Gonna try it and let you know. Thanks ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 4, 2020, 1:58am UTC](https://community.glideapps.com/t/specific-email-in-an-array/8364/6 "2020-05-04T01:58:08Z")
Feel free to ask me if you need further assistance. If you have a specific condition to set a user to type “User 1” then the first column can also be done in an ARRAYFORMULA. The problem that Jeff mentioned, as I understand, is that when you use ARRAYFORMULA and don’t delete the empty rows first, new rows from the app will be added to (last empty row + 1). E.g: If you have 1000 rows in the sheet but only 3 at the top have data, new rows will be added to 1001, 1002, 1003, not 4, 5, 6. ---
**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:** [May 4, 2020, 2:46am UTC](https://community.glideapps.com/t/specific-email-in-an-array/8364/7 "2020-05-04T02:46:39Z")
Interesting…what’s your use case for this scenario? ---
**Author:** ![Dr\_Renee\_Volny\_Darko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dr_renee_volny_darko/32/4492_2.png) [@Dr\_Renee\_Volny\_Darko](https://community.glideapps.com/u/Dr_Renee_Volny_Darko)\ **Post date:** [May 4, 2020, 3:33am UTC](https://community.glideapps.com/t/specific-email-in-an-array/8364/8 "2020-05-04T03:33:12Z")
It’s for users to send a message to the admin. ---
**Author:** ![Dr\_Renee\_Volny\_Darko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dr_renee_volny_darko/32/4492_2.png) [@Dr\_Renee\_Volny\_Darko](https://community.glideapps.com/u/Dr_Renee_Volny_Darko)\ **Post date:** [May 4, 2020, 3:54am UTC](https://community.glideapps.com/t/specific-email-in-an-array/8364/9 "2020-05-04T03:54:54Z")
Cut and pasted the formula, but it keep giving me an ERROR. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 4, 2020, 4:00am UTC](https://community.glideapps.com/t/specific-email-in-an-array/8364/10 "2020-05-04T04:00:50Z")
[Here](https://docs.google.com/spreadsheets/d/1sEQHpSKyHx9w2F_Xx3lm56SU1p-8eI81OYU5TYvQFvw/edit#gid=490716599)’s the sheet where I set up the formula above, hope it helps. I have given you access to edit the sheet, so if you can, paste some random data for your case and I will work on it. ---
**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:** [May 4, 2020, 4:09am UTC](https://community.glideapps.com/t/specific-email-in-an-array/8364/11 "2020-05-04T04:09:07Z")
Formulas don’t paste well here. Usually it’s best to use the code blocks. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/051b18159b1fcfd5b2f1c35adb853484355ee07d.png) Usually the biggest issue is that the double quotes are converted to different double quotes. All that should need to be done is to just replace all double quotes with double quotes. Weird, but it works. ---
**Author:** ![Dr\_Renee\_Volny\_Darko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dr_renee_volny_darko/32/4492_2.png) [@Dr\_Renee\_Volny\_Darko](https://community.glideapps.com/u/Dr_Renee_Volny_Darko)\ **Post date:** [May 4, 2020, 4:34am UTC](https://community.glideapps.com/t/specific-email-in-an-array/8364/12 "2020-05-04T04:34:21Z")
You’re the MVP!!! Thanks, yet, again! You will have made my app successful with all of your help! ---
**Author:** ![Dr\_Renee\_Volny\_Darko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dr_renee_volny_darko/32/4492_2.png) [@Dr\_Renee\_Volny\_Darko](https://community.glideapps.com/u/Dr_Renee_Volny_Darko)\ **Post date:** [May 4, 2020, 4:35am UTC](https://community.glideapps.com/t/specific-email-in-an-array/8364/13 "2020-05-04T04:35:20Z")
Thank you so much for your help! Extremely useful! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 4, 2020, 4:46am UTC](https://community.glideapps.com/t/specific-email-in-an-array/8364/14 "2020-05-04T04:46:09Z")
No worries Renee, glad to help. Just post your issues here and we will try to assist, or you can email me at [ariesarsenal@gmail.com](mailto:ariesarsenal@gmail.com). ---
**Author:** ![Dr\_Renee\_Volny\_Darko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dr_renee_volny_darko/32/4492_2.png) [@Dr\_Renee\_Volny\_Darko](https://community.glideapps.com/u/Dr_Renee_Volny_Darko)\ **Post date:** [May 9, 2020, 12:10pm UTC](https://community.glideapps.com/t/specific-email-in-an-array/8364/15 "2020-05-09T12:10:34Z")
Morning! I wanted to update you on this. So, the Array formula isn’t quite working. Whenever a new row is added I get this: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/6/6d5bd2c5249436e3164ad1204bf3ec52e833ddc6.png) Only if I physically type the word “User 1” in the next row does it work. But that doesn’t work for the app. What am I doing wrong? Thanks for your help! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 9, 2020, 12:23pm UTC](https://community.glideapps.com/t/specific-email-in-an-array/8364/16 "2020-05-09T12:23:22Z")
It says there is data in C3. What is writing to that C3 cell? You clear it and the formula will work. Just make sure there is nothing below the formula cell in that column. Also, it would be a good practice to have your ARRAYFORMULA in the header column. As in: ``` ={"User 2";ARRAYFORMULA(IF...)} ``` You will never have to worry about accidentally deleting your first data row. ---
**Author:** ![Dr\_Renee\_Volny\_Darko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dr_renee_volny_darko/32/4492_2.png) [@Dr\_Renee\_Volny\_Darko](https://community.glideapps.com/u/Dr_Renee_Volny_Darko)\ **Post date:** [May 9, 2020, 12:36pm UTC](https://community.glideapps.com/t/specific-email-in-an-array/8364/17 "2020-05-09T12:36:03Z")
That’s what’s confusing. I deleted all the empty rows, so there is no C3. Also, not quite sure what you mean by ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/19195859497b1a1c64aaa66c797eddf1bb19c4b6.png) I’m definitely more tech savvy than the average person, but I still have a LOOOOONG way to go. Thanks! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 9, 2020, 12:42pm UTC](https://community.glideapps.com/t/specific-email-in-an-array/8364/18 "2020-05-09T12:42:17Z")
Can you send me a copy of what you are working on so that I can have a look (also I will show you the header column trick). ---
**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\ **Post date:** [May 9, 2020, 12:46pm UTC](https://community.glideapps.com/t/specific-email-in-an-array/8364/19 "2020-05-09T12:46:52Z")
The app is writing something in column C which is giving the error ---
**Author:** ![Dr\_Renee\_Volny\_Darko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dr_renee_volny_darko/32/4492_2.png) [@Dr\_Renee\_Volny\_Darko](https://community.glideapps.com/u/Dr_Renee_Volny_Darko)\ **Post date:** [May 9, 2020, 12:53pm UTC](https://community.glideapps.com/t/specific-email-in-an-array/8364/20 "2020-05-09T12:53:10Z")
> **[Copy of MEdEq](https://docs.google.com/spreadsheets/d/1y4J-H1RVCqr6zVsTEnxV-M9Xs8X-PFdW5JXB43rrIVA/edit?usp=sharing)** > > Admin Msgs > > User type,User 1,User 2,Date Started,Topic,Message,Conversation ID > User 1,jane@gmail.com,premedstrategiestv@gmail.com,4/20/2020,App problem,I can't set up my profile > User 1,premedstrategiestv@gmail.com This is a copy, so feel free to change it. Thanks! [Next page](https://community.glideapps.com/t/specific-email-in-an-array/8364.md?page=2)