-
Attaching your Word doc w/ screenshots & description.
-
Under the Options tab in a reply you can add a file with screenshots - currently your screenshots don't display. If you need your form to submit to SQL, you will either need to start with a database bound template, or you can use code or web services (write your own or buy a 3rd party) to do that.
-
Right click the link in the header of this reply, and save the file locally. Right click the saved file, and select design. The validation rule is on field2. :)
-
I'd verify the query returns data. Just drag the whole data source into a single view, query & data fields, and add a button to query the data source. Then you can test & verify data is returned.
-
Multi select controls are bound to repeating fields - but you can still have a filter on them so that they are cascading.
-
Add a rule to the field the dropdown is bound to. Set the rule condition to the field being equal to "Other" (if that is the display & the value). Then have the rule action set the value for the field bound to the text box. The validation rule on the text box would have the condition that the text box field is blank and the ...
-
If you are looking for exact matches, the format of the field may be the issue. Put the returned data on the form in a manner that shows the actual value (use text boxes, set the format to show the XML value). Another great way to figure this stuff out is to drag the entire data source, query & data fields onto the form and add a button that ...
-
I don't see any rules on the Check for Duplicates button that set query fields in the Convening_Reqs data source prior to running the query. You need to set query fields to limit the results.
-
Thanks for the data point - IP views in my experience occasionally end up with some weird corruption that only a new view will fix.
-
I think you have an order of operation issue. :) Is FileName using a default value made up of your other fields? When does the duplicate happen? Basically, I think the steps that need to happen are:Form resubmits with same name (so that a dupe isn't created)Workflow runs, checks the FileName field against the fields that you used ...