🆕 Query column!

[ThinhDinh]

This request has been brought to life.

Conditional Relations

I know myself and others have made this case before, but I’d like to mention it again. I think it would be hugely benificial to be able to apply IF conditions within Relation settings. My use case for this is to get the unpaid dollar amount from unpaid invoices. I have invoices for students that, let’s say, are billed monthly. The user creates the billing period for a particular month, and any lessons that have occured within that billing period are automatically included in that invoice. In…

See Mark’s video here.

[Robert_Petitto]

It’s AMAZING. This is going to reduce so many columns when creating “conditional relations”.

After playing around with this, the first thing I learned is that the output is ALWAYS a “multiple relation”.

Going to be huge in the world of gamification!

[ThinhDinh]

Please share videos if you want here, we would love to see your applications

[Uzo]

So bad I don’t use glide rows anymore That would be useful a year ago… now I do everything with Java… but a nice feature for a small database.

[Robert_Petitto]

First thing that came to mind…before this took either a complicated series of array columns or a tedious/static if then else column:

The this row filter is going to be MAGICAL!

[Uzo]

Where do you get this Query column… I can’t find it… only in Staging?

[ThinhDinh]

Yes, I stated that in the title.

Edit: It’s now in production!

[Simon_Hill]

Rookie question: who has access to stuff like this in staging?

(I have a pro account and have signed up for developmental stuff like integrations)

[Darren_Murphy]

Anyone and everyone has access, just go to https://staging.heyglide.com/

Because it’s a staging environment, the usual caveats apply. ie. nothing is guaranteed to work, and stuff that is working can break at any time without notice.

[MattLB]

Just signed up for staging.heyglide…

I do not see query. It seemed to be above relation in Mark’s demo. Do I have to upgrade an account or …?

Thanks

[erwblo]

But ‘So bad I don’t use glide rows anymore’ ?

[Uzo]

Nope… only JSON

[erwblo]

@Uzo

Where do you get this Query column

So you won’t be really interested in ‘Where do you get this Query column’ I assume?

[Uzo]

Oh… no, sometimes I have small apps under 500 rows… so that can be useful

[nathanaelb]

Mark, you say it’s a “little feature”, maybe this was said tongue in cheek. This feels like a big deal. Thank you so much for developing this.

[ThinhDinh]

Have you enabled it in previews on the team level?

[MattLB]

Nope. I signed up for the beta which showed integrations. Will try this now - thanks for the tip!

[ThinhDinh]

It’s already in production now, if you want to test it there, instead of staging. Please go through the same flow of enabling it in Previews.

[MattLB]

Done - thanks again!

[Antonino_Nolasco]

Greaaaaaaat news!!! I just deleted about 50 template columns from my apps thanks to new query column. I love you guys!!!