# Built Template Column From Lookup or Relation Column?

**URL:** https://community.glideapps.com/t/built-template-column-from-lookup-or-relation-column/19944
**Category:** Ask for Help
**Created:** [December 16, 2020, 10:37am UTC](https://community.glideapps.com/t/built-template-column-from-lookup-or-relation-column/19944 "2020-12-16T10:37:25Z")
**Posts on this page:** 12
**Page:** 1

<div class="post-metadata">

### Author: ![al3xrods](https://avatars.discourse-cdn.com/v4/letter/a/b9e5f3/32.png) [@al3xrods](https://community.glideapps.com/u/al3xrods)
#### Post date: [December 16, 2020, 10:37am UTC](https://community.glideapps.com/t/built-template-column-from-lookup-or-relation-column/19944/1 "2020-12-16T10:37:25Z")

</div>

Hello !  
Does anyone knows any workaround the fact that it is impossible to make a template column from a lookup or relation column ? Thank you:)

---

<div class="post-metadata">

### Author: ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)
#### Post date: [December 16, 2020, 11:24am UTC](https://community.glideapps.com/t/built-template-column-from-lookup-or-relation-column/19944/2 "2020-12-16T11:24:36Z")

</div>

You should be able to use a Lookup that is generated from a single relation.

A relation is not a single “value” but rather a related row from another sheet.

Similarly, a Lookup from a multiple relation is bringing back multiple values, so a template wouldn’t know which values to include.

---

<div class="post-metadata">

### Author: ![Anton\_Rumyantsev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/anton_rumyantsev/32/50043_2.png) [@Anton\_Rumyantsev](https://community.glideapps.com/u/Anton_Rumyantsev)
#### Post date: [November 3, 2022, 10:45am UTC](https://community.glideapps.com/t/built-template-column-from-lookup-or-relation-column/19944/3 "2022-11-03T10:45:10Z")

</div>

I have a problem with only 1 relation. But in title it didnt shows

 ![Снимок экрана 2022-11-03 134245](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/e/8ecbc4f248ba802c29e1be96ff2420cb85984843.jpeg)

---

<div class="post-metadata">

### Author: ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)
#### Post date: [November 3, 2022, 11:08am UTC](https://community.glideapps.com/t/built-template-column-from-lookup-or-relation-column/19944/4 "2022-11-03T11:08:17Z")

</div>

If you’re trying to lookup the person’s name, select that column in your lookup. It seems like you’re pulling in their email and not their name.

---

<div class="post-metadata">

### Author: ![Anton\_Rumyantsev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/anton_rumyantsev/32/50043_2.png) [@Anton\_Rumyantsev](https://community.glideapps.com/u/Anton_Rumyantsev)
#### Post date: [November 3, 2022, 11:10am UTC](https://community.glideapps.com/t/built-template-column-from-lookup-or-relation-column/19944/5 "2022-11-03T11:10:00Z")

</div>

yes i try to pull email and telephone from user’s sheet. the relations by name

---

<div class="post-metadata">

### Author: ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)
#### Post date: [November 3, 2022, 11:11am UTC](https://community.glideapps.com/t/built-template-column-from-lookup-or-relation-column/19944/6 "2022-11-03T11:11:33Z")

</div>

You’ll need multiple lookup columns to pull in which ever fields you need.

---

<div class="post-metadata">

### Author: ![Anton\_Rumyantsev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/anton_rumyantsev/32/50043_2.png) [@Anton\_Rumyantsev](https://community.glideapps.com/u/Anton_Rumyantsev)
#### Post date: [November 3, 2022, 11:14am UTC](https://community.glideapps.com/t/built-template-column-from-lookup-or-relation-column/19944/7 "2022-11-03T11:14:26Z")

</div>

exactly like you said. i have different columns for each

 ![Снимок экрана 2022-11-03 141322](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/6/561462f9d880f2937aba24df4ae61f09f57dde9f.jpeg)

---

<div class="post-metadata">

### Author: ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)
#### Post date: [November 3, 2022, 11:21am UTC](https://community.glideapps.com/t/built-template-column-from-lookup-or-relation-column/19944/8 "2022-11-03T11:21:26Z")

</div>

Looks good. Is there still a problem?

---

<div class="post-metadata">

### Author: ![Anton\_Rumyantsev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/anton_rumyantsev/32/50043_2.png) [@Anton\_Rumyantsev](https://community.glideapps.com/u/Anton_Rumyantsev)
#### Post date: [November 3, 2022, 11:25am UTC](https://community.glideapps.com/t/built-template-column-from-lookup-or-relation-column/19944/9 "2022-11-03T11:25:05Z")

</div>

yes =(

 ![Снимок экрана 2022-11-03 142436](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/3/732edd82b5306879636e84ed8d012664689b1712.jpeg)

---

<div class="post-metadata">

### Author: ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)
#### Post date: [November 3, 2022, 11:26am UTC](https://community.glideapps.com/t/built-template-column-from-lookup-or-relation-column/19944/10 "2022-11-03T11:26:54Z")

</div>

Do you have Row Owners enabled on your User Profile table? If you do, users can only view their own information, even if it’s displayed through a relation. If you don’t need all user profile information protected/secured, remove the Row Owner from the email column and that should fix your issue.

---

<div class="post-metadata">

### Author: ![Anton\_Rumyantsev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/anton_rumyantsev/32/50043_2.png) [@Anton\_Rumyantsev](https://community.glideapps.com/u/Anton_Rumyantsev)
#### Post date: [November 3, 2022, 11:30am UTC](https://community.glideapps.com/t/built-template-column-from-lookup-or-relation-column/19944/11 "2022-11-03T11:30:01Z")

</div>

oh, thank you!

---

<div class="post-metadata">

### 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 12, 2024, 1:39am UTC](https://community.glideapps.com/t/built-template-column-from-lookup-or-relation-column/19944/12 "2024-01-12T01:39:08Z")

</div>


