# Relation - Lookup of APP SALES Tab

**URL:** <https://community.glideapps.com/t/relation-lookup-of-app-sales-tab/13875>\
**Category:** Feature Requests\
**Created:** [August 12, 2020, 9:41am UTC](https://community.glideapps.com/t/relation-lookup-of-app-sales-tab/13875 "2020-08-12T09:41:07Z")\
**Posts on this page:** 7\
**Page:** 1

<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:** [August 12, 2020, 9:41am UTC](https://community.glideapps.com/t/relation-lookup-of-app-sales-tab/13875/1 "2020-08-12T09:41:07Z")

</div>

I want to be able to created a relation/lookup (within Glide Data Editor) of the APP:SALES tab Want to look up and join profile email with APP: SALES email.  
 ![Screenshot 2020-08-12 at 10.35.32](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/8bc6225fa59f3320befb07c083a291b992b20303.png)

---

<div class="post-metadata">

**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\
**Post date:** [August 12, 2020, 10:00am UTC](https://community.glideapps.com/t/relation-lookup-of-app-sales-tab/13875/2 "2020-08-12T10:00:36Z")

</div>

Not the most elegant solution, but you can create a new tab in your workbook that will query the App: Sales tab and duplicate the information. This tab is readable in Glide builder and you can use it.

---

<div class="post-metadata">

**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\
**Post date:** [August 12, 2020, 10:01am UTC](https://community.glideapps.com/t/relation-lookup-of-app-sales-tab/13875/3 "2020-08-12T10:01:17Z")

</div>

Just noticed that this was posted as a Feature Request, and I agree. 🙂

---

<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:** [August 12, 2020, 10:02am UTC](https://community.glideapps.com/t/relation-lookup-of-app-sales-tab/13875/4 "2020-08-12T10:02:06Z")

</div>

Nice idea, thanks. Hoping one day it will be something we can just do in glide

I will in the meantime just create a new tab and use this formula

={‘App: Sales’!A:Z}

---

<div class="post-metadata">

**Author:** ![vijay](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vijay/32/3259_2.png) [@vijay](https://community.glideapps.com/u/vijay)\
**Post date:** [September 10, 2020, 3:50am UTC](https://community.glideapps.com/t/relation-lookup-of-app-sales-tab/13875/5 "2020-09-10T03:50:56Z")

</div>

I am trying to do the above using this formula ={‘App: Sales’!A:Z}. But, it is giving me a formula parse error. May I know where is this formula to be inserted? I create a new sheet and inserted this formula in the first cell of the google sheet which is A1. But, I get a formula parse error. I already have the App: Sales sheet.

---

<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:** [September 10, 2020, 3:54am UTC](https://community.glideapps.com/t/relation-lookup-of-app-sales-tab/13875/6 "2020-09-10T03:54:06Z")

</div>

Try replacing the single quotes. Sometimes they post weird in the forum and they are actually a different character from what the sheet recongnizes as a single quote.

---

<div class="post-metadata">

**Author:** ![vijay](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vijay/32/3259_2.png) [@vijay](https://community.glideapps.com/u/vijay)\
**Post date:** [September 10, 2020, 3:55am UTC](https://community.glideapps.com/t/relation-lookup-of-app-sales-tab/13875/7 "2020-09-10T03:55:07Z")

</div>

Thanks, That worked! 💓