Character limits in text fields

(0) Share

Report

Posted on by Community Member

Hi,

I need to have a product description field where I can add really long formatted lists, 1000+ characters.
Since SQL can handle it I don't see why Navision can't. I am OK with creating a new field if necessary.

Is this possible in Nav2016?

Thanks for all hints in the right direction

HHi

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

No not possible. A field of type = Text on a NAV table can be max 250 length. This is by design.

I suggest to use Description (50 chars as default), Description 2 (50 chars as default) and for longest item descriptions there is the standard Extended Text table where you can place text as long as you want (N rows).

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks a lot for your help.

Was this reply helpful? Yes No
Suggested answer

Ahmed Mohamed Rafik 3,049 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

You can use the "Standard Extended Text" for long formatted characters.

If you find this information helpful, Click Yes to Verify the answer to share with other community members.

Was this reply helpful? Yes No
Claudio Martell 50 on at

Like (0)

Report
Copy link

Link copied!

Hi,

If you have development skills you can create a Blob field on the NAV table, this allows you to store unlimited text. The Blob field though will not be displayed as a normal field on a Page so there will be some development work to make it visible and editable.

The alternative is, as other have said, to use mulitple (max 250 character) text fields. Take care in creating large text fields or Blob fields as they can affect performance.

Hope this helps.

Claudio

Was this reply helpful? Yes No
Suggested answer

Andrey Baludin 3,943 on at

Like (0)

Report
Copy link

Link copied!

There is a good article by keoma about this topic:

community.dynamics.com/.../how-to-work-with-big-item-descriptions

Was this reply helpful? Yes No