# How to pull in information from multiple tables for use in Template

**URL:** <https://community.glideapps.com/t/how-to-pull-in-information-from-multiple-tables-for-use-in-template/73895>\
**Category:** Ask for Help\
**Created:** [June 5, 2024, 4:10pm UTC](https://community.glideapps.com/t/how-to-pull-in-information-from-multiple-tables-for-use-in-template/73895 "2024-06-05T16:10:58Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Todd\_Lichtenwalter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_lichtenwalter/32/12231_2.png) [@Todd\_Lichtenwalter](https://community.glideapps.com/u/Todd_Lichtenwalter)\
**Post date:** [June 5, 2024, 4:10pm UTC](https://community.glideapps.com/t/how-to-pull-in-information-from-multiple-tables-for-use-in-template/73895/1 "2024-06-05T16:10:58Z")

</div>

I tried making a Template column by using Lookups to pull in data from other tables IF-THEN-ELSE columns and use the data as template variables, but they are not showing up as an option to use as variables. Is there a way to convert the ITE column information into a text or other template variable useable format in the source tables so they can then be brought into the Template’s table for use as a variable?

---

<div class="post-metadata">

**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\
**Post date:** [June 5, 2024, 6:07pm UTC](https://community.glideapps.com/t/how-to-pull-in-information-from-multiple-tables-for-use-in-template/73895/2 "2024-06-05T18:07:32Z")

</div>

The lookup results always produce an array of data, which is not supported as a template option. Here, you need to convert it into text or a list using the joint list column.

---

<div class="post-metadata">

**Author:** ![Todd\_Lichtenwalter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_lichtenwalter/32/12231_2.png) [@Todd\_Lichtenwalter](https://community.glideapps.com/u/Todd_Lichtenwalter)\
**Post date:** [June 5, 2024, 6:16pm UTC](https://community.glideapps.com/t/how-to-pull-in-information-from-multiple-tables-for-use-in-template/73895/3 "2024-06-05T18:16:58Z")

</div>

Yes, that works. Thank you very much. I was totally stuck and trying crazy things to make it work 🖖

---

<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 12, 2024, 6:17pm UTC](https://community.glideapps.com/t/how-to-pull-in-information-from-multiple-tables-for-use-in-template/73895/4 "2024-06-12T18:17:35Z")

</div>

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