# Permission request in app **URL:** \ **Category:** Ask for Help\ **Created:** [August 27, 2021, 11:12pm UTC](https://community.glideapps.com/t/permission-request-in-app/31051 "2021-08-27T23:12:49Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Dolapo\_Amusan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dolapo_amusan/32/16764_2.png) [@Dolapo\_Amusan](https://community.glideapps.com/u/Dolapo_Amusan)\ **Post date:** [August 27, 2021, 11:12pm UTC](https://community.glideapps.com/t/permission-request-in-app/31051/1 "2021-08-27T23:12:49Z")
I am trying to create a friend request/permission request logic in my app. Here is my scenario I am trying to solve. Attached is a screenshot showing one of my sheets. For each email address, I need to compile into one column all the email addresses for which status is marked TRUE (checked box). That column will determine with whom each email can initiate an action later. In the final solution: [steverogers@gmail.com](mailto:steverogers@gmail.com) will have 2 emails ([harveyspecter@gmail.com](mailto:harveyspecter@gmail.com) and [ironman@avengers.com](mailto:ironman@avengers.com)) [ironman@avengers.com](mailto:ironman@avengers.com) will have 2 emails([steverogers@gmail.com](mailto:steverogers@gmail.com) and [hulk@avengers.com](mailto:hulk@avengers.com)) [harveyspecter@gmail.com](mailto:harveyspecter@gmail.com) will only have 1 email ([steverogers@gmail.com](mailto:steverogers@gmail.com)) because mikeross and jessica have not ticked yet. It doesn’t matter whether an email was the requester or receiver. They both count as a connection. I could be going about this solution a long way, but if there is a shorter way, I’d appreciate pointing me in the right direction. ![Screenshot 2021-08-28 at 00.02.53](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/5/650b7ae4274791e34bccd9bd8c9795d8080364a2.png) ---
**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:** [August 27, 2021, 11:19pm UTC](https://community.glideapps.com/t/permission-request-in-app/31051/2 "2021-08-27T23:19:57Z")
Assuming you have a user profiles sheet. - In this request sheet, create a template column joining the two emails separated by a comma. - Still in the same sheet, create an If Then Else column. If status is true then return the template column above, else empty. Let’s call this “Emails Joined”. - Continue with this, an ITE column to return the person to initiate with later on. Let’s call this “Email Initiate”. If “Emails Joined” does not contain signed-in user’s email then empty, if requester email is signed-in user then receiver’s email address, else requester email. - Finally, create a split text column, split the “Emails Joined” column by the comma. - Back to the profiles sheet, create a relation column to the request sheet, source being the user’s email, destination is the split text column. - Use a join text column to join the “Email Initiate” column. You should have what you want. ---
**Author:** ![Dolapo\_Amusan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dolapo_amusan/32/16764_2.png) [@Dolapo\_Amusan](https://community.glideapps.com/u/Dolapo_Amusan)\ **Post date:** [August 27, 2021, 11:39pm UTC](https://community.glideapps.com/t/permission-request-in-app/31051/3 "2021-08-27T23:39:27Z")
You are the best! This worked perfectly. Thank you very much!!! ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:50pm UTC](https://community.glideapps.com/t/permission-request-in-app/31051/4 "2024-01-17T16:50:40Z")