News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... field should only acce...

Small and medium business | Business Central, N...

Answered

field should only accept number

(1) Share

Report

Report

Posted on by Community member

4

I need to create a field that should only accept number. No texts / symbols are allowed.

What is the AL code for the same? What is the validation code?

All responses Img

All responses (3)

Answers Img

Answers (1)

Suggested answer

YUN ZHU 73,565 Super User 2024 Season 2 on at

Like (0)

Report

field should only accept number

Hi, hope the following helps.

Dynamics 365 Business Central: How to quickly check whether the value is numeric in AL

https://yzhums.com/47766/

Dynamics 365 Business Central: How to prohibit users from entering illegal characters such as emoji, Hiragana, kanji, etc.

https://yzhums.com/41529/

Thanks.

ZHU
Suggested answer

Mohamed Amine Mahmoudi 9,536 Super User 2024 Season 2 on at

Like (0)

Report
field should only accept number

Hi,

you can create a field with type integer

field(10; number; Integer)

if you want use Text or Code type you must use Numeric = true

field(10; number; code[20]) { Numeric = true; DataClassification = ToBeClassified; }

Best regards,

Mohamed Amine MAHMOUDI
Verified answer

Mohana Yadav 59,137 Super User 2024 Season 2 on at

Like (1)

Report

field should only accept number

Please try Numeric property.

https://learn.microsoft.com/lb-lu/dynamics365/business-central/dev-itpro/developer/properties/devenv-numeric-property

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2

Martin Dráb 230,188 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans