Best way to pull all “names” from an External DB into a Glide-native table (array/json → index trick)?

Ask for Help
1

Hi everyone,

I have a Glide app connected to an External Database (Supabase). In that external table I have many rows with a name field (e.g., client names) :

image
image918×883 142 KB

Goal: I want to get all the client_name values from the external DB, transform them into something Glide can handle (array / JSON / joined text), and then “unwind” them into a native Glide Table using the index trick / helper table approach.

Constraints:

  • I want to stay 100% inside Glide (no Make/Zapier/n8n/scripts).

  • I’m fine with computed columns like Split Text / Single Value if that’s the right pattern.

I have already done this with jsons, the thing is that i dont want to get the values through an api call because i would need to either create a button and click it or a workflow triggered every x minutes but it will consume a lot of glide updates, so i prefere to ask if there is any workaround inside glide to get this done

When i talk about the index trick / helper table approach, i mean this:

image
image502×837 76.5 KB

Thank you in advance

2

So in your solution, you don’t want Glide to connect to your Supabase anymore, and just have a schedule to get just client_name from your Supabase table to “unwind” them into a native Glide Table?

Can you share more on what’s the use case here?