General

Re: Infopath

Hari Krishna — Tue, 04 Nov 2008 10:38:07 GMT

Hi,

Paste this code in fields on after change event to the field which you want to generate autonumber.

public void field1_OnAfterChange(DataDOMEvent e)

{

if (e.IsUndoRedo | isNull)

{

return;

}

if (e.Site.text == "")

{

isNull = true;

thisXDocument.DOM.selectSingleNode("/my:myFields/my:field1") = Guid.NewGuid().ToString();

isNull = false;

}

Do remember to declare isNull variable:

private bool isNull = false;

Kajal Patel — Tue, 04 Nov 2008 10:15:57 GMT

Many thanks for your reply.

But where do I type this code.

Sorry I am not sure. I am new to Infopath.

Hari Krishna — Tue, 04 Nov 2008 10:03:20 GMT

Hi,

You can generate an auto number by using this code:

thisXDocument.DOM.selectSingleNode("/my:myFields/my:field1") = Guid.NewGuid().ToString();

Here field1 is the field in which autonumber is stored.

Kajal Patel — Mon, 03 Nov 2008 15:04:44 GMT

I just need an Auto number created in my InfoPath form which then can be submitted into SQL. I do not have any repeating table.Can someone help me?