-
Oh - did you use the fx button? It is a function, you need to type it into the formula editor dialog.
:-)
-
I think what you are missing are the InfoPath processing-instructions. If you open your InfoPath form and use File > Save As and save an XML file, you can then open the file with a text editor. You'll see at the top some processing-instructions that start with <?mso-infoPathSolution PIVersion="1.0.0.0" etc....
-
To know what the "next" number is, you'd have to write code to loop through those file names and get the last used number. This would require your form to be full trust, because the code is touching the file system. I would find something else for my unique id. It seems to me that the date / time of the request combined with the ...
-
I simply used your form. I have asked the test team to assess the current documentation - I agree that we have some gaps there.
-
So - here's the thing that is making this tough for you.
To "auto increment" the next number... you have to know what the last used number was. If the information isn't stored any place (like SharePoint, SQL, Access) you don't have a way to get the last used number into the next form. Does that make sense?
Personally? I ...
-
Do you have the same result when you open from the published location?
-
So, the part of the formula that is failing in your form is the part to get the href from the XML processing instructions. Can you change processing-instruction()[local-name(.) in the formula to /processing-instruction()[local-name(.) and give it another try? No need to bother clicking the button to execute the query if you can see the page URL is ...
-
Couldn't you just concat the value from your date picker with " 00:00:00" ? I've attached a sample - right click the file link in the header of this post and save locally. Right click the saved file and preveiw.
-
I'm assuming you mean you used the field picker in the formula?
I've added some controls and buttons to your view and reattched the template. Can you preview the template and first click the button named "Set page URL"? The Page URL field should then be populated. Can you see if it is a valid URL? You can copy it and paste it in ...
-
What would they be automatically filled with? That is, would the new repeating section have the same values the one before? Or would default values for the fields do the trick?