https://www.infopathdev.com:443/forums/131.aspxqRules adds support to your InfoPath forms. With qRules, you can add features to your form that require code, but without having to write it. enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/89855.aspxThu, 16 May 2013 18:36:42 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:89855ErnestoM0https://www.infopathdev.com:443/forums/thread/89855.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=131&PostID=89855<p>I don&#39;t think this is really a DBXL or qRules issue - just form design, though I&#39;m confused by the data structure. If the field only needs to appear (and be filled out) once, then why is it a part of the repeating section?</p><p>If you have 14 rows, hide the first 13 [using something like position() or preceding-sibling], then the first 13 instances of that field are blank and the 14th instance will be filled out by the user? Sorry, I&#39;m very confused by this.</p>https://www.infopathdev.com:443/forums/thread/89849.aspxThu, 16 May 2013 17:46:19 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:89849Doreen0https://www.infopathdev.com:443/forums/thread/89849.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=131&PostID=89849<p>I&#39;m using DBXL to submit repeating rows to a SQL table in database but I have one field in&nbsp;each row that needs only displayed once;&nbsp;a comment field to summarize the entire section or repeating table.&nbsp; Is there a way to suppress this filed in all rows except one, the last one,&nbsp; so that it appears this field appears only once in the section?&nbsp; </p><p>Currently I have this field in a table below the repeating table of the form&nbsp;so it appears to be a part of the repeating table group.&nbsp; This layout, on submit, &nbsp;causes the insert into database to be wrong in that that fields&#39; value appears for all rows in the table, whereas I&#39;d rather the fields value for a section only appear in a column for the corresponding&nbsp;section it applies to.&nbsp; Does that make sense?</p><p>Can this be controlled with condition in rules like: Say the sections total row count is 14. then:</p><p><br />Hide field1 in positions #1 through #13&nbsp; of rows in section 1&nbsp; if total row count&nbsp; in section = 14?</p><p>&nbsp;If something like this might work, how do I refer to a specific row (position) and field?</p><p>&nbsp;Does qRules offer a solution for this?</p>