Hiding columns in a repeating table within a repeating section - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Hiding columns in a repeating table within a repeating section

Last post 02-05-2010 10:22 AM by jecowley. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 02-05-2010 07:57 AM

    Hiding columns in a repeating table within a repeating section

    I have a form with repeating tables within repeating sections.  I've created a column with a read only field to hold a selection "static" to enable castcading dropdown listboxes in the repeating table.  WIthin my repeating section it looks something like this:

    Drop Down selection <Issue>

    Reapating Table:

    C1 - Static reference to issue selected above: <Issue>  C2 - dropdown selection cascading from <issue> in C1:  <Root Cause> C3 - Freeform comments text box.

    My question:  Does anyone know of a way to always hide C1?  As far as I know, C1 must remain in the same repeating table as C2 in order to use the "current()" function for the cascading filter.  So I an't put it in a separate table to hide the entire table.

    Thanks.

  • 02-05-2010 08:08 AM In reply to

    Re: Hiding columns in a repeating table within a repeating section

    The field needs to remain in the group in your data source, but you don't have to have a control bound to the field in your form. You can delete the column from the repeating table on the form entirely -- the data field will still exist in your data source.

    Hilary Stoupa

  • 02-05-2010 08:27 AM In reply to

    Re: Hiding columns in a repeating table within a repeating section

    Thanks Hilary.  I do have a control in C1 - it's a text field with that references the user's selection in the control above.  Since I need to cascade the list in C2 based on user selected data (in the control above the table) vs. my data source, I don't think that I can delete the column.  The issue is the cascading lists within a repeating section.  I was using a modified version of Greg Collin's solution: http://www.infopathdev.com/blogs/greg/archive/2005/07/14/Create-a-Repeating-Cascading-List-from-a-Flat-Data-Source.aspx.  And I haven't figured out a way to cacade my list in C2 without a static reference within the table to use the current() function Greg suggests.

    I have "shrunk" the C1 to the minimum 4 px, but is still is a messy view for my users that I'm trying to clean up by hiding it.

  • 02-05-2010 08:38 AM In reply to

    Re: Hiding columns in a repeating table within a repeating section

    Controls are bound to data fields. Deleting controls does not delete a data field. You would still have your data field with its value. Why not use 'Save As' and save a copy of your form, then try deleting the column from the table on your form and seeing if it still all works?

    Hilary Stoupa

  • 02-05-2010 10:22 AM In reply to

    Re: Hiding columns in a repeating table within a repeating section

    AHHHHHHHHHHH...I understand what you're saying now.  Sorry I didn't get it the first time!  That works perfectly, THANKS!
Page 1 of 1 (5 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.