Ability to "Set columns", "Increment" and "Delete Rows" via multiple relations

[Darren_Murphy]

No, but I made a short video to demonstrate how it can be done back when the Call API column was first made available.

https://www.loom.com/share/f2fabf00f6e543b7973e5824b77fbe1f

[james]

Awesome, thanks!

[Darren_Murphy]

Actually, I completely forgot that Bob made a full tutorial on this one:

Call API Tutorial - Connect almost anything to Glide! (updated Aug. 21)

Hey Gliders! Glide apps are now exponentially more powerful! Learn how to call any API securely and return data directly within Glide…in SECONDS. No Make or Zapier needed! An introduction to API + JSON responses in Glide: This introductory video covers how to: find API endpoints that you can use in a Glide App create API endpoints using a Construct URL column call the API using the Call API action fetch and read the JSON response parse items within a JSON array onto their own row in Gli…

I’m not sure if he actually covers calling the Glide API in the above, but regardless it’s probably well worth a look (as are all of his tutorials).

[Robert_Petitto]

Ya…it’s a workaround for sure, but it’s still not a native solution AND it requires business plan.

Wish we had a a native set column —> multiple relation already. We’ve been asking since 2020.

[Robert_Petitto]

@Mark

@kyleheney That will be possible at some point in the future, but I can’t give you a timeline.

Hey Mark, it’s the future now! Coming soon?

[biha]

@Flowcode

Create a query column and query all related columns.
2 - Create a joined list of all row-id’s
3 - Create a Curl Api Body that does what you want it to do with Glide AI (see below, there’s still a little bit of syntax missing in this example but you can add this easiliy in 1 step with AI)
4 - You might want to replace some things with a Template

But still cannot use for User-Specific column, right?

[Darren_Murphy]

Correct.

[biha]

hmmmmm

[Ferret]

Hey, first post, and I am coming from Appsheet. I got to say that I am very impressed with what I see so far, and that is why I am shocked that loops/iterations of creation or editing of records is something that Appsheet does better than Glide. I am looking forward to a future where this is possible.

[Robert_Petitto]

@Ferret

loops/iterations

Ooo…just wait

[nathanaelb]

Don’t get into trouble

[Zac_Zimmerman]

@Robert_Petitto

Wish we had a a native set column —> multiple relation already. We’ve been asking since 2020.

So true. This is driving me crazy on a project right now trying to make a workaround (without business plan) for something that seems so simple haha.

[Robert_Petitto]

Glide is soon going to be enhancing the action editor. Within the next couple of months, this might be a reality.

[prettycold]

For now, like how @Darren_Murphy suggests here is the way to go, is it not?

Ability to "Set columns", "Increment" and "Delete Rows" via multiple relations

Worth noting that this method only needs to be employed when working with Glide Big Tables. With regular Glide Tables you can take a more traditional route: Create JSON Object → Joined List → Template → Call API.

[vras_dinand]

tutorial video is broken, hai bro do you have again?

[Darren_Murphy]

Try it now.

[vras_dinand]

i.m Sory,I dont Understand for Data Template.
can you Explain?

My problem I Want Update With Another Condition…Can Youn Explain This With Picture

[Darren_Murphy]

I’d love to help you, but I have no idea what you are trying to do.
Can you try and explain clearly please?
Preferably with a screen shot or two.

[vras_dinand]

I Want To Update Boeelan (Kirim Simpel) AUto In condition Column Permintaan >0 Not Empty

Thakns

[Darren_Murphy]

So if the “Permintaan >0” column is not empty, you want the “Kirim Simpel” column to be checked, yes?

Given that, why not just replace the “Kirim Simpel” column with an if-then-else column:

• If “Permintaan >0” is not empty, then true