[image] @Mark and @david have been busy :star2: I use integromat for most of my backend but I’ve hired an engineer to help me out @mubeeniftikhar :slight_smile: so we are ready to figure out how to solve my various use cases: how to use an integromat scenario that produces an agent ID and TestFlow ID …. And push that to the Agent sheet, matching against Agent ID (row id) and writing the tfid into ‘current tfid’ programmatically set columns in the TestFlow table to clear all or some values writing button presses between agent and user so that the button in the customer app appears 15-300 seconds faster (even in a glide table) Happy to share our findings!

I have the same need :slight_smile: :slight_smile:

mmm, and I could insert my Facial Recognition scans directly into Glide. Been waiting for this for months… Although, just thinking about it - in my case I need to be able to do an “upsert” - so if I can’t search rows via the API, then it may not meet my use case.

What the helll!! :flushed: Where is that API that allows to write into Glide Tables directly?? Gracias!!

Writing into Glide directly from another system is up there with ‘Find All Uses’, ‘XC columns’, Plugins, and a working data editor in the bottom left. OK, having fun with the last thing! The GS-Glide round trip can be 15-300 seconds, which leads to a terrible user experience for some types of apps. But with this bit of magic code, the world becomes beautiful :slight_smile: (until the next thing we come up with :wink:

[image] ThinhDinh: write PayHere rows directly into Glide Tables Exactly!

OK - Thanks to @mubeeniftikhar (who works for me at Covessa :slight_smile: we have made a ton of progress. He will write up how things properly work soon, but I thought I would share work to date beforehand. In the Data Editor, right click and see if you have a ‘Show API Key’ option from a table on the left works with Glide Tables (GT) and Google Sheets (GS) You have the option to copy the code for: Add Row Delete Row Set Columns (in a row) You find a row with the Row ID (look at the bottom of the code… you might have renamed the column) You will see that Glide has remembered the old column names and maybe even order you had weeks ago when you started building the app - but no panic, the current column name (and therefore use you are making of it) is written too (I have “Date”:“Inc/ Agent” for my agent increment, for example) We are using Integromat so we started with a simple Set Variables module to set variables to test, then pushed in these values to test in an experiment app to see if they work. Your JSON needs to be formatted as Beautify otherwise it will not work you need to put the values you want to write in into quotation marks"" There will be some other things to take note of - but in the meantime here is a short video to walk you through magic :slight_smile: [image] A0 4a2 Agent call > set Inc/ Agent for customer | Integromat - 8 November...

Is that 3 seconds in the builder, or 3 seconds in the client apps? As I understand it, the change is pushed via the API to the Glide back end, but it then needs to sync to each client app - correct? Although thinking about it, the builder is in some ways just another client. So if it syncs from the backend to the builder in 3 seconds, then it’s probably a reasonable expectation that the clients would get it in a similar time frame? :thinking: Looking forward to having a play with this…

3 sec to appear in the client :slight_smile: :slight_smile: my testing so far :slight_smile:

🚀 Glide table API & curl - what can we all learn together?

Ask for Help

Darren_Murphy November 5, 2021, 2:59pm 8

How what? The facial recognition?
It’s a project I’ve been working on for a while. I described it in some detail here.

Topic		Replies	Views
Add Row Using Glide Table API Ask for Help	1	343	August 31, 2022
Write to Glide Tables Feature Requests	8	654	January 9, 2022
Import your Glide Table into any Google Sheet, with 1 formula! Project Showcase	18	1187	July 15, 2023
🆕 Glide Tables General	123	8948	April 20, 2021
Push data from Zapier to Glide tables Ask for Help	12	990	April 20, 2023

🚀 Glide table API & curl - what can we all learn together?

Related topics