Newbie Questions

Re: Creating autonumber field

afp rick — Fri, 11 Feb 2011 12:07:45 GMT

I tried your code. It works with: vertalen(nu(); "T:-"; "")

Thanks.

Re: Creating autonumber field

Jimmy — Fri, 11 Feb 2011 11:47:41 GMT

You shouldn't need to use three nested translate() functions. translate(now(), "T:-", "") or, I suppose, vertalen(nu(); "T:-"; "") should do the trick.

You also don't need to use substring() at all if you want to use the whole date value without removing anything.

Re: Creating autonumber field

afp rick — Fri, 11 Feb 2011 11:19:28 GMT

This is great! Has been a great help.

Dutch users should use: subtekenreeks(vertalen(vertalen(vertalen(nu(); "T"; ""); ":"; ""); "-"; ""); 1)

Re: Creating autonumber field

Hilary Stoupa — Wed, 14 Jan 2009 22:18:51 GMT

You can use translate for this. I'm attaching an IP 2003 template where the default value of the first field on the form is set to display yyyymmddhhmmss:

translate(translate(translate(now(), "T", ""), ":", ""), "-", "")

is the formula. If you want only digits for year, you can use substring to remove the first two (see the second field on the form):

substring(translate(translate(translate(now(), "T", ""), ":", ""), "-", ""), 3)

Re: Creating autonumber field

morgandally — Wed, 14 Jan 2009 14:56:22 GMT

it will only let me use vbscript or jscript

Re: Creating autonumber field

Anuma — Wed, 14 Jan 2009 14:28:54 GMT

Actually above code which i given is c# code not jscript.

Re: Creating autonumber field

morgandally — Wed, 14 Jan 2009 13:24:14 GMT

That code was accepted without errors in script editor but then when i tried to preview the page it came up with "InfoPath cannot create a new, blank form. The form template is not valid"

When clicking on the more info button it comes up with

"InfoPath cannot open the selected form because of an error in the form's code.
The following error occurred:

Expected ';'
File:script.js
Line:17
XPathNavigator xn = this.MainDataSource.CreateNavigator();"

It is probably me just been an idiot, any ideas?

Re: Creating autonumber field

Anuma — Wed, 14 Jan 2009 13:05:10 GMT

Hi,

Can you try below code.

XPathNavigator xn = this.MainDataSource.CreateNavigator();

XPathNavigator date1 = xn.SelectSingleNode("/my:myFields/my:field1", this.NamespaceManager);

string num = DateTime.Now.ToString("yyyyMMddHHmmssff");

date1.SetValue(num);

Re: Creating autonumber field

morgandally — Wed, 14 Jan 2009 09:08:38 GMT

Tried that formula and it just said formula contains one or more errors

Re: Creating autonumber field

Rajitha — Tue, 13 Jan 2009 12:33:28 GMT

Hi,

You can use below code line to get the unique number.

DateTime.Now.ToString("yyyyMMddHHmmssff")

And assign this value to the field in which you want to generate autonumber.

Hope this helps.

Re: Creating autonumber field

madhuri — Tue, 13 Jan 2009 12:21:07 GMT

Look at the below link

http://radio.weblogs.com/0131777/stories/2004/02/22/howToCreateAnAutonumberField.html

Creating autonumber field

morgandally — Tue, 13 Jan 2009 11:41:09 GMT

I would like to have an autonumber field in my form that is in the format of year/month/day/time to create a unique number for every form that is completed, can anyone help me out with this?