# Selectable columns within Glide folder structure **URL:** \ **Category:** Ask for Help\ **Created:** [February 24, 2025, 4:51am UTC](https://community.glideapps.com/t/selectable-columns-within-glide-folder-structure/80292 "2025-02-24T04:51:36Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Holy-Mackerel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/holy-mackerel/32/85204_2.png) [@Holy-Mackerel](https://community.glideapps.com/u/Holy-Mackerel)\ **Post date:** [February 24, 2025, 4:51am UTC](https://community.glideapps.com/t/selectable-columns-within-glide-folder-structure/80292/1 "2025-02-24T04:51:36Z")
Newby question/query I’m attempting to select a column to display as part of an if-then-else… the problem I am facing is that the selectable ‘folders’ within Glide do not contain the column type I am needing to select. ![Screenshot 2025-02-24 at 3.34.30 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/6/562642803ae0b73179e6028534d2008432d75fa3.jpeg) In regards to ‘folders’ I am referring to the black folder icons as displayed in the attached screen shot. Are the folder icon simply referencing sub columns within a data sheet and if so… how do you add a column/sub-column to the ‘folder’ so it can be linked ? ---
**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:** [February 24, 2025, 5:08am UTC](https://community.glideapps.com/t/selectable-columns-within-glide-folder-structure/80292/2 "2025-02-24T05:08:40Z")
Any columns that are selectable will automatically appear. Most likely the column you’re looking for isn’t a type that can be used in a Template. For example, relations, queries, arrays cannot be referenced in Templates. ---
**Author:** ![Holy-Mackerel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/holy-mackerel/32/85204_2.png) [@Holy-Mackerel](https://community.glideapps.com/u/Holy-Mackerel)\ **Post date:** [February 24, 2025, 5:25am UTC](https://community.glideapps.com/t/selectable-columns-within-glide-folder-structure/80292/3 "2025-02-24T05:25:07Z")
Hi Darren, thanks for the info. Can Look Up be used in Templates ? ---
**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:** [February 24, 2025, 5:46am UTC](https://community.glideapps.com/t/selectable-columns-within-glide-folder-structure/80292/4 "2025-02-24T05:46:10Z")
Yes, but only if the lookup is via a single relation. A lookup that targets a multiple relation, query or whole table will return an array, which cannot be used in a template. General rule of thumb: if you see “bubbles” in the data editor column, then you have an array. ---
**Author:** ![Holy-Mackerel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/holy-mackerel/32/85204_2.png) [@Holy-Mackerel](https://community.glideapps.com/u/Holy-Mackerel)\ **Post date:** [February 24, 2025, 6:33am UTC](https://community.glideapps.com/t/selectable-columns-within-glide-folder-structure/80292/5 "2025-02-24T06:33:01Z")
Can an image be used in a Template ? IE I have an if-then-else with 1 of 2 outcomes (complete & incomplete) I want to add the if-then-else outcome to a Template but this can not be done. So is it possible to create a new Template column or similar that will display one of two images based on the if-then-else outcome ? I believe it is possible to create a new Template column in the data editor and in the template column configuration enter desired text with placeholders. When selecting what to replace the placeholders with, choose the if-then-else column. In theory the Template column will automatically use the output from the if-then-else column \*Please note the above is based on what I have gleaned from the Glide AI help. So in short, can images be used as part of an if-then-else or is there a way that I can display 1 of 2 images based on the if-then-else outcome within a Template ? ---
**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:** [February 24, 2025, 6:36am UTC](https://community.glideapps.com/t/selectable-columns-within-glide-folder-structure/80292/6 "2025-02-24T06:36:46Z")
> [@Holy-Mackerel](#): > > Can an image be used in a Template ? Yes. > [@Holy-Mackerel](#): > > IE I have an if-then-else with 1 of 2 outcomes (complete & incomplete) > I want to add the if-then-else outcome to a Template but this can not be done. That should work. Can you show me an example of where it isn’t working? > [@Holy-Mackerel](#): > > So is it possible to create a new Template column or similar that will display one of two images based on the if-then-else outcome ? Yes. The if-then-else just needs to return the appropriate image URL (which is different to what you mentioned above) > [@Holy-Mackerel](#): > > So in short, can images be used as part of an if-then-else or is there a way that I can display 1 of 2 images based on the if-then-else outcome within a Template ? Again, yes. ---
**Author:** ![Holy-Mackerel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/holy-mackerel/32/85204_2.png) [@Holy-Mackerel](https://community.glideapps.com/u/Holy-Mackerel)\ **Post date:** [February 24, 2025, 7:05am UTC](https://community.glideapps.com/t/selectable-columns-within-glide-folder-structure/80292/7 "2025-02-24T07:05:53Z")
> [@Darren\_Murphy](#): > > That should work. Can you show me an example of where it isn’t working? I’m just trying to create it now. IN a nutshell I am basically trying to replicate a column that already exists in a different Data Sheet which utilises the if-then-else to produce complete or incomplete. Unfortunately the Group By that I want to use to display the results is within a different data sheet. To further explain, front end currently displays training completed for each yearly quarter (with a number of totals) ![Screenshot 2025-02-24 at 5.52.53 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/3/43f3a76ed322ba8e03b81e88e3c80cc2e5d7d30e.png) In the image above the training content is displayed using ITEMS DATA ![Screenshot 2025-02-24 at 5.53.10 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/5/15721f5bfc2df9c0a6f6604b8f0b8a69f1adbb5a.png) The bold Q2 2024 (6.5 Hours Structured, 6.5 Hours Total) is displayed via the Options panel utilising Group By ![Screenshot 2025-02-24 at 5.53.20 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/5/f5bbdfd54e045e219cba4c128b4086751651f749.png) Expanding the Group By highlights that it is a Summary via Template ![Screenshot 2025-02-24 at 5.53.41 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/c/5cded5b5a0dc833a7c7c279d8211f69f8db75bb0.png) So, what I am hoping to achieve is to have the if-then-else outcome appear on the end of the summary. The if-then-else returns one of two outcomes. Complete or Incomplete. For the time being I’d be Happy to have that appear at the end of the BOLD content (Q2 2024 (6.5 Hours Structured, 6.5 Hours Total [COMPLETE] Ultimately I would like to have the two values (complete and incomplete\_) appears as images ---
**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:** [February 24, 2025, 7:19am UTC](https://community.glideapps.com/t/selectable-columns-within-glide-folder-structure/80292/8 "2025-02-24T07:19:36Z")
I’m afraid I’m having difficulty following, because you seem to be jumping around a bit. Let me just clarify one point - when you refer to templates, are you referring to Template columns inside the Data Editor, or inline templating in the Layout Editor? ---
**Author:** ![Holy-Mackerel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/holy-mackerel/32/85204_2.png) [@Holy-Mackerel](https://community.glideapps.com/u/Holy-Mackerel)\ **Post date:** [February 24, 2025, 10:06am UTC](https://community.glideapps.com/t/selectable-columns-within-glide-folder-structure/80292/9 "2025-02-24T10:06:54Z")
Hi Darren, Hopefully this helps: ![Screenshot 2025-02-24 at 8.59.53 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/0/7012775d82369b59f1d198b7edd9efa839cf8968.jpeg) The Template Summary provides the data for the Summary (Selector) - display ---
**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:** [February 24, 2025, 10:15am UTC](https://community.glideapps.com/t/selectable-columns-within-glide-folder-structure/80292/10 "2025-02-24T10:15:14Z")
Okay, I think I follow now. > [@Holy-Mackerel](#): > > So, what I am hoping to achieve is to have the if-then-else outcome appear on the end of the summary. Is the if-then-else column in the same table? If yes, can you not just expand the template definition to include it? If no, can you replicate the if-then-else logic in the table to replicate it? Or perhaps relate each row to the other table and then bring it in via a lookup? ---
**Author:** ![Holy-Mackerel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/holy-mackerel/32/85204_2.png) [@Holy-Mackerel](https://community.glideapps.com/u/Holy-Mackerel)\ **Post date:** [February 24, 2025, 12:15pm UTC](https://community.glideapps.com/t/selectable-columns-within-glide-folder-structure/80292/11 "2025-02-24T12:15:56Z")
> [@Darren\_Murphy](#): > > Or perhaps relate each row to the other table and then bring it in via a lookup? I can bring it in via look up BUT then I do not know how to make the column available/selectable to a Template Configuration… ---
**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:** [February 24, 2025, 12:22pm UTC](https://community.glideapps.com/t/selectable-columns-within-glide-folder-structure/80292/12 "2025-02-24T12:22:51Z")
Just make sure your lookup is via a single relation, then it should be available. ---
**Author:** ![Holy-Mackerel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/holy-mackerel/32/85204_2.png) [@Holy-Mackerel](https://community.glideapps.com/u/Holy-Mackerel)\ **Post date:** [February 24, 2025, 11:39pm UTC](https://community.glideapps.com/t/selectable-columns-within-glide-folder-structure/80292/13 "2025-02-24T23:39:25Z")
Hi Darren, appreciate your input and assistance. Sadly I’m still scratching my head on this one. I have created a new Look Up Column in the table → Status/Display ![Screenshot 2025-02-25 at 10.32.16 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/c/ecd0538b0df4fea132ffedade8fbccc1f27b0a70.png) I am attempting to include the Status/Display in the Template immediately to its left ![Screenshot 2025-02-25 at 10.32.46 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/3/d3eeeba9d00e7640fa56c83eda44c01554694d9b.png) Unfortunately I can not locate the Display column as selectable from within the Template configuration (Replacements) ![Screenshot 2025-02-25 at 10.33.26 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/4/44b6da380476fcfe760a996200f0d84b90a3afe9.png) The Status (black folder icon) simply does not appear anywhere throughout the selectable tree What am I missing here ? ---
**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:** [February 24, 2025, 11:44pm UTC](https://community.glideapps.com/t/selectable-columns-within-glide-folder-structure/80292/14 "2025-02-24T23:44:22Z")
Your lookup column is returning an array, that’s why you can’t use it. Can you show me how it is configured? ---
**Author:** ![Holy-Mackerel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/holy-mackerel/32/85204_2.png) [@Holy-Mackerel](https://community.glideapps.com/u/Holy-Mackerel)\ **Post date:** [February 25, 2025, 12:10am UTC](https://community.glideapps.com/t/selectable-columns-within-glide-folder-structure/80292/15 "2025-02-25T00:10:21Z")
Here you go: ![Screenshot 2025-02-25 at 11.09.18 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/d/ad517643690f3f98a0418aa86faba0e41a947600.png) ---
**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:** [February 25, 2025, 12:24am UTC](https://community.glideapps.com/t/selectable-columns-within-glide-folder-structure/80292/16 "2025-02-25T00:24:47Z")
Your lookup is targeting a whole table, which is why it is returning an array. As I’ve already mentioned, you need a Lookup via a Single Relation. ---
**Author:** ![Holy-Mackerel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/holy-mackerel/32/85204_2.png) [@Holy-Mackerel](https://community.glideapps.com/u/Holy-Mackerel)\ **Post date:** [February 25, 2025, 12:37am UTC](https://community.glideapps.com/t/selectable-columns-within-glide-folder-structure/80292/17 "2025-02-25T00:37:51Z")
Apologies for the confusion and misunderstanding at this end. Isn’t the relation pointing to a single column within the Training Status Data Table ? ---
**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:** [February 25, 2025, 12:40am UTC](https://community.glideapps.com/t/selectable-columns-within-glide-folder-structure/80292/18 "2025-02-25T00:40:56Z")
Yes, and it’s returning all rows in that column as an array. A single column is not a single relation. > **[Relations | Glide Docs](https://www.glideapps.com/docs/automation/computed-columns/relations#building-single-relations)** > > Create relationships and link rows together. ---
**Author:** ![Holy-Mackerel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/holy-mackerel/32/85204_2.png) [@Holy-Mackerel](https://community.glideapps.com/u/Holy-Mackerel)\ **Post date:** [February 25, 2025, 12:51am UTC](https://community.glideapps.com/t/selectable-columns-within-glide-folder-structure/80292/19 "2025-02-25T00:51:00Z")
I was able to get the desired outcome in a seperate Data Table as shown below: ![Screenshot 2025-02-25 at 11.40.17 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/3/c35cb9c182cde55bfda049d392e2e95a888f44fe.png) IE the Template (Summary) includes the Training Status (Complete or Incomplete for the period) The Template Column (Incompleted) calls the Display column to its left ![Screenshot 2025-02-25 at 11.40.39 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/3/f34972542caffcfbd88f2bfcdda7867ce48ac161.png) It is ‘incorporated’ into the Template (Summary) Column via the bottom Replacement {{status}} ![Screenshot 2025-02-25 at 11.41.00 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/7/d7a3a189be5fd68256a3ca5f4f826dac12debd6b.png) I known I can simply recreate the Display Column (if-then-else) within the user table and create an identical Template (Incompleted) Column for the same outcome… but I am looking for a way to utilise what is already there in the Training Status Table and not create new Columns that do exactly what is already there IE a replication ![Screenshot 2025-02-25 at 11.41.21 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/c/ccb2f9aa317aa2b9bf276698a51f4540cb1262e1.png) Apologies once again if I am missing something basic, this is all very new to me as I am attempting to identify errors and troubleshoot an app that was built by someone else with no guide or architecture outline provided ---
**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:** [February 25, 2025, 1:00am UTC](https://community.glideapps.com/t/selectable-columns-within-glide-folder-structure/80292/20 "2025-02-25T01:00:15Z")
Please, no offence meant but I have told you at least 3 times now what the problem is, and you seem to be ignoring my answers. Once more… - Your lookup cannot be used in the template, because it is returning an array - You can tell it is an array because of the presence of the “bubbles” - The reason it is returning an array is because it is configured to return every value in every row in the target column in the Training Status table - To fix this, you need to create a _single_ relation between the two tables, then reconfigure your lookup to fetch the display value via that relation. I’m not sure what else I can say to try and make it clearer? 🤷‍♂️ [Next page](https://community.glideapps.com/t/selectable-columns-within-glide-folder-structure/80292.md?page=2)