Re: Report Listing Records With Invalid Field Selections

Rachel,

You say that some of your fields are multiple-choice fields and some are multi select. 

For the multiple-choice fields probably the easiest solution is just to have a brute force formula for each multiple-choice field to validate the field

For example

not Contains("apples;peaches;pears;plums", [Multiple choice field 1")

That formula above would flag to be tracked if the response to the multiple-choice field was invalid.


You also say that you have multi select fields. Those are a little more complicated because you would have to post them out into their individual pieces before validating the entries. I can help you with the formulas for that if you want to work through that on this form. 

But I don't think there's a magic shortcut here. The only other alternative would be to build tables which have the valid choices for the various fields and make relationships but I think in the end that's more work than just writing formulas.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------