How to Create a Grouped/Categorized Dropdown for an EnumList of Type Ref?

[alex_dxw]

Hello,

I am building an app and need help with a dropdown menu. My goal is to have a multi-select skills field that groups the skills by category.

My Setup:

• A People table with a column named Skills.
  • The Skills column is set to Type: EnumList, with a Base type: Ref.
  • The Referenced table name for this Ref is SkillsAndTools.
• A SkillsAndTools table with these columns:
  • SkillID (The Key)
  • SkillName (The Label)
  • Category (An Enum with values like "Programming Languages", "Design", etc.)

My Question:

What is the current, best-practice method in the AppSheet editor to make the Skills dropdown automatically show the options grouped by the Category column?

I have tried setting the "Group by" option on the main UX view for the SkillsAndTools table, but this did not work. I also cannot find a "Referenced table view" or "Dropdown view" setting in the column details.

Thanks for your help