Infopath

Last post 11-04-2008 02:38 AM by Hari Krishna. 3 replies.

Page 1 of 1 (4 items)
	Sort Posts: Previous Next

Reply Contact

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?

Mark as Not Answer Mark as Answer ...

Reply Contact

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.

Mark as Not Answer Mark as Answer ...

Reply Contact

Many thanks for your reply.

But where do I type this code.

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

Mark as Not Answer Mark as Answer ...

Reply Contact

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;

Page 1 of 1 (4 items)