-
I know that since they submit correctly the tables are probably linked correctly, but if I wasn't getting results, I think that is what I'd check next. You can click the 'Edit SQL' button in the data connection wizard to see the SQL -- while it is different from the t-SQL you'd use to when you write a query against your ...
-
Are you asking about designing forms or filling them out? To design a browser form, you need InfoPath 2007.
-
Hi--
You can use XPathNodeIterator for this. For example:
XPathNodeIterator nodes = MainDataSource.CreateNavigator().Select("/my:myFields/my:group1/my:group2", this.NamespaceManager);
string ...
-
I'm also just taking a wild guess at what you want... but if want you want is data validation on the field they are entering hours on to prevent them putting in anything but numbers ending in .0, .00, .25, .5, .50, .75 you can add data validation to the field. Under the properties of the field, select Data Validation. For the first drop down ...
-
Have you had one of your 'submit successful' users log onto CP's machine and try to submit?
-
One thing that can help you sort out data issues sometimes is to create a new view and drag your entire data source over to it, just select Section with Controls and IP will hodge something together for you. Then you'll have a view that shows everything that you can turn to after you run a query.... it may help you narrow down your issue.
-
I would use one or more tables per form template. So, let's say you intend to create templates for a Purchase Order and for an Expense Report -- those two forms have very different purposes. You'd want to create a table that holds your Purchase Order information (possible more than one table -- a Purchase Order could very easily describe a ...
-
I'd add a field to the form data sourct to contain the file name. You can then use submit rules to populate that field with the same formula you use to generate the name, only populate the field if it is blank, and do that immediately before you submit....
-
If you are referring to creating browser compatible forms, I think this option is only available in InfoPath 2007.
-
Add data validation to the field that the date picker is bound to. Your data validation should have two conditions -- the first would be Status = Completed and the second would be DatePickerField is blank.You'll want to leave the default 'and' between the conditions. Then you can enter the error information in the Screen Tip field. ...