Hi everyone, i’m actually facing issues with my glide app. I couldn’t figured out how to filter a number column by 2 conditions (user’s ID and Checkbox value). I need it in order to configure my bill recap in my user’s shopping cart. I have a column “total”, in which is calculated the product pr…

Are all the columns that are combined to make your “Total à payer” column contain any text?

You can make a template column joining the user email and the status column. It will come back in a form like “ a@gmail.com FALSE”. Then make a relation matching that template column with itself, return multiple matches. Then all “ a@gmail.com FALSE” orders will be returned. From there, make a rollu…

Thanks @ThinhDinh it almost works, however it blocks with the rollup column, i can’t validate the column. I think that’s linked to the row id column i have create previously, indeed in my relation column the data reported is row id. I’m gonna looking for ways to manage this and delete row id, and …

Can you specify more about how it blocks the rollup column? Some screenshots might help for me to know how you’re setting it.

Does anyone know how i could delete the row id ? @ThinhDinh do you think that my relation column report the row id for other reason ?

Ah if you’re mentioning that, the relation returns the row ID solely because it’s the first column in your data. The point of it is Glide’s telling you “We have found some matches for your relation column and we’re showing it by the first column with data by default”. If you want to actually see t…

It doesn’t work with a lookup column, it only shows the data of the total per product column. @ThinhDinh

Maybe there is another ways to manage this by using the row id column ? @Jeff_Hager

I didn’t mean you should use lookup for this, just an explanation on how relations and lookups work together, and why the relation is returning the row ID. Are you making a relation based on the template column and then rollup using that column? What does it return?

Yes i follow your instruction, i made a template column which display the value Email and statut. [Capture_templte] @ThinhDinh

Filtering column using conditions

Feature Requests

ThinhDinh July 23, 2020, 9:37am 17

Any chance it falls into one of the things mentioned here.

Topic		Replies	Views
Conditional Relations Feature Requests	23	3520	May 4, 2023
🍥 Rollups! General	14	2328	March 4, 2020
Conditional Rollup within Glide data editor Ask for Help	13	2497	January 17, 2024
Rollup with Relation Column Ask for Help	12	1014	May 19, 2021
Filter rollup fields for a planning tool Ask for Help	14	727	January 16, 2022

Filtering column using conditions

Related topics