InfoPath Dev

Tada! Like magic. As always, you're the best. Do you know anything about SP email workflows?

ok, here's where I'm stuck; I've got my statement on the clipboard; when I try to create the rule on the checkbox I can't find the appropriate place to insert the text. When I try Action/Set Field Value/Value/Insert Function/Text...the system won't let me paste the text, it forces me to choose a field. What am I doing wrong?

That was my first thought, but I was trying to add the rule to the results field, where the actual text would appear. But, I couldn't figure out a way. I'll try your recommendation.

Nope, not secondary data. Its a blank field, in which users should enter a status such as "No Deficiencies Noted". However, there's no assurance all users will enter the same data, as shown. Consequently, I've created a blank field, that I'd like auto-populated with the desired text when the checkbox is 'True'.

Can I create a rule that - if checkbox is true auto-populated 'Inspection Findings' field with "No Deficiencies Found During Inspection"? 

 Can I create a rule in InfoPath that says - after initiating query of SP list for Date of Last Inspection if the field is/remains blank then auto-populate Date of Inspection field with 'No Report Submitted'?

Now that I've got this working, another issue has come out of that success. When I was doing this calculation through Excel, in the event no report was submitted, I would simply manually enter 'No Report Submitted' in the SP list column of 'Date of Last Inspected' (remembering at the time there were no SP calculations ...

Victory!!! I changed the label of the 'Today' column to 'Current', and I set the Default Value to 'Today'. This allowed me to use the following formula in the calculated field Compliance Status column: =IF(Current-[Date of Last Inspection]<=365,"Compliant","Noncompliant"). It ...

 When I attempt what has been recommended I keep getting the same error message "Calculated columns cannot contain volatile functions like Today and Me." Any recommendations regarding whether this is even possible? If it is, how would you achieve?

Ok, I'll give it a try. To the unresolved calculated field issue, I was sent the following; what do you think? "Assuming your goal is: If Today minus Date of Last Inspection is greater than 364, then the Status equals 'noncompliant', else Status equals 'Compliant... You should be able to use a calculated field. Create ...