Hi. I have data look like in attached pict. I would like to display SO, items, qty and delivered_qty. But item should be displayed only single line not dup. How to do that? [396659] Regards to pict. I would like to display like. SO0001 item , qty , delivered_qty item0001 , 42 , 0 i…

If you mean displaying it on the front end, use the “Group by” feature of inline lists (Apps)/collections(Pages). [image] Group Group list items into categories. Note: Doc has not been updated since “Group By” was recently added to Pages.

Dear @ThinhDinh It doesn’t work like I mentioned. And it worked only single level in GroupBy. Is it possible to do a bit algorithm in the table?

Are there function like sumifs ?

I think this may be what you want. [image] Multiple "Group by" Ask for Help What exact “bugs” were you facing? You can sort of do a “unique” setup in Glide. Create a rowID column for the first table. Create a relation from the Store column to itself, make it a multipl…

Ah, seems like you need to group and sum things at the same time. So please follow my comment in the link Jeff gave above and let us know if you face any problems.

It doesn’t work. Because I need to get input data for querying process. I used dumb number instead. But I am thinking what happen if many specific users are querying at the same time. Does it work?

What do you mean by “dumb number”? When ever you have multiple users viewing the same data and you need any sort of customised view per user, then you need to be using User Specific Columns.

When user enter any data. I will put it in a new column. Let’s say dumb column. After that I use single value and if-then to check that number. As I told, I still have question if many users use this query. What will happen?

[image] paiboolk: I will put it in a new column. Let’s say dumb column. After that I use single value and if-then to check that number. As long as that “dumb” column is User Specific, then you will have no problems with many users at the same time.

How can I sort and sum data in different record?

Ask for Help

Jeff_Hager August 22, 2022, 1:48am 5

I think this may be what you want.

Topic		Replies	Views
How to summarize sorted data based on many criteria Ask for Help	6	750	August 30, 2020
How to group by Sum in a list or table Collection Ask for Help	2	334	January 20, 2024
Sort+Group Relationships Ask for Help	1	326	July 23, 2022
Grouping and Summarizing Unique Values In a Table Ask for Help	2	65	February 7, 2025
Creating POS System with GlideApps Ask for Help	11	1165	June 19, 2022

How can I sort and sum data in different record?

Related topics