Fetch Column

Very nice! Works well here.

I’ve played around a lot with it, and it feels off.

Limited data from the API request
When you use Nominatim, 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. :man_shrugging:

2 Likes

@david See Darren’s Fetch vs. David’s Fetch here:

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, 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.

Darren’s Fetch is using: https://replit.com/@darrenambles/fetch
David’s Fetch is using: https://column.sh/fetch

I’ve seen the same issue when trying to use: 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 because it stopped working the next morning.

1 Like

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.

4 Likes

You can always replace the forward slash with a comma if all you want is the lon-lat.

1 Like

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:

9 Likes

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

image

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?

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? :thinking:

hmm, or even just a self-referencing multi-relation might do the trick?

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.

@Rogelio Can you dynamically add row numbers to this table? If so, I have an idea.

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.

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.

1 Like

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.

I only have a single row in my glide table…

so this is my objective…To host the majority of my app data in Firebase and using Firebase’s REST API to display and maintain the data, and simply use Glide for authentication, front-end and the business logic.

I believe this would address the row limits, performance and scalability issue associated with Glide.

I have this simple Firebase branch called venues

image

I have this simple Glide table that is fetching the above data and so I want to display the json returned of Venue objects in an inline list.

the list needs to act like a Glide list, eg; be selectable to view its details etc

1 Like

Yes, that makes sense. I’d love to do that too, truthfully. Hopefully someone smarter than I am helps us figure it out!

Well to display an inline list you will still need multiple rows to house it, so that defeats your purpose.

1 Like

yeah i think i gathered that earlier. I figured that it could’ve been a possibility since an in-line list can be built from any array and the returned json is essentially an array/dictionary

1 Like

Let’s pretend we could display the array as an inline list. What are you expecting to happen when you click on an item? Show details for just that item? Where are those details living? In another array? Glide can’t do this without knowing the position in the array.

1 Like