SharePoint Integration

Re: NaN shows up as the form name when the first form is submitted

Michael71 — Wed, 04 Mar 2009 17:02:25 GMT

Okay, If the steps above sets the ID to 1 if the Library is empty, that should take care of my problem.

Re: NaN shows up as the form name when the first form is submitted

Hilary Stoupa — Tue, 03 Mar 2009 20:59:00 GMT

I was simply giving you the steps to set the Id field to 1 if there were no rows returned from your SharePoint list. I had assumed from your earlier posts that you already had your submit rules set up... you can extend the steps I posted by setting a second rule to set the Id field to the Max(Id from ShP list) + 1 if the Id from the ShP list is present. Then use the Id field in your formula for the name of the form, and handle your submit however you were already handling it....

Re: NaN shows up as the form name when the first form is submitted

Michael71 — Tue, 03 Mar 2009 17:53:11 GMT

Hilary,

Where in the steps above does it tells the form to submit to the ducoment Library and if there are no forms, make @ID =1 or increment where it left off?

Re: NaN shows up as the form name when the first form is submitted

Hilary Stoupa — Tue, 03 Mar 2009 04:44:37 GMT

Let's see. Some things will change depending on the name of you data connection, data structure, etc.

Go to Tools / Form Options
Under the Open and Save section, select the Rules button
Add a new rule
For condition, navigate to your Id field from your SharePoint data connection in the first drop down
Set the second dropdown to 'is not present'
For the action, set IDEmpty to true (use the formula editor and select the true() function from functions)

This means that when the form opens, if there are no ID nodes from your SharePoint list, IDEmpty (which defaults to false) gets set to true. When it gets set to true, the rule on it fires, setting the form's ID field to 1. Does that help?

Re: NaN shows up as the form name when the first form is submitted

Michael71 — Mon, 02 Mar 2009 19:06:01 GMT

Hillary can you give me a step by step process, because I'm very confused. I don't know where to start.

Re: NaN shows up as the form name when the first form is submitted

Hilary Stoupa — Thu, 26 Feb 2009 00:50:56 GMT

The example is long and confusing, I know. When you say 'The condition on this field' do you mean you have rule set on IDEmpty? If so, you need to have another rule that changes IDEmpty -- rules only fire if the field the rule is set on changes. You could have an open rule (Tools / Form Options / Open / Rules) that sets IDEmpty to true if the count of rows returned from your ShP connection is 0.....

Re: NaN shows up as the form name when the first form is submitted

Michael71 — Wed, 25 Feb 2009 14:40:32 GMT

Hilary,

You are a great help. I don't understand the formula. What I'm trying to do is set the ID to 1 if there is no forms in the Forms Library, so my concat("I", "P", max(@ID) + 1, substring(DisplayName, 1, 1), substring(AgentSSN, 1, 1)) can work properly. for my data connection and submit. I set up a bollean field element called IDEmpty and set the value to false. The condition on this field states: If ID is Blank

Set a field's value @ID= 1

Don't think this is working.

The formula for the example is long and confusing.

Re: NaN shows up as the form name when the first form is submitted

Hilary Stoupa — Wed, 25 Feb 2009 02:12:34 GMT

Oh, I see, because there isn't a value in the secondary data connection to the library the for the first form to use. Is this a default value? Or is set by a rule? I suppose you could add an open rule to set the name to IP1W7, or whatever you want in place of NaN, but then you run into the issue of two users opening forms while there are none in the library, then one submits and the other has an invalid number....

You can actually create a default that is conditional. It is a little bit of a scary formula, but once you get used to it, it is a great tool. Here's a link to the InfoPath Team blog post on this approach. You'll want to take the second method mentioned. The boolean condition would need to check if there is a value in the id node returned by the SharePoint Library data connection. Give it a try, and post back if you get stuck, okay?

Re: NaN shows up as the form name when the first form is submitted

Michael71 — Tue, 24 Feb 2009 14:34:14 GMT

It's calculating, but the first item in the Library is always IPNaNW7. The NaN part of the Calculation is come from the Library, but because there isn't any forms in the Library the first form is always NaN. I just set up a secondary data source to the SharePoint Library.

Re: NaN shows up as the form name when the first form is submitted

Hilary Stoupa — Tue, 24 Feb 2009 01:40:50 GMT

HI -- can you explain more about what you are doing? Is the form name currently a formula that isn't calulating for some reason?

NaN shows up as the form name when the first form is submitted

Michael71 — Mon, 23 Feb 2009 18:17:48 GMT

How can I make the first form submitted not show NaN in the form name?