No Way to Disable a Sorted Group
I have a 3-column view that looks similar to this:
1 Color Blue
1 Color Green
1 Color Red
2 Auto Ford
2 Auto Chevy
2 Auto Toyota
3 Size Compact
3 Size Full-Size
3 Size Medium
When I group on the second column, I get this:
Auto
2 Ford
2 Chevy
2 Toyota
Color
1 Blue
1 Green
1 Red
Size
3 Compact
3 Full-Size
3 Medium
Notice, that Zoho Creater is always sorting on the column that is grouped. When you look at the options in the view for grouping, it shows only “Asc” and “Desc”. Zoho should not be sorting a group, unless the developer wants the group to be sorted. If sorting is not specified, then Zoho should maintain the same order the column had before it was grouped. It should look like this:
Color
1 Blue
1 Green
1 Red
Auto
2 Ford
2 Chevy
2 Toyota
Size
3 Compact
3 Full-Size
3 Medium
To further illustrate, suppose you have a 3-column view that looks like this:
1 Color Blue
3 Size Compact
3 Size Full-Size
1 Color Green
1 Color Red
2 Auto Ford
2 Auto Chevy
2 Auto Toyota
3 Size Medium
If you group on the second column, and “Asc” and “Desc” is not specified, then Zoho should group based on the order in which the data appears in the grouped column. In this case, Color appears first, Size appears second, and Auto is third. The grouped column should look like this:
Color
1 Blue
1 Green
1 Red
Size
3 Compact
3 Full-Size
3 Medium
Auto
2 Ford
2 Chevy
2 Toyota
I believe that most databases group like this when Asc and Desc are not specified (they are optional). There should be a “No Sort” option for grouping Zoho views, and it should be the default option. Better yet, there should be an option to allow the developer to sort a group based on the order of another column (e.g., first column).
In the meantime, is there a work-around for this problem?