# Cant use lookup in template column

**URL:** https://community.glideapps.com/t/cant-use-lookup-in-template-column/62707
**Category:** Ask for Help
**Created:** [June 13, 2023, 9:43am UTC](https://community.glideapps.com/t/cant-use-lookup-in-template-column/62707 "2023-06-13T09:43:26Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Bradley\_Gibson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bradley_gibson/32/58297_2.png) [@Bradley\_Gibson](https://community.glideapps.com/u/Bradley_Gibson)
#### Post date: [June 13, 2023, 9:43am UTC](https://community.glideapps.com/t/cant-use-lookup-in-template-column/62707/1 "2023-06-13T09:43:26Z")

</div>

Hi So I am trying to query a certain bin inside a storage location

The storage location in question called “Finished Product Store”.

I did a query in another table to get the default bin all incoming stock goes to and that bin is called “001”.

On the following table I used a lookup to get the default bin. I then use a combination of the product and bin number to create a key where I increment stock numbers.

 ![SCR-20230613-koao](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/3/33281cf449e40b4ce22a6b8bc5f4083b18446428.png)

 ![SCR-20230613-koma](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/6/f6df42809435bcd56a1f8f5c396392c7150b255b.png)

But its not allowing me to use the “001” in the template.

I checked and its not set to add multiple.

There is a query in an earlier step to check if the location within the warehouse is checked as default location and I set that to only return one value.

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: [June 13, 2023, 9:56am UTC](https://community.glideapps.com/t/cant-use-lookup-in-template-column/62707/2 "2023-06-13T09:56:16Z")

</div>

Your lookup is definitely returning an array. You can tell this by the presence of the “bubble” around the value. If you say that the relation is not a multiple relation, then you’ll have to trace it back a bit. What does the value look like in the table row at the other end of the relation?

Edit: Actually, it’s probably this 👇

> [@Bradley\_Gibson](#):
>
> There is a query in an earlier step to check if the location within the warehouse is checked as default location and I set that to only return one value.

The result of a query is always the same as that of a multiple relation, even if it only matches a single row. If you want an actual value from the Query result, then you should use a Single Value → First on the Query.

---

<div class="post-metadata">

### Author: ![Bradley\_Gibson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bradley_gibson/32/58297_2.png) [@Bradley\_Gibson](https://community.glideapps.com/u/Bradley_Gibson)
#### Post date: [June 13, 2023, 10:03am UTC](https://community.glideapps.com/t/cant-use-lookup-in-template-column/62707/3 "2023-06-13T10:03:49Z")

</div>

Genius. That work Perfectly!

---

<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: [June 14, 2023, 10:04am UTC](https://community.glideapps.com/t/cant-use-lookup-in-template-column/62707/4 "2023-06-14T10:04:02Z")

</div>

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