How to create a dropdown with options

(0) Share

Report

Posted on by matthewjd24

Hi all, I'm having difficulty creating a dropdown field with 3 options in VS Code. There seems to be a good amount of information online but I have failed to get them to work. This looks like the desired result:

Things I've tried:

Create a table for dropdown options and add a field with a relation to the table. This isn't ideal since it does not look like the above and also seems unnecessarily complex.
Create an Enum for dropdown options (per https://yzhums.com/5985/). The dropdown looks like above but selecting anything doesn't actually update the table!
Using fieldgroups. I haven't figured out the logic behind fieldgroups nor have I gotten them to work.

Any advice is appreciated. Thanks!

I have the same question (0)

All responses (2)

Answers (1)

Suggested answer

Inge M. Bruvik 1,057 Moderator on at

Like (0)

Report

RE: How to create a dropdown with options

If you define a field based on your enum the database will be updated.

Another alternative is to use the option data type in AL. Works pretty much the same as an enum but can not be extened.

Maybe you should share your table definition if you can not get it to work?

Was this reply helpful? Yes No
Verified answer

YUN ZHU 93,872 Super User 2025 Season 2 on at

Like (0)

Report

RE: How to create a dropdown with options

Hi, Hi, there is nothing wrong with using Enum, some of the standard functions also use Enum. It will be stored in the table as an Integer.
For example,

Account Type in General Journals:

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No