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,…

Now available as the Query column (you can enable this as a Preview feature on the upper-right side of your dashboard).

I’m sorry, I’ve been here recently and I didn’t realize you used the same methodology. Thanks because at least for me it is the confirmation that at the moment this is the best solution, while I am waiting like you for a built-in conditions

Thanks for the input. Yes, I have also used your method with a template, but my situation is similar but different. For me, I need the email to match, but then I need to find a range of dates that are less than the date of the current row. This would allow me to perform a Rollup Sum of all of the…

Thanks @Jeff_Hager for the detailed explanation of this very interesting scenario. Certainly the method I have expounded, and which was clear to most of you here, does not cover your case and I am now well aware of that.

Here’s a similar feature request. Feature Requests Feature requests for Glide Apps

Need this Need this Need this. Here’s another scenario where this feature is necessary! @Mark @david

Yep, that’s exactly my problem too. I need to do a rollup sum from all rows prior to the date of the current row, so each row is going to have a different number of related rows. Since we have a range of dates to check against, and that range can vary indefinitely, you can’t do an exact match rela…

Giving this a bump, so hopefully it will attract a few votes :slightly_smiling_face:

Would this enable rollups based on the current user email? If so, +1 from me

You can rollup against a relation for a specific user. If all you are comparing is a static known value, like emails, then a relation and rollup should work for you. My main problem is that I need to filter to a range of dates prior to a date on each individual row before I can perform a rollup, s…

This would also allow for inverse relations, correct? eg. Rel _ user where user is not signed in user?

Conditional Relations

Feature Requests

david May 4, 2023, 12:04am 21

Something is coming later this week…

Create a List of specific Relation Items

Topic		Replies	Views
Filtering column using conditions Feature Requests	18	1205	July 23, 2020
Create a List of specific Relation Items Ask for Help	13	537	May 4, 2023
Conditional Rollup within Glide data editor Ask for Help	13	2495	January 17, 2024
Lookup all users but himself Ask for Help	5	726	January 17, 2021
Help with a google sheet query for a billing app Ask for Help	24	1600	May 22, 2020

Conditional Relations

Related topics