Please…is it possible…?? Si if i have my list of invoices with this structure: [image] How can i Have an Inline list or List Relation showing something like this: (grouping by date and Product SKU) [image] …inside Glide without using a new google sheet with query… group by etc Thanks !

[image] prayheart_eyes Add Query function to Glide Tables, Please! Feature Requests Just want to add to this…if you need a workaround for now…what I would do is first make sure you have enabled the RowID column in your sheet. Then create a template with the unique key va…

Hi Gerard, let me help you with this. So I have some random data that is the same as your format. [image] Then I create a template column that concatenate your date and ProductSKU (because that’s the unique value we have to “group by” for calculation). [image] Then I use a relation column to se…

Thank you for your time !! In your guide I have total units sold by day and article what is ok. But when using the inline list it does not group rows by code and day. So if Art1 is sold 3 times in day 1, it shows 3 registers/rows for that same product. Hope you understand what I mean

Yeah I have tried that as well but failed to show what you want. Hope somebody can chime in with a way to make only unique values shown.

Thanks again !! Perhaps @Jeff_Hager finds a workaround .

The curious thing here is that when showing a chart, the info is grouped, but is not possible to link to detail. So the grouping is done in glide, but not possible to show it in inline lists or relation lists. Clickable charts would be super also !!

I have wanted this as well as I have a similar situation. I have a sheet with Lessons that are taught to students. In another sheet I have billing cycles where a coach can select a date range for billing of their students. Through formulas in the sheet, each lesson is assigned to a billing cycle.…

Any updates on this? Is there a way to do this in Glide now?

Query group by....inside Glide?

Ask for Help

Jeff_Hager February 14, 2021, 6:35am 9

Topic		Replies	Views
In Staging: Group items in an inline list by category! Ask for Help	11	1222	July 18, 2020
Display grouped data columns in an inline list Ask for Help	3	926	April 7, 2020
Grouping within an inline list Ask for Help	15	456	October 5, 2022
Multiple "Group by" Ask for Help	7	528	August 23, 2022
Pre-defined filters in a dropdown on the home screen Ask for Help	5	267	December 13, 2022

Query group by....inside Glide?

Related topics