Integrating Glide App with Pipedrive CRM via AI Transcriptions

[Darren_Murphy]

@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

How do I create an auto-incrementing row number with Glide Tables?

This is a question that comes up a lot, so creating this topic to use as a reference. Typically, there are two distinct use cases when it comes to auto-incrementing row numbers. Use Case 1: – We need to generate a Part Number, or an Order Number, or an Employee ID. Once the number is generated, it should never change, even if rows are deleted. – The general approach for this use case is to maintain a static counter, use it to craft a suitably formatted ID, and increment it by one every time…

@Eden

I wonder the JSONata column is any quicker than the Transform JSON (which is essentially jq), which is already publicly released. I wonder what the the difference is in general.

I believe it is much faster. I generally avoid the JQ column, because I’ve found it has performance issues.

@Eden

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…

Yeah there is. There is a rich syntax available. Check the JSONata docs.