Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

How to make Calculated field of Data Type Multiple Lines of Text?

(0) ShareShare
ReportReport
Posted on by 515

Hello,

There is no calculated field option for Multiple Lines of Text field, see attached image

[View:https://www.screencast.com/t/f4LdXdf1ZSM:750:50]

Is there any other way to create Target field that can contain new line (\n) character? 

For e.g is it possible to use Single Line of Text data type and concatenating it with New line character?

Thanks,

Ashish

*This post is locked for comments

  • urklnme Profile Picture
    urklnme 437 on at
    RE: How to make Calculated field of Data Type Multiple Lines of Text?

    another example of something that should be easy to do but requires more work (and maintenance) by the creator instead of included by Microsoft.

  • Verified answer
    Ashish Moradiya Profile Picture
    Ashish Moradiya 515 on at
    RE: How to make Calculated field of Data Type Multiple Lines of Text?

    Thanks all for your suggestions, finally I managed with Javascript

    function MyFunction()

    {

    var option = Xrm.Page.getAttribute('new_piclist').getText();

    Xrm.Page.getAttribute('new_cf2').setValue(option + '\n' + option);

    }

  • Suggested answer
    Ryan Maclean Profile Picture
    Ryan Maclean 3,070 on at
    RE: How to make Calculated field of Data Type Multiple Lines of Text?

    What are you trying to achieve?

    This is possible by using a workflow and "Append With" the info you would like to add to the multiple lines of text field.

  • AHMET TANRIKULU Profile Picture
    AHMET TANRIKULU 225 on at
    RE: How to make Calculated field of Data Type Multiple Lines of Text?

    You can create many single line calculated, and a multible line field, then create work flow,

    or business rule to merge single line filed to multible line filed.

  • Suggested answer
    RE: How to make Calculated field of Data Type Multiple Lines of Text?

    It is not possible to convert a single line text field to a multi-line text field. Instead you should create a new multi-line text field and move the data from the old field to the new field.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,466 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans