# Virtual Array as Simple List in App

**URL:** <https://community.glideapps.com/t/virtual-array-as-simple-list-in-app/4383>\
**Category:** Ask for Help\
**Created:** [February 7, 2020, 10:27pm UTC](https://community.glideapps.com/t/virtual-array-as-simple-list-in-app/4383 "2020-02-07T22:27:57Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![leilah13](https://avatars.discourse-cdn.com/v4/letter/l/53a042/32.png) [@leilah13](https://community.glideapps.com/u/leilah13)\
**Post date:** [February 7, 2020, 10:27pm UTC](https://community.glideapps.com/t/virtual-array-as-simple-list-in-app/4383/1 "2020-02-07T22:27:57Z")

</div>

Hi there! I’m trying to do something I think is quite simple. I have an array column that Glide created in my data. I’d like to add that array essentially as a simple list or even in a way that looks exactly as it does in the data set. I can only see the Array Column in the image component, but these aren’t images. Does array only import into the app for images? Seems odd to me.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [February 8, 2020, 12:06am UTC](https://community.glideapps.com/t/virtual-array-as-simple-list-in-app/4383/2 "2020-02-08T00:06:02Z")

</div>

You could use a template column to join the individual columns together as one markdown text value, then display it in a rich text component, or list them in a top down format in another sheet and use a relation column to link the primary sheet to them. Then you can display the items in a compact inline list.

---

<div class="post-metadata">

**Author:** ![leilah13](https://avatars.discourse-cdn.com/v4/letter/l/53a042/32.png) [@leilah13](https://community.glideapps.com/u/leilah13)\
**Post date:** [February 8, 2020, 12:09am UTC](https://community.glideapps.com/t/virtual-array-as-simple-list-in-app/4383/3 "2020-02-08T00:09:42Z")

</div>

Thank you! I actually just created a relation to link the array column to another sheet with those options. Haven’t played much with templates, but I may get there!

---

<div class="post-metadata">

**Author:** ![byhazellim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/byhazellim/32/55170_2.png) [@byhazellim](https://community.glideapps.com/u/byhazellim)\
**Post date:** [May 4, 2023, 6:44pm UTC](https://community.glideapps.com/t/virtual-array-as-simple-list-in-app/4383/4 "2023-05-04T18:44:58Z")

</div>

I have a page current displaying a collection of Tours filtered by customer.

When the customer clicks on a tour, a tour detail page should open with a map of all the sites of this tour.

I believe this can only be done by creating a separate display table (with the list of attractions in a top down format) like you said.

But a can’t seem to make the relations between the two tables work. How do I set this new display table to relate to the old one?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [May 4, 2023, 11:21pm UTC](https://community.glideapps.com/t/virtual-array-as-simple-list-in-app/4383/5 "2023-05-04T23:21:25Z")

</div>

Relations work by looking for exact matching values. This can work with columns that contain a single value, and it can work with arrays as well. How is your data set up now? I assume attractions can be part of many different tours?

Depending on how your data is set up, you could have a comma delimited list of attraction ID’s in a column in your your tours table. Using a Split Text column, you can split that comma delimited list into an array. The array of ID’s can be used with a relation to link to the ID column in the attractions table. That relation would be the source of your map.

---

<div class="post-metadata">

**Author:** ![byhazellim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/byhazellim/32/55170_2.png) [@byhazellim](https://community.glideapps.com/u/byhazellim)\
**Post date:** [May 5, 2023, 12:38am UTC](https://community.glideapps.com/t/virtual-array-as-simple-list-in-app/4383/6 "2023-05-05T00:38:54Z")

</div>

I have not thought of adding attractions into a separate table but that would makes a lot of sense!

It was all in 1 JSON output from GPT.

I managed to find a workaround by adding a button that sets the Tour\_ID in the User table whenever someone clicks on a specific tour (to view details), and a single value column in the Display Tour Table to get this tour\_ID. Then, I used SVC to get every column I need about this tour including this JSON, and a column with a Javascript code to split out the attractions top down in each row.

Thank you!!

Now I have a new problem in that the map pins are all over the place! It’s like Russian dolls - you fix one, another one pops up!

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [May 5, 2023, 3:40am UTC](https://community.glideapps.com/t/virtual-array-as-simple-list-in-app/4383/7 "2023-05-05T03:40:35Z")

</div>

Mapping a location in Glide is not always accurate if you use addresses. If you can get latitude and longitude coordinates, you will have much better kuck

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [May 5, 2023, 11:03pm UTC](https://community.glideapps.com/t/virtual-array-as-simple-list-in-app/4383/8 "2023-05-05T23:03:21Z")

</div>

I think the Google Maps integration to get coordinates is pretty solid, if you have the address in text.

---

<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 17, 2024, 4:49pm UTC](https://community.glideapps.com/t/virtual-array-as-simple-list-in-app/4383/9 "2024-01-17T16:49:06Z")

</div>


