-
The problem is the missmatch between your SQL fields and the field types your checkboxes are bound to. You need to change from boolean type field to number in InfoPath, the fields the check boxes are bound to, and then configure the check boxes to be 0 or 1 to match your SQL data. That will get rid of your validation issues. ...
-
I have tried these rules before. When I am testing it in preview mode, whenever the rule applies, it is highlighting the checkbox with RED dots and giving me the error : Only 'true' or 'false' allowed.
This field is a bit data type in sql server and it is returning 0 or 1 to the infopath. How can I fix this?
Thanks
-
InfoPath form templates work with InfoPath clients or with a webbrowser client through leveraging InfoPath Form Services. A Web Server hosts the form, with some reduced functionality, for non-InfoPath clients.
You may also want to evaluate the Database Accelerator. It has lots of features for adding functionality to forms via ...
-
The data connections for the form are numerous, as follows:
4 xml files. Here is an example: \\dermfp\ProductDatabases\eurodatabases\eurocoretreat.xml
Several other databases (.mdb files) are on the same network drive as the xml files.
There is another retrieve data from the sharepoint site that just gets names from a sharepoint contact ...
-
Typically you would add a rule to the drop down with an action to set a field value. You would select each checkbox and then set it to the value from your secondary connection with the filter custID = dropdown.
You may want to check out the Database Accelerator, if you are working with SQL data. It allows you to query and submit to ...
-
You could try adding it again fresh and see if that clears it up. Just drag another one on to your view and preview. It may have gotten something in it while you were adding and removing controls.
Also you can use conditional formatting in the display properties to hide blank rows.
-
I need a solution for creating electronic forms that can be accessed by multiple users via a browser. I have used acrobat pro and find it simple to use but im being pushed towards Infopath. My question is; will every user that wishes to access the form require infopath client in order to get full functionality out of the ...
-
Well that was a late night brain fade.....problem was I was creating the element, but not the attribute that the drop down was bound to. DOH!
-
Hi,
I have an infopath form that contains a drop down list and some checkboxes. I am maintianing a table in sql server 2000 with the same fields. (CustID (primary key) and some boolean values). I have created a data connection with sql server to bind the CustID with dropdown list. Now, my requirement is whenever the user selects the CustID ...
-
Ok Torsten, that is what I wanted to know.
What data connections does it have?
I would suggest publishing it to a test library, ideally on a seperate site and see if you get the same issues.
So no warnings or errors until submit? Also can you paste the details of the error message here?
Thanks