web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Format of an integer i...
Microsoft Dynamics CRM (Archived)

Format of an integer in Dynamics CRM

(0) ShareShare
ReportReport
Posted on by Community Member

When i create an integer attribute in Dynamics CRM the format (or display) of this integer is always with a dot. For instance 10.001.

For a particular workflow i have to use the value of an integer without dots.

It is possible to format an integer to use comma's instead of dots, however it isn't possible to format a integer (or number) without dots.

Is there another solution for this problem?

I've tried Client Side Scripting (Javascript) but in order for this to work i need to open the entity and save it manually.
Because the creation of this particular entity is automated and there are 500 records created every day i'm not going to manually open and save/close these records ;)

*This post is locked for comments

I have the same question (0)
  • Neil Benson Profile Picture
    Neil Benson 7,369 User Group Leader on at

    The formatting of integers is based on the user's preferences: Options > Formats > Number. The integer stored in the database will be, for example, 123456789 but this could be displayed to the user as 123,456,789 or 123.456.789 depending upon their number format option.

    You should probably ignore the punctuation in your workflow.

    Neil

  • Community Member Profile Picture
    Community Member on at

    Thanks for the Reply Neil,

    However the Workflow(s) literally copies the integer as shown in the Field (with dots or commas), not the true value wich is stored in the Database.

    I find it very strange that the formatting options do not contain the option "None" even though this is what's stored in the Database.

  • Community Member Profile Picture
    Community Member on at

    hi, did you try Neil Benson's option? by changing the configuration? if yes, did it work?

    ty

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Hi, yes i did try that, unfortunately it had no effect. We solved this by creating a workaround. We've created a job wich copies the integer to a varchar field. We then use the varchar value (without dot) in our workflow.

  • Community Member Profile Picture
    Community Member on at

    I managed to solve my problem in a different way.

    I changed the personal settings of a administrator user to format the numbers without grouping them with dots, and made the workflow run as the owner of the workflow, this user being the owner, it uses the number without dots, but i'm still testing this solution.

  • Community Member Profile Picture
    Community Member on at

    And do you use Dynamics CRM 4.0 or a higher (newer) version?

  • Community Member Profile Picture
    Community Member on at

    I use CRM 2015 online

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans