# Fetch Column
**URL:** https://community.glideapps.com/t/fetch-column/31731
**Category:** Ask for Help
**Tags:** custom-code
**Created:** [September 13, 2021, 3:09pm UTC](https://community.glideapps.com/t/fetch-column/31731 "2021-09-13T15:09:13Z")
**Posts on this page:** 20
**Page:** 3
### Author:  [@Charliem](https://community.glideapps.com/u/Charliem)
#### Post date: [September 23, 2021, 12:47am UTC](https://community.glideapps.com/t/fetch-column/31731/41 "2021-09-23T00:47:26Z")
I’m receiving a
TypeError: failed to fetch
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [September 23, 2021, 12:49am UTC](https://community.glideapps.com/t/fetch-column/31731/42 "2021-09-23T00:49:31Z")
It’s likely because your API doesn’t allow cross-origin requests, as David said. It’s not something Glide can control.
---
### Author:  [@Charliem](https://community.glideapps.com/u/Charliem)
#### Post date: [September 23, 2021, 12:50am UTC](https://community.glideapps.com/t/fetch-column/31731/43 "2021-09-23T00:50:26Z")
Okay thanks. Just figuring things out will try a different api
---
### Author:  [@nathanaelb](https://community.glideapps.com/u/nathanaelb)
#### Post date: [September 30, 2021, 3:35pm UTC](https://community.glideapps.com/t/fetch-column/31731/44 "2021-09-30T15:35:27Z")
I just learnt that I cannot share an app that has an experimental column in it. All well.
@Robert_Petitto
After watching your video and reading the thread, I played around a little with your concept. Here is the little concept app I built: [location search](https://location-search.glideapp.io/).
**Features**
- Ability to: Search for locations _with keywords_. Save locations. Change city or country searched.
- Search is supposed to display a map, exact name and address of the location searched. Use of the Geocoding.ai API and whatnot.
- Ability to save a location, edit it (user can further enrich data manually) and delete it.
**Nota bene**
- **It’s buggy**. After a few searches the search feature stops working. I do not know if the bug comes from API limitations, data edits in the tables, the developer (me), or something else.
- For some reason the data from the API doesn’t always display in the Glide Table, though it does as soon as I look at the table. I think this is preventing me from building the “Avoid duplicates” feature I tried to build.
- I wanted to pull additional information such as storefront image, URL, phone number, but didn’t manage.
- I made the app public and I meant to make it copy-able, but apparently I cannot.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [September 30, 2021, 3:38pm UTC](https://community.glideapps.com/t/fetch-column/31731/45 "2021-09-30T15:38:40Z")
> [@nathanaelb](#):
>
> I made the app public and I meant to make it copy-able, but apparently I cannot.
You could always just remove the offending column and then provide instructions for adding it back in.
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [September 30, 2021, 5:19pm UTC](https://community.glideapps.com/t/fetch-column/31731/46 "2021-09-30T17:19:32Z")
Nice. Works well in the browser.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [September 30, 2021, 11:34pm UTC](https://community.glideapps.com/t/fetch-column/31731/47 "2021-09-30T23:34:11Z")
Very nice! Works well here.
---
### Author:  [@nathanaelb](https://community.glideapps.com/u/nathanaelb)
#### Post date: [September 30, 2021, 11:47pm UTC](https://community.glideapps.com/t/fetch-column/31731/48 "2021-09-30T23:47:59Z")
I’ve played around a lot with it, and it feels off.
**Limited data from the API request**
When you use [Nominatim](https://nominatim.geocoding.ai/), I noticed then when you search for a location, their are more data points in the details screen – namely phone number, URL – than in the API request. I wish I also had the storefront.
**Hyperformula column**
I used this to apply =right() and =left() GS formulas to some of the data returned by the API, and I noticed that though the cells in the GT _seem_ empty, the data is actually there because I can then use the Hyperformula column for other computed columns. But because the column seems empty, I still feel like this is having an incidence on a relation column I need to avoid duplicates.
It’s a shame it cannot be copied, I’d be happy to pass it along as it is. 🤷♂️
---
### Author:  [@Darren\_Alderman](https://community.glideapps.com/u/Darren_Alderman)
#### Post date: [October 1, 2021, 3:38pm UTC](https://community.glideapps.com/t/fetch-column/31731/49 "2021-10-01T15:38:14Z")
@david See _Darren’s Fetch_ vs. _David’s Fetch_ here:
> **[Fetch Examples](https://fetch-example.glideapp.io/)**
From my testing, both work on:
- Google Chrome on Android
- Google Chrome on PC
- Google Chrome on macOS 11
But David’s Fetch returns nothing on:
- Chrome on iOS 14
- Safari on iOS 14
- Safari on macOS 11
You mention [here](https://community.glideapps.com/t/anyone-with-problems-using-xc-columns-e-g-incognito-mode/32463/2), you think there are Safari iOS 15 issues with the Experimental Code column. This may be true, but there is also an issue with [column.sh](https://column.sh/).
Darren’s Fetch is using: [https://replit.com/@darrenambles/fetch](https://replit.com/@darrenambles/fetch)
David’s Fetch is using: [https://column.sh/fetch](https://column.sh/fetch)
I’ve seen the same issue when trying to use: [https://column.sh/hell-yes-code](https://column.sh/hell-yes-code)
P.S. On the admin app last week, I had to roll back the change to use [https://column.sh/fetch](https://column.sh/fetch) because it stopped working the next morning.
---
### Author:  [@david](https://community.glideapps.com/u/david)
#### Post date: [October 1, 2021, 5:11pm UTC](https://community.glideapps.com/t/fetch-column/31731/50 "2021-10-01T17:11:37Z")
I will try hosting them on a different domain to see if it’s a domain configuration thing.
I will add that my fetch also has an in-memory cache now.
---
### Author:  [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)
#### Post date: [October 2, 2021, 11:39pm UTC](https://community.glideapps.com/t/fetch-column/31731/51 "2021-10-02T23:39:04Z")
You can always replace the forward slash with a comma if all you want is the lon-lat.
---
### Author:  [@Darren\_Alderman](https://community.glideapps.com/u/Darren_Alderman)
#### Post date: [October 20, 2021, 5:53pm UTC](https://community.glideapps.com/t/fetch-column/31731/52 "2021-10-20T17:53:18Z")
Just wanted to update here that my issues with the Fetch JSON Plugin not working on iOS **have been resolved**.
Also I created a beginner friendly tutorial showing how to use the Fetch Column here:
> [@Create a Dictionary Searching App Using the Fetch JSON Plugin](https://community.glideapps.com/t/create-a-dictionary-searching-app-using-the-fetch-json-plugin/33298):
>
> Background There is a popular showcase on the forums for a dictionary app with 163,819 rows. This utilized the best tricks at the time to create a way to search a dictionary dataset. The biggest issue is the lag between entering in a word and seeing the responses. [https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645?u=darren](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645)What’s New? Glide has released some awesome new features that allow us to make better more responsive apps. In particular for this app, we now have…
---
### Author:  [@Rogelio](https://community.glideapps.com/u/Rogelio)
#### Post date: [October 21, 2021, 2:17am UTC](https://community.glideapps.com/t/fetch-column/31731/53 "2021-10-21T02:17:21Z")
just wondering, is there a way to display the array values of any of those rows in its own in-line list perhaps?
eg; display the values highlighted below in an in-line list
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [October 21, 2021, 2:28am UTC](https://community.glideapps.com/t/fetch-column/31731/54 "2021-10-21T02:28:29Z")
Ya. Create a multiple relation of that array back to a source of some type. But…if fetched…I imagine those values don’t live in your sheet?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [October 21, 2021, 2:40am UTC](https://community.glideapps.com/t/fetch-column/31731/55 "2021-10-21T02:40:01Z")
Just thinking out aloud, I wonder if he could use a single value to take the first item from the array, and then use that to create the relation? 🤔
hmm, or even just a self-referencing multi-relation might do the trick?
---
### Author:  [@Rogelio](https://community.glideapps.com/u/Rogelio)
#### Post date: [October 21, 2021, 3:04am UTC](https://community.glideapps.com/t/fetch-column/31731/56 "2021-10-21T03:04:41Z")
that’s correct, the values don’t live in Glide but rather in Firebase.
I can pull the entire tree branch from Firebase that contains each object in an json structure eg; list of Venues
I am now trying to display them in an in-line list.
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [October 21, 2021, 3:07am UTC](https://community.glideapps.com/t/fetch-column/31731/57 "2021-10-21T03:07:13Z")
@Rogelio Can you dynamically add row numbers to this table? If so, I have an idea.
---
### Author:  [@Rogelio](https://community.glideapps.com/u/Rogelio)
#### Post date: [October 21, 2021, 3:08am UTC](https://community.glideapps.com/t/fetch-column/31731/58 "2021-10-21T03:08:02Z")
I’ve tried a self-relation (multiple) back to itself using a standard text column, but it doesn’t quiet work, as the list I want to display it’s contained in an individual column of the sheet that contains a single row.
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [October 21, 2021, 3:12am UTC](https://community.glideapps.com/t/fetch-column/31731/59 "2021-10-21T03:12:38Z")
What I’m thinking is create a row number in each row and start with 0. Then add a single value column that looks at that array. Choose “from start” \> Row number. This should put each value on its own row. Then you can display it in an inline list.
---
### Author:  [@Kyan\_Lynch](https://community.glideapps.com/u/Kyan_Lynch)
#### Post date: [October 21, 2021, 3:13am UTC](https://community.glideapps.com/t/fetch-column/31731/60 "2021-10-21T03:13:39Z")
This is obviously not exactly what you are looking to do, but I was looking for a way to display multiple items in a list from a fetch.
Rather than inline list (for now), I replaced the JSON elements I didn’t want ( [, ", ".) with HTML tags and created an unordered list for display purposes. I am using a rich text element for display on the page. Not as nice as an inline list, but still much better than a long paragraph of items.
[Previous page](https://community.glideapps.com/t/fetch-column/31731.md?page=2)
[Next page](https://community.glideapps.com/t/fetch-column/31731.md?page=4)