InfoPath Dev

I follow you, but then how do I run that query at submit time and insert the field value into my form document number?

Just a friendly reminder that anytime you hand author the XSL you risk incompatibility with InfoPath. The designer could blow away your changes or future clients won't even be able to open the form. The way we workaround this to select the button and choose the WebDings or other such dingbat font and then set the button label to the appropriate ...

Oh ok. Let's try another method. Instead of getting the highest number from the SPROC create a new Data Connection to the DB to just query all the document numbers. Then in the rule to set the form document number field value you will just set it to ''max()'' of the document number node in the secondary data source. That is the easiest way to ...

since i posted this: you can set the background of a table to a picture. then set the background of the button to none and it is see thru. hell of a lot easier than doing each button individually.

I suppose it is possible for two people to submit simultaneously, but wouldn't it be entirely unlikely to have the transactions at the same microsecond? Or am I being naive? Either case I don't know how to code the execution of the SPROC, then retrieve the value, then place into document number field at submit in jscript, so that when the record ...

Another option would be to add an additional data connection to query your DB just for all the document ID numbers or the last ID number via your SPROC. You could use rules to setup a multiple actions when clicking your submit button. The first action would query the DB for the latest DOC ID. The second action would then copy that value from ...

Thanks for the reply, but being a complete newbie to Infopath I am unsure where to start. Also, numbering gaps are not a horrible thing in this case, and if the process can be done at submission, then it would be safe to say that if the form does not submit, then the highest number in the table is still not used. Still searching for a solution.

Hello Boris, and welcome to our forum. Ah yes. We have to solve this exact same problem in advanced implementations of our Database Accelerator product. You have to do this server side to ensure you get the correct ID and you don't want it to happen if the submit fails for some reason. Using a web service will allow you to more closely ...

I am using info path as a form solution for one of my clients. The data source is MS SQL and has a primary field for document number. The script defaulted to jscript, so I am stuck using jscript for the scripting language. I am looking for a solution to increment to the next highest document number on form submit. I do have a stored ...

I couldn't find what I was looking for. If it has ben answered, please forward me to the posting. I am trying to use Access to collect data for the InfoPath form. I am using the drop down list which is a list of records in the Access database. I am using rules to populate the fields in InfoPath that I want. It does autopopulate; however, it ...