Sort Manually Entered Enum Possible?

[mykrobinson]

I know that I can use SORT() in order to sort suggested values, but how can I sort Enums that were manually entered?

I am editing an app created by someone else and they have put a list of surgeon names directly into AppSheet as an Enum, so when they are filling out a certain form, they can select the surgeon from the dropdown.

One solution, and one that I like, is to migrate the list of names to a dataset/spreadsheet, and have the values pulled in by appsheet and subsequently sorted.

But i also want to learn if I can sort the manually entered Enum values too, just to have options.

Thanks

[SkrOYC]

If the data is inside the Enum “Values” section, just move it to a LIST() expression and place that one on the Suggested Values.

Then, as a list, you can use the expression you need by wraping LIST()

[mykrobinson]

so just use something like

SORT(List([columnName]),false)

would that do the trick? (guess i could try it and see)

[mykrobinson]

update: i tried that and it did not do what i expected. You mind explaining further what you mean by move it to a LIST() ? I’m apparently misunderstanding something

[SkrOYC]

Let me check something first.

I guess that there where some options available but new ones have been added and now are shown on the dropdown? I mean, it should show something like “Add a new one” at the top. If that’s the case, I would do this on suggested values:

SORT(
  TableName[fieldName_TheEnumOne]
)

[Steve]

The order of the explicit values given in the Enum column’s Type Details section determines their sorting order. If you reorder the values in the configuration, their sorting order will change accordingly.

[mykrobinson]

okay, so my best bet is to change the method that provides the values and instead pull from a table so I can subsequently sort. Otherwise, everytime anything is added, it will need to be manually resorted, sounds like.

Thanks

[SkrOYC]

I think that the answer is no.

@Steve is talking about the manually entered data under Enum/EnumList column config

[Steve]

Here: