-
Yes, when you create a new template, InfoPath will provide you with the option to create your form from an existing schema.
-
Could you give this a try:
concat("<query database='clientdata' table='vwOrganizationLocationWithAddress'><columns><column name='OrgName'/><column name='Address'/></columns><filter><and><eq><column ...
-
Those are the queries for setting up the data connections, but what are the actual query formulas that you're using in your rules?
-
Hello Jtcom,
Could you post the formula you're using the for the query that's generating that error?
-
If you open the properties dialog for the field the dropdown is bound to, you should be able to set up a default value there.
-
Hello saswiss,
Unless I'm mistaken, there should no difference in how to do this between a text box and a dropdown box. How are you accomplishing it with a textbox?
-
You can use the condition is blank/is not blank to determine whether a file has been attached or not. You can also specify the Cannot be blank option directly on that field to have the validation handled automatically.
-
Most likely the node has an xsi:nil attribute that needs to be removed. Please search this forum for xsi:nil for more detail.
-
Anything that involves adding rows to a repeating table can't be done with InfoPath's built-in features, but you can accomplish this fairly easily if you have qRules, using the DateDiff and Insert commands. If you can download the trial version of qRules, inject it into a blank form, and attach it to this thread, I can show you ...
-
Well, my formula should work as long as the year is 4 digits and the month and day are 2 digits. If they're not, you'll need to add the 20 or leading 0 to sure them up.