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
Can you give more context and informations please?
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?
I followed up with this ask if that helps: Glide AI capabilities
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.
1 Like
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.
1 Like
Yeah, you are probably right. But it depends on the quantity of properties you have tho!
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!
If you need any help, I am here!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.