-
you will need to use the nz function in conjunction with what you have. what that does is return zero if there are no other number or other problems.
Also it is best to have this done on the database side to handle multiple people using the form at once.
-
I'm trying to create an infopath form that publishes to a Sharepoint database. I'm using a custom submit buttom to assign a sequential form number when posting to database. The submit button uses a rule an a data connection to assign the form number as max(formnum) + 1. Where I'm having a problem is on the initial ...
-
In a sense.
It would be a type of workflow to process the form, possibly create the location for it, update the permisions, and then move the form there.
How will the users keep track of the forms and the specific location they end up?
Seams like this would be an issue trying to find your form.
It may be easier if each user had a personal DL ...
-
OK thanks for the info. I will look into Qdabra DBXL to see if that helps me.
-
Hi Clay,
Isyour suggestion to do the Sharepoint Designer means involves workflow?
-
hello all,
my team needs to work on multiple form templates controlled through team foundation server. we are running into problems with have multiple infopath projects in one solution however. has anyone had trouble with this and if so, how did you get around it?
thanks!
-
Qdabra's DBXL can handle your scenario. It would also mean you wouldn't have to redesign your form. I do not know of a way in InfoPath to take a form that has been based off an XSD and change it to using a database as its main data connection -- I think in order to do that, you would need to start over on your form.
May I make a ...
-
One such solution is described here.
-
Aha, not so obvious,but still easy. Shouldn't have shied away from the content type management in the first place.
Anyhow, this works, so thanks a bunch!
-
That is a good question. I wish I knew more about Infopath to answer why he did that. I tell you what we are doing and see if that helps. The form is going to be put on laptops and the users will enter the data outside the office. They won't have a direct connection to the sql server database that is located here in the office. They ...