Hi everyone,
I am trying to group by location, a table with an ID and a Name (Living Room). Name is my label.
When in a specific view, I am trying to group by Location ascending
โbut unfortunately it orders the ID of the table and not the label.
How could I fix this ?
Thanks
Solved! Go to Solution.
So as well as grouping you probably need to specify a sort order in the view.
Is emplacement a Ref column?
Good point. Well you can't order by an ENUMLIST anyway I think ๐
So as well as grouping you probably need to specify a sort order in the view.
I did actually put a sort order by "emplacement" which is location.
But unfortunately it orders by Location ID and Name's ID.
Do you have any ideas how to solve this ?
Thanks
Is emplacement a Ref column?
Sorry I accepted as solution
Emplacement is an enum list column with a base type ref from Emplacement table
โ
โ
So Ref columns behave a bit differently to other column types. With a Ref column in the table your in your actually selecting, you are choosing the KEY column from the other table. But to make it look nice in the App, visually it's showing you the LABEL column. So when you choose Order By a Ref column it will order by the KEY and not the LABEL.
Luckily, there is an easy fix. Simply create another column with a formula of [RefTableName].[DisplayColumn], make this hidden but use it as the sort column.
Hi
Thanks for your prompt reply.
[RefTableName].[DisplayColumn]
I am not sure it's working as my "emplacement field" (ID / Label : Location) is an enum list..
โ
Good point. Well you can't order by an ENUMLIST anyway I think ๐
@1minManager wrote:
Well you can't order by an ENUMLIST anyway I think
Sure you can! In fact, one of the primary features of an Enum or EnumList column is that you get to set the sort order of the defined values.
Not sure you've got the right idea here. AFAIK he's got a list of items in a Table view and he's trying to order those items by the value of an ENUMLIST. Given that an ENUMLIST is muliple items, in a specific order, I'm not sure how ordering would work. Or even if Appsheet allows that. If it does, I'd almost guarrantee its not what he's after...
@GV wrote:
Emplacement is an enum list column with a base type ref from Emplacement table
Can a single thing have multiple locations? If yes, sorting by location makes no sense; if no, it should be Enum rather than EnumList.
A single list can have multiple locations yes, I'll try the enum rather than enum list
User | Count |
---|---|
36 | |
32 | |
30 | |
18 | |
16 |