Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Suggested answer

Expanded Text Fields

Posted on by 420

Hi Folks,

Brand new to the forums, but I could use some assistance. I'd like to create new fields in the Contract module that would allow for lengthy text fields (say updwards and in excess of 1,000 characters in some cases).

The only solution I'm finding thus far is stringing together long notes fields becuase the avaiable fields are listed as "250" characters.

Wondering if there is a solution to creating fields, or expanding available text feilds allowable length, that anyone knows about or could point me in the right direction towards?

Many thanks,

Justin

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Expanded Text Fields

    After creating the user table, please refer the below link to form the DH files easily...

    santhoshsl.blogspot.in/.../making-sl-dh-file-easily-using-sql_2393.html

    Hope this may helps you

    Thanks

  • JustinOP Profile Picture
    JustinOP 420 on at
    RE: Expanded Text Fields

    Thanks, Carolyn!

    I’m going to take a look at this manual and see about setting up the custom fields / table. If I’m able to put together a quick guide on what I did I’ll post it back here (wasn’t able to find anything quickly on the forum search).

    Thanks again for all your help.

    Best,

    Justin

  • RE: Expanded Text Fields

    Hi Justin,

    There is some help in creating new tables for Dynamics SL in the SoftwareDevelopmentKit.pdf located in the User Guides folder of your SL install folder.  This topic begins on page 35 of that manual.  The user guides are also available in CustomerSource under Documentation.  Let me know if you find the user guide.

  • JustinOP Profile Picture
    JustinOP 420 on at
    RE: Expanded Text Fields

    Hi Carolyn - thank you very much for responding back to my post, I truly appreciate it.

    The SNOTES seems to have a cap of 750 text per column, with 3 columns available, so it likely won't fit my needs.

    Regarding the data table, that might be just the ticket. Was there a quick guide/link you might know of or a trick to creating a fairly simple table in SL?

    Many thanks,

    Justin

  • RE: Expanded Text Fields

    Hi Justinop,

    You cannot change the length of existing fields.

    You may have some luck creating your own table to store the data.   Might be able to get up to 3000 char that way.  

    Perhaps you could also use the SNOTES functionality to store long notes.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,835 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,526 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans