InfoPath Dev

 Create another textbox for each checkmark field call it CheckCalc1, checkCalc2 etc etc. Use a rule  on every checkbox that if the checkbox is checked change a fields value for the new checkbox to 1. You know how many total number of checkbox fields you have I will assume 20 fields. Have another textbox field, call it ...

 May have to be a code solution, I believe the multi selection list box output is always the last item clicked so you have no logic to use to filter future results.

 Have a field where the user types in the email address. On the email submit data connection for the TO use the function button and select the email field you created in the first step.  

 Did you promote the fields you want submitted to the library? Go to the home tab with the form in design, click form options then click property promotion then check each field you want displayed in the sharepoint library.

 I would take the result of the chosen day and use the adddays function to it to add 4 days, call it DateCheck. Then on submit have a rule that checks if DateCheck is less then or equal to Today, send the user to another view explaining why they can't do that. Check the box in the rule to not run any remaining rules if that rule is true, ...

Any field with a red asterisk is supposed to signal the user that that field is mandatory, you probably knew this but just making sure, user education may be the quickest way to solve this. Assuming you already know this here is what I would do. Hilary, the all wise and powerful, will probably have a better way but this is my stab at it. For ...

I want any one condition being true to deny access, not all three at once. Thanks for your assistance Hilary, but I have waved the white flag and gone a different way now.

Is there only a single column and row in the SPR_Ref list? If there are many you would need some way to trigger a filter off the current form to select the data you want.

So by mandatory do you mean cannot be blank? And if there is a blank have any attempt to submit fail and something advise the user which field they left blank? Does that sum the problem up?

Set up the secondary connection, make sure the Title and Area fields are checked so the form can see the information. Find the field you want this data to be triggered off of, create a rule, set a fields value. Select the field to change. Now in the value field click the Fx button. Insert field or group. Using the drop down select the ...