I need a bit of help with the following that I think I might be needing to integrate sort or orderedby expressions but I am not sure.
My Data:
Global Status Table
Product Table
-Global Status is Ref to the Global Status Table
Product View
-Global Status is
Questions:
I only have the option to sort Global Status by Ascending or Decending order. How do I sort in either:
Hi @Michael_Pinto!
Iโm not sure if this is what you need but I wonder if simply using a table view with headers in AppSheet might not give you the capacity you are looking for. If you have headers in an AppSheet table, the user can choose the header to tap on to order the records by that column, and then tap again on the same column to reverse the order. Please see โHow do I get headers to show?โ in the following:
Hi Kirk
I familiar with sorting capabilities on the header and unfortunately that does not solve my issue. Sorting it this way still means that the data is sorted alphabetically, where as I needed it to be custom sorted to my specifications to help facilitate my users see relevant data 1st.
To give you an example of what I see in my app vs what I want.
Current sort (Alphabetical)
Requested sort
I would like to rather sort as follows:
@Michael_Pinto In general, Sorting can only be done with the data available to the sort function. So, if you cannot get the data sorted in the order you wish with the data you have, you will have to introduce data that allows the sort order you wish.
In your case, I would recommend assigning a Code value to the Global Statusโs. In other words, a separate hidden column that has a value that you solely use for sorting.
I also recommend using values such as 10, 20, 30, etc rather than 1,2,3. If in the future you decide to add statusโs that go between existing ones, then you only need to choose a sorting number value in between like 5, 15, 25, etc.
It appears you want the groupings sorted non-alphabetically in a table view. The only way to accomplish what you want is to prefix the group names with a number (or other prefix) that will sort as you want. For instance, make the group names literally 1. Commercial, 2. Commercial Introduction, and 3. Commercial Delete, with the 1., 2., and 3. actually in the names.
I was afraid of that, but thank you for the support
Yes, @Steve is correct. I didnโt catch that you wanted the Groupings themselves sorted. Sorry about the confusion.
I have played with AppSheet trying to see if I can get Group Sorting accomplished some other way but there just isnโt. Many others have seen the same problem. I have opened the Feature Request below for it. It just needs attention from other developers to get it prioritized.
FYI, I focused on Ref columns in the Feature Request because if you are applying a custom sort for Group headings, you will likely want to do something like what i described above. The best way to manage that is in its own utility table and then Ref to it - not within your data tables.
Iโm having the same problem regarding how to customize my own sorting. But what I did, I make a virtual column name โRef Sortโ then use the switch formula.
In using formula Switch you can assigned value which will be used in your View Options.
The sample of the Switch formula:
switch([Priority_Level],โDelayโ, โP0โ, โNormalโ, โP1โ, โHighโ, โP2โ, โP3โ)
Note: Virtual Column DataType must be in โTextโ.
translating:
Switch([Source Column], โvalue1 in the columnโ, โcharacter to replace value1โ, โvalue2 in the columnโ, โcharacter to replace value2โ, โฆโDefaultโ)
Then use the Virtual Column โRef Sortโ in view options โSort Byโ
Hope this helps.
If you have a reference list already in the desired order, you can sort a different list containing some subset of the values in the reference list using INTERSECT():
INTERSECT(
{"High", "Normal", "Low"},
{"Low", "High"}
)
would produce a two-item list with the values: High
, Low
, in that order.
Going to have to play with these ideas. Looks like good work around options guys.
Have a Merry Christmas guys!
User | Count |
---|---|
39 | |
26 | |
23 | |
20 | |
15 |