HowToFixComputers.com

Jason · Guest

This is the closest message board topic I could find to deal with infopath-

I am using infopath 2007 to create a Purchase order form that is to be
published to a WSS version 3 site. The problem I am having is assigning a
unique PO number to each form submitted to the sharepoint library. I thought
I had it going when I changed the data binding for the PO text box to point
to the PO column in the library and then assigned the following value to the
default value: "max(.) + 1" I thought this formula would take the maximum PO
number and increment it by 1. Then when the user opens up the form, it
should run the formula and then is submitted.

When I publish the form and try it out, infopath opens with "NaN in the PO
text box which means invalid data.
Does anyone have any tips on a way to get this working? I do not know have
visual studio installed and I'm thinking I'm on the right track... Any help
would be very very appreciated-

Bob Buckland ?:-) · Guest

Hi Jason,

The links below will take you to the Infopath discussion group.

=============
<<"Jason" <4f7cdf1c-1850253564@news.postalias> wrote in message news:027ACCC6-3D12-42A0-8D81-7388DCEE5FCC@microsoft.com...
This is the closest message board topic I could find to deal with infopath-

I am using infopath 2007 to create a Purchase order form that is to be
published to a WSS version 3 site. The problem I am having is assigning a
unique PO number to each form submitted to the sharepoint library. I thought
I had it going when I changed the data binding for the PO text box to point
to the PO column in the library and then assigned the following value to the
default value: "max(.) + 1" I thought this formula would take the maximum PO
number and increment it by 1. Then when the user opens up the form, it
should run the formula and then is submitted.

When I publish the form and try it out, infopath opens with "NaN in the PO
text box which means invalid data.
Does anyone have any tips on a way to get this working? I do not know have
visual studio installed and I'm thinking I'm on the right track... Any help
would be very very appreciated- >>
--
Please let us know if this has helped,

Bob Buckland ?:-)
MS Office System Products MVP