locked
Advanced CRM 2011 Autonumber Codeplex RRS feed

  • Question

  • Hi everyone

    Did anyone tried the Advanced crm 2011 autonumber solution on codeplex. I've used it for one of my requirement and got it working almost but couldn't accomplish one last thing.

    Is there a way to get the two digit year ( not 2012 jut 12) from createdon date while configuring the display format(in the solution) during record creation?

    I've tried something like

    ABC_{createdon.Substring(7,2)}_{CurrentPosition.PadZero(5)}

    but it doesn't get the year right all the time. ( E.g. I wanted the display format to work in all scenaris 7/30/2012 , 7/3/2012, 10/3/2012, 10/30/2012). I'm not sure if this is possible with substring? I've tried couple other functions on createdon date but everything returns a empty value.

    Friday, September 7, 2012 7:21 PM

Answers

  • Disclaimer: I work for North52, and we have both free (community edition) & paid options on our product.

    N52 Formula Manager has a function used for auto numbers which will resolve your issue & you don't need any coding. The best  bit is that there is a free community edition available so you can deploy to production environments for free. 

    Here's a link to a video showing how it works & the formatting of the number is completely flexible.

    http://www.youtube.com/watch?v=72aCs1a78BE

    Those looking for specifics on the algorithm we use can read the blog post below which is very similar to what we do internally.

    http://connect.greenbeacon.com/2012/01/technical-post-implementing-robust-microsoft-dynamics-crm-2011-auto-numbering-using-transactions/#comments

    John Grace (Founder, North52) Simplifying CRM & xRM development
    How? Check out Formula Manager at, North52

    • Marked as answer by crmsurfer Friday, September 21, 2012 2:05 PM
    Friday, September 14, 2012 11:18 PM

All replies

  • Disclaimer: I work for North52, and we have both free (community edition) & paid options on our product.

    N52 Formula Manager has a function used for auto numbers which will resolve your issue & you don't need any coding. The best  bit is that there is a free community edition available so you can deploy to production environments for free. 

    Here's a link to a video showing how it works & the formatting of the number is completely flexible.

    http://www.youtube.com/watch?v=72aCs1a78BE

    Those looking for specifics on the algorithm we use can read the blog post below which is very similar to what we do internally.

    http://connect.greenbeacon.com/2012/01/technical-post-implementing-robust-microsoft-dynamics-crm-2011-auto-numbering-using-transactions/#comments

    John Grace (Founder, North52) Simplifying CRM & xRM development
    How? Check out Formula Manager at, North52

    • Marked as answer by crmsurfer Friday, September 21, 2012 2:05 PM
    Friday, September 14, 2012 11:18 PM
  • Thanks for your response. I'm just curious what is the difference betten free and paid editions. I would like to try the community edition in our environemnt if there is no purchase required for it.
    Friday, September 21, 2012 1:56 PM
  • In terms of functionality there is no difference.

    However the community edition only allows you to create & use 10 formulas within your CRM system.

    So if you just need a few formulas like auto-number, then with the community edition its all free. But if you like it & you start to use it lots (> 10 formulas) then we have a paid version where you can get in-depth support, training, etc. 


    John Grace (Founder, North52) Simplifying CRM & xRM development
    How? Check out the Free Community Edition of Formula Manager at, North52

    Friday, September 21, 2012 2:22 PM