Can one field in a row of a repeating table be suppressed to only appear once in the repeating table? - InfoPath Dev
in

InfoPath Dev

Can one field in a row of a repeating table be suppressed to only appear once in the repeating table?

Last post 05-16-2013 11:36 AM by ErnestoM. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 05-16-2013 10:46 AM

    • Doreen
    • Top 50 Contributor
      Female
    • Joined on 08-11-2010
    • Federal Way, WA
    • Posts 291

    Can one field in a row of a repeating table be suppressed to only appear once in the repeating table?

    I'm using DBXL to submit repeating rows to a SQL table in database but I have one field in each row that needs only displayed once; a comment field to summarize the entire section or repeating table.  Is there a way to suppress this filed in all rows except one, the last one,  so that it appears this field appears only once in the section? 

    Currently I have this field in a table below the repeating table of the form so it appears to be a part of the repeating table group.  This layout, on submit,  causes the insert into database to be wrong in that that fields' value appears for all rows in the table, whereas I'd rather the fields value for a section only appear in a column for the corresponding section it applies to.  Does that make sense?

    Can this be controlled with condition in rules like: Say the sections total row count is 14. then:


    Hide field1 in positions #1 through #13  of rows in section 1  if total row count  in section = 14?

     If something like this might work, how do I refer to a specific row (position) and field?

     Does qRules offer a solution for this?

  • 05-16-2013 11:36 AM In reply to

    Re: Can one field in a row of a repeating table be suppressed to only appear once in the repeating table?

    I don't think this is really a DBXL or qRules issue - just form design, though I'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?

    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'm very confused by this.

    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™


Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.