# Data from another table

**URL:** https://community.glideapps.com/t/data-from-another-table/45516
**Category:** Ask for Help
**Created:** [July 29, 2022, 11:17am UTC](https://community.glideapps.com/t/data-from-another-table/45516 "2022-07-29T11:17:47Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Ovi](https://avatars.discourse-cdn.com/v4/letter/o/3ab097/32.png) [@Ovi](https://community.glideapps.com/u/Ovi)
#### Post date: [July 29, 2022, 11:17am UTC](https://community.glideapps.com/t/data-from-another-table/45516/1 "2022-07-29T11:17:47Z")

</div>

Hello to all,

Can I reference data from another table in a custom function like vlookup or if-then-else or something similar to relations ?

Recording

Thank you.

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [July 29, 2022, 11:27am UTC](https://community.glideapps.com/t/data-from-another-table/45516/2 "2022-07-29T11:27:05Z")

</div>

You need a Relation column and a Lookup column. Suggest reviewing the following information:

> **[Relations](https://docs.glideapps.com/all/product/data-editor/relations#single-relations)**

> **[Lookup Column](https://docs.glideapps.com/all/topics/computed-columns/primary/lookup-column)**
>
> Lookup values from another table

---

<div class="post-metadata">

### Author: ![Ovi](https://avatars.discourse-cdn.com/v4/letter/o/3ab097/32.png) [@Ovi](https://community.glideapps.com/u/Ovi)
#### Post date: [July 29, 2022, 1:41pm UTC](https://community.glideapps.com/t/data-from-another-table/45516/3 "2022-07-29T13:41:21Z")

</div>

I looked into those but if the data in the users table has a row owner, that data still will not be available only with a relation. Any other suggestions … even an excel formula will help

---

<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: [July 29, 2022, 1:49pm UTC](https://community.glideapps.com/t/data-from-another-table/45516/4 "2022-07-29T13:49:19Z")

</div>

No, if row owners are applied, then only the owned data is available to work with.

---

<div class="post-metadata">

### Author: ![Ovi](https://avatars.discourse-cdn.com/v4/letter/o/3ab097/32.png) [@Ovi](https://community.glideapps.com/u/Ovi)
#### Post date: [July 29, 2022, 2:24pm UTC](https://community.glideapps.com/t/data-from-another-table/45516/5 "2022-07-29T14:24:15Z")

</div>

I’ve had an idea but it doesn’t work as I expected for photos …  
so, I’ve created a button that triggers an action to add a row with that user’s data in another table … all good but the photo field is not completed … is this a bug that can be resolved ?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/1/0158c8cabc68c6ba95fbf4dec8a267d383e43a82.jpeg)

---

<div class="post-metadata">

### Author: ![Ovi](https://avatars.discourse-cdn.com/v4/letter/o/3ab097/32.png) [@Ovi](https://community.glideapps.com/u/Ovi)
#### Post date: [July 29, 2022, 2:34pm UTC](https://community.glideapps.com/t/data-from-another-table/45516/6 "2022-07-29T14:34:12Z")

</div>

It works know … sorry for the trouble … the first action didn’t worked properly , but now it works great and I can create what I want like this and also keep the users table secured with row owners. Thanks.