https://www.infopathdev.com:443/forums/142.aspxAre you exploring new features coming up in 2010? Share information and ask questions here!enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/79322.aspxThu, 07 Jun 2012 11:39:40 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:79322joeyjackson0https://www.infopathdev.com:443/forums/thread/79322.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=142&PostID=79322<p>&nbsp;</p>https://www.infopathdev.com:443/forums/thread/79321.aspxThu, 07 Jun 2012 11:38:58 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:79321joeyjackson0https://www.infopathdev.com:443/forums/thread/79321.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=142&PostID=79321<p>I&#39;m not sure how to best describe this, so here is some background. </p> <p>I have a form published to our sharepoint server, which is an evaluation form for call center agents. There are multiple criteria, which all have the same three options (Objective Met, Not Met, and Not Applicable). based on the option selected a value is assigned (via rules) to two text boxes, bound to fields; possible score and total score, as well as a comments text box. </p> <p>For each evaluation criteria I have a table with those options and a group with those fields in them. This logic all works just fine. </p> <p>In order to be able to adjust the value of each criteria or the content, instead of being coded right into the form, the sections where the evaluation criteria name and details are &#39;Calculated Values&#39; controls and pull the information from a sharepoint list. To accomplish this I have a group containing my 4 fields for each criteria, and a table for each criteria (so each is laid out identically), it pulls the name and criteria value from the sharepoint list when the form loads. This all works just fine. </p> <p>Here&#39;s where it gets a bit complicated: I wanted to make it so management can add criteria to the list, simply by adding items to the sharepoint list. To do this, I set up each table (criteria) in it&#39;s own &#39;section&#39;, for which I use a formatting rule to hide that section if there is not an item with that ID# in the sharepoint list. There are now 20 groups with 4 fields each and 20 sections that hide if there is no information in the list for them. This also works great, except when I apply the &#39;field cannot be blank option&#39; to the selections, so the user&nbsp;don&#39;t miss an answer, it expects the hidden sections to be answered as well. </p> <p>So here&#39;s where I&#39;m stuck. If I hide the field, it still wants an answer. I discovered if I select &#39;do not include this section in the form by default&#39;, then it works the way I want. but that&#39;s not ideal because it requires modification to the form to change the criteria. What I&#39;m looking for is a way to programatically include or exclude a section (not just hide it), based on whether a row exists in a list. I&#39;ve only been able to hide it. I tired just adding a default value to the fields and then applying a rule that if it&#39;s not above that number to show a message, but it doesn&#39;t seem to prevent submission, or the rule is not running - I can&#39;t get that option to work. </p> <p>Sorry it&#39;s so lengthy, I just wanted to be a clear as I could. </p> <p>Thanks in advance.</p>