Assign an option field value

Rahila
Member Posts: 16
Hello All,
i have a field type option where i want to assign the options like
Option 1 -> 0,0 - 1,0
Option 2 -> 0,0 - 2,0
and so on. How can i do it on NAV 16 and above
i have a field type option where i want to assign the options like
Option 1 -> 0,0 - 1,0
Option 2 -> 0,0 - 2,0
and so on. How can i do it on NAV 16 and above
0
Answers
-
I could add quotes (single or double) around the options, but that didn't really help.
To replace the comma with a dot as "decimal separator" worked better. Will that do for you?IF User.Loves('Edo') THEN ok() ELSE currReport.genSkip;0 -
In the properties of the option field you can enter something like 1,2,3,4,5 as OptionString, and use the OptionCaption to hold '0,0 - 1,0','0,0 - 2,0' or "0,0 - 1,0","0,0 - 2,0"
The option string can also be something like 'zero to one','zero to two' if you want to make them more descriptive, but the user will see the Captions on the screen.
Will that do?IF User.Loves('Edo') THEN ok() ELSE currReport.genSkip;1 -
This
0 -
That should be possible with OptionCaption, only option 0,75–0,0 is twice in the list, and all captions must be unique. But with 0,75-0,0 and 0,75–0,0 that can be done too (one is a hyphen, the other a long hypen).IF User.Loves('Edo') THEN ok() ELSE currReport.genSkip;1
-
the option-string is what you as a developer see in the code. The option-caption is what the user will see on the screen. Make the option-string something like 1,2,3,4,5,6,7,8 and use the caption to make it sensible values.IF User.Loves('Edo') THEN ok() ELSE currReport.genSkip;1
-
Maybe it's a NAV16 thing... I tried it on NAV17, I do not have a NAV16 anymore. Maybe someone else will come along with NAV16 that can help you out...IF User.Loves('Edo') THEN ok() ELSE currReport.genSkip;0
-
I used "one,1","two,2","three,3" and that compiled nice. But I didn't run the results, now I see at runtime NAV is making it 5 options (the last one is even missing). For me, this is a bug.IF User.Loves('Edo') THEN ok() ELSE currReport.genSkip;0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions