# Glide AI and sources
**URL:** https://community.glideapps.com/t/glide-ai-and-sources/79843
**Category:** Ask for Help
**Tags:** ai
**Created:** [February 6, 2025, 4:48pm UTC](https://community.glideapps.com/t/glide-ai-and-sources/79843 "2025-02-06T16:48:52Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@MattLB](https://community.glideapps.com/u/MattLB)
#### Post date: [February 6, 2025, 4:48pm UTC](https://community.glideapps.com/t/glide-ai-and-sources/79843/1 "2025-02-06T16:48:52Z")
Dumb question. I want to apply a prompt against a query from a Big table. Heading to a meeting and not sure of the answer.
Thanks
---
### Author:  [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)
#### Post date: [February 6, 2025, 6:23pm UTC](https://community.glideapps.com/t/glide-ai-and-sources/79843/2 "2025-02-06T18:23:47Z")
Can you give more context and informations please?
---
### Author:  [@MattLB](https://community.glideapps.com/u/MattLB)
#### Post date: [February 6, 2025, 6:30pm UTC](https://community.glideapps.com/t/glide-ai-and-sources/79843/3 "2025-02-06T18:30:17Z")
I want to run a prompt against a query within a Glide table (rather than the table itself). For example, I have a table (a feed) with about 500 descriptions (e.g. “Matt signed up a new partner”) and meta data (date, author, territory, etc). I wanted to create a prompt like “What activities did Matt complete this quarter” and have the AI respond with (as an example) “Matt signed up 6 partners this quarter and had 7 events”.
Make sense?
---
### Author:  [@MattLB](https://community.glideapps.com/u/MattLB)
#### Post date: [February 6, 2025, 6:32pm UTC](https://community.glideapps.com/t/glide-ai-and-sources/79843/4 "2025-02-06T18:32:22Z")
I followed up with this ask if that helps: [Glide AI capabilities](https://community.glideapps.com/t/glide-ai-capabilities/79847)
---
### Author:  [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)
#### Post date: [February 6, 2025, 6:40pm UTC](https://community.glideapps.com/t/glide-ai-and-sources/79843/5 "2025-02-06T18:40:17Z")
Why not use a joined list to retrieve all the JSON data from the query, assuming you have already created a JSON column in the target table? You could then use a template column to concatenate “[” and “]” around the joined list. This final column can be utilized in a Glide AI column to execute the instructions you wanted on this data.
---
### Author:  [@MattLB](https://community.glideapps.com/u/MattLB)
#### Post date: [February 6, 2025, 6:47pm UTC](https://community.glideapps.com/t/glide-ai-and-sources/79843/6 "2025-02-06T18:47:20Z")
Scale. 500 is a test. Real-life could be 1,500+ activity rows in a territory in a quarter and 60 territories in an org. A years worth is not large for a Big Table, but I suspect too big for a joint column.
---
### Author:  [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)
#### Post date: [February 6, 2025, 6:54pm UTC](https://community.glideapps.com/t/glide-ai-and-sources/79843/7 "2025-02-06T18:54:21Z")
Yeah, you are probably right. But it depends on the quantity of properties you have tho!
---
### Author:  [@MattLB](https://community.glideapps.com/u/MattLB)
#### Post date: [February 7, 2025, 3:32pm UTC](https://community.glideapps.com/t/glide-ai-and-sources/79843/8 "2025-02-07T15:32:25Z")
Going to start with this idea. In the end I think if I wanted to provide the larger-scale version (and more generic NLP query processing) I would have to go outside of Glide and use MySQL or Progress to store the rows and have that as the input to an AI trained on this use case. At least that is what ChatGPT tells me to do!
---
### Author:  [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)
#### Post date: [February 7, 2025, 3:52pm UTC](https://community.glideapps.com/t/glide-ai-and-sources/79843/9 "2025-02-07T15:52:52Z")
If you need any help, I am here!
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [February 14, 2025, 3:53pm UTC](https://community.glideapps.com/t/glide-ai-and-sources/79843/10 "2025-02-14T15:53:26Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.