General

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

jecowley — Fri, 05 Feb 2010 18:22:02 GMT

AHHHHHHHHHHH...I understand what you're saying now. Sorry I didn't get it the first time! That works perfectly, THANKS!

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

Hilary Stoupa — Fri, 05 Feb 2010 16:38:13 GMT

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?

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

jecowley — Fri, 05 Feb 2010 16:27:17 GMT

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.

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

Hilary Stoupa — Fri, 05 Feb 2010 16:08:29 GMT

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.

Hiding columns in a repeating table within a repeating section

jecowley — Fri, 05 Feb 2010 15:57:36 GMT

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.