Hello Glide Community, I’m developing a Glide app where sales reps answer questions about meetings via voice notes rather than data entries. GPT3.5 then transcribes these notes. The challenge is associating these notes with Deals and People in our Pipedrive CRM. Due to the volume of data, syncing …

In that case, create just one Template column and one JSON Query column that gets the index level node for each row. [1] Then create the rest of your JSON Query columns sourced from the first JSON Query column. fields.status It’s only 2 extra columns.

[image] Eden: I wonder how many rows it could handle without delay I’ve tested with up to 3000 rows, using pure JavaScript, and I started to see some slowdown above 1000 rows. Above 3000, and it started to produce erratic results. But I think it also depends on how complex your data structur…

Amazing, more than enough in my use case! Especially as I could always introduce pagination buttons to load only 100 at a time which would make the experience a breeze. [image] Darren_Murphy: the new JSONata column is supposed to be really fast and efficient Interesting, is that in beta? I …

You can enable it via Previews. [CleanShot 2023-07-27 at 12.08.30@2x]

enabled in previews! thanks! although, the problem with using this field or Transform JSON is that there’s no option to outline variables as we could in javascript, so there’s no way to reference the index… I wonder the JSONata column is any quicker than the Transform JSON (which is essentially jq )…

additionally, I wonder if there’s a javascript to create an array of sequential Index ID’s based on the current row rather than entering them manually…

[image] Eden: additionally, I wonder if there’s a javascript to create an array of sequential Index ID’s based on the current row rather than entering them manually… See below, use the 2nd option [image] How do I create an auto-incrementing row number with Glide Tables? Comm…

[image] Darren_Murphy: Yeah there is. There is a rich syntax available. Check the JSONata docs. Yes, but Glide only allows for input of a single field, not multiple variables as with javascript. So how would I reference the index column? [image] [image] Darren_Murphy: See below, use t…

You mean pull a different index for each row in the Query parameter? You could just build a template column that builds the query, along with the row’s index, and use the template column in the query parameter.

Yes, but the issue with that is- I have multiple columns/fields which I would like to display. I will need 2 columns for each field I would like to display, the ‘Template’ and ‘Query JSONata’ columns. Whereas with Javascript I can reference variables and so I only need 1 column per field I’m look…

Amazing, works perfectly! and it’s blazing fast… [image] I’m using make.com as an intermediary and the response time is pretty much instant. Additionally, doing it as you suggested @Jeff_Hager is significantly more efficient as all columns don’t need to index all rows, only their own.

Integrating Glide App with Pipedrive CRM via AI Transcriptions

Ask for Help

Topic		Replies	Views
Get rows of data into glide via call api Ask for Help api	20	230	December 9, 2024
Using Call API and Glide API to add rows to related tables. Also...JSON Object! Project Showcase tutorial	14	1129	September 5, 2024
Glide AI: Text-to-JSON Community Resources ai	12	1154	January 9, 2024
Fetch Column Ask for Help custom-code	76	6180	March 8, 2022
Community Update: Events for Glide Experts and more General community-update	8	201	July 25, 2024

Integrating Glide App with Pipedrive CRM via AI Transcriptions

Related topics