-
Add a calculated value control to the view. Enter the sentence as text in the calculated value. Put a condition on the calculated value to hide it unless your field is equal to J.
-
Hi, Mark - just add a calculated value (or expression box in older versions of InfoPath) using the sum function. More here: http://blogs.msdn.com/b/infopath/archive/2006/12/04/xpath-powers-calculating-totals.aspx
-
We can't use rules to copy repeating data out of the box in InfoPath. If you just need to display the data, drag the field from the secondary data source onto the form then use conditional formatting to hide the rows where things don't match. If you need to copy the data into the main data source, you'll need to use code (or ...
-
Can I just see your form? You can attach it under the options tab or email it to me - I think you have my email address?
-
One to many should be okay for submit - check the bottom of this page for the requirements for submitting to a DB, while it was written for Access, I think the same applies to SQL.
-
The ones that have not been checked should show based on your multi select being set to use the same list of options as your SharePoint list. What is your multi select using for options? Another SharePoint list? Are they hard coded?
-
I apologize, I still don't understand what you are asking.
The technique I showed in the sample could be used to copy your "Value" nodes from your secondary data source into the repeating field in your main data source.
What is your multi-select using for its options? I'm assuming it has the ...
-
Sorry, I get it now - but you'll only have in "values" from SharePoint the ones that have been selected, right?
-
Sorry, I don't understand. What does "need all of the selections visible" mean? What provides the data source for your multiselect?
-
You can just use insert and a rule on the repeating main data source row to set the value. See attached sample. I don't know if you are using a browser forms or not, but you may need to test this in the browser to verify there aren't any problems there. The insert rule is on the QdabraRules finishedLoading node. :)
Oh - and the ...