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)

Sort by

Suggested answer

IB-29041624-0 1,191 Moderator on at

Like (0)

Report
Copy link

Link copied!

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 101,995 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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