# Trying to retrieve a data and use template column

**URL:** https://community.glideapps.com/t/trying-to-retrieve-a-data-and-use-template-column/51961
**Category:** Ask for Help
**Created:** [October 18, 2022, 12:37am UTC](https://community.glideapps.com/t/trying-to-retrieve-a-data-and-use-template-column/51961 "2022-10-18T00:37:15Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Alexandre\_Caruso](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexandre_caruso/32/6240_2.png) [@Alexandre\_Caruso](https://community.glideapps.com/u/Alexandre_Caruso)
#### Post date: [October 18, 2022, 12:37am UTC](https://community.glideapps.com/t/trying-to-retrieve-a-data-and-use-template-column/51961/1 "2022-10-18T00:37:15Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/6/462336586be4c79e42f9500317da2022aec9f6ed.png)  
I’m trying to create a template column using a lookup column “NomeDoParceiro” but it´s not showing in the lookup column setup

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/5/95ee7833e780ea971a48df5fef99ed8cd0db245c.png)  
curiously the lookup column name does not appear in the list to be used in the template replacement field.

BTW, the name of the partner (“NomeDoParceiro” column in Portuguese) is correct.

what am I doing wrong?

---

<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: [October 18, 2022, 12:40am UTC](https://community.glideapps.com/t/trying-to-retrieve-a-data-and-use-template-column/51961/2 "2022-10-18T00:40:58Z")

</div>

> [@Alexandre\_Caruso](#):
>
> curiously the lookup column name does not appear in the list to be used in the template replacement field.

That’s because your lookup column is returning an array, and an array can not be used in a template.

If you need a lookup to return a single value via a relation, then that relation must be a _single_ relation.

---

<div class="post-metadata">

### Author: ![Alexandre\_Caruso](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexandre_caruso/32/6240_2.png) [@Alexandre\_Caruso](https://community.glideapps.com/u/Alexandre_Caruso)
#### Post date: [October 18, 2022, 1:58am UTC](https://community.glideapps.com/t/trying-to-retrieve-a-data-and-use-template-column/51961/3 "2022-10-18T01:58:00Z")

</div>

I’m not doubt u but how did u know that? I mean, how did u notice it?

I read this link [Single Relations | Glide Tutorial - YouTube](https://www.youtube.com/watch?v=jUWP_Lula8E)  
I thought it was a single relation  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/3/532a1ac104d63e78b7b84f9fb9e89de9f83e6548.png)

tks for your reply

---

<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: [October 18, 2022, 2:02am UTC](https://community.glideapps.com/t/trying-to-retrieve-a-data-and-use-template-column/51961/4 "2022-10-18T02:02:30Z")

</div>

> [@Alexandre\_Caruso](#):
>
> I’m not doubt u but how did u know that? I mean, how did u notice it?

I could tell by looking at your Lookup column. Even though there is just a single value, it is inside a “bubble”. This tells you that it is an array.

> [@Alexandre\_Caruso](#):
>
> I thought it was a single relation

It’s not, because you have the “Match multiple” box checked. This makes it a multiple relation.

---

<div class="post-metadata">

### Author: ![Alexandre\_Caruso](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexandre_caruso/32/6240_2.png) [@Alexandre\_Caruso](https://community.glideapps.com/u/Alexandre_Caruso)
#### Post date: [October 18, 2022, 2:12am UTC](https://community.glideapps.com/t/trying-to-retrieve-a-data-and-use-template-column/51961/5 "2022-10-18T02:12:53Z")

</div>

awesomeeeeeeeeee!! Every post one I learn sth new!

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/2/f2664844f376a8facc83c18dc6ab02dba9a5de0e.png)  
Man! Bubble it´s an array!! I thought it was only a cool design! :)))))))

Tk u so much! Live and Learn!

---

<div class="post-metadata">

### Author: ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)
#### Post date: [October 19, 2022, 2:12am UTC](https://community.glideapps.com/t/trying-to-retrieve-a-data-and-use-template-column/51961/6 "2022-10-19T02:12:54Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.