Sort Dropdown (EnumList or Enum) by its previously selected values

[Hojati]

Hello everyone, I want to have my previously selected values on top of my dropdown list and also have the ability to add new values. Since I edit these field frequently I’m trying to avoid searching for each record to remove it from the list. Any suggestions?
Thank you in advance.

[Rafael_ANEIC-PY]

Hello @Hojati, welcome to our community !

Hojati:

I want to have my previously selected values on top of my dropdown list

That means we need to register how many times each record has been selected, and then we need to sort by it.

You could do that with an expression loaded into a virtual column (updated on each sync) or a normal column (updated by actions) on your table of dropdown list options (if it exists), depends on your app structure and preference.

Hojati:

the ability to add new values

You need a separate table only for your enum list values then, there will be a reference to this table from the table where the values are added, and it will allow you to add new options directly from that form.

[Hojati]

Thank you @Rafael_ANEIC-PY
Let me describe a simplified structure of my App,
Table 1: Member
Columns: [MemID](key)

Table 2: Com
Columns: [ComID](key), [ComMem](EnumList, Ref to “Member” Table, Valid If: Member[ID]), [ComMemBefore](EnumList, Ref to “Member” Table, Gets updated after [ComMem] updates

I’ve added [ComMemBefore] to log the changes and don’t use it in forms and views. I tried to use it as “Suggested values” for [ComMem] to show at the top of dropdown which didn’t work.

Rafael_ANEIC-PY:

how many times each record

So I have a logging system and counts don’t matter
[MemID] has about 800 records and [ComMem] has about 40 records selected. I want to see these 40 records above the list when I want to edit [ComMem].