General

Re: Auto-number formatting with leading zeros

Svetoslav — Fri, 13 Nov 2009 10:09:06 GMT

Hi dalmeidd,

it will be very easy if you apply some Jscript code. It will not include more than 10 lines. If you haven't solved the problem here is a very simple code how do it:

XDocument.DataObject["Data connection name"].Query;

var objList = XDocument.DataObjects["Data connection name"].DOM;

objList .SetProperty(".....")

var nodes = objList .selectNodes("here is the dfs path\@ID");

maxID = nodes.Math.Util(nodes)

uniqueID = maxID +1;

while ((uniqueID.toString()).length <number of length you want )

{

uniqueID = "0"+uniqueID;

}

This is a very fast example so there can be some errors. But the idea is correct. Hope you get it fast.

Regards,

Svetoslav

Re: Auto-number formatting with leading zeros

Hilary Stoupa — Fri, 10 Apr 2009 15:04:16 GMT

Sorry for the delay on getting back to this thread! I'm confused as to what multiple submits have to do with this? At any rate, you can submit using rules, and set up multiple submit data connections and use rules and conditions to choose which connection to submit with. What do you mean by 'nothing shows on the front end'? Where are you submitting to?

Re: Auto-number formatting with leading zeros

dalmeidd — Sat, 04 Apr 2009 12:10:09 GMT

The formula is a rule and I was able to create the conditions but it doesn't work because the submit button only works with one data connection. I tried to create multiple data connections based based on the number of rules but it still doesn't work. when i submit, it says the form is submitted succesfully but nothing shows on the front end. What else can I can? Thanks

Re: Auto-number formatting with leading zeros

Hilary Stoupa — Sat, 04 Apr 2009 00:38:06 GMT

Hmmm. I'm not sure if there is a formulaic way to pad a number with zero in InfoPath. Is this formula in a default value? Or a rule? In a rule, you could set conditions, like if max(@ID) + 1 is less than 10 use the formula concat("LR-DP- 000", max(@ID) + 1) and if max(@ID) + 1 is greater than 9 but less than 100 use the formula concat("LR-DP- 00", max(@ID) + 1) and so forth... but if you are using a default, you'd have to try to make the default conditional. There are ways to do that (see this post) but they can get rather complicated...

Auto-number formatting with leading zeros

dalmeidd — Fri, 03 Apr 2009 18:29:36 GMT

I'm trying to create auto number with leading zeros but it's not quite working. the format i want is "LR-DP-0001", with the number incrementing like 0010, 0110, 1110. Currently the code i'm using is: concat("LR-DP- ", max(@ID) + 1). I don't know how to do the leading zero. Help?