Column rules and repeat Column based on Sample xml data

[muraliv29958402]

Hello Everyone,

I am new to Adobe tools and we are in process of converting our designs from another Doc Comp tool (HP Exstream) to new version of AEM Forms Designer (6.1). I know Forms designer 6.1 is the upgraded version of LiveCycle ES4 designer so posting it here. I am looking for an option where I need to make a column visible/hidden based sample xml value and I like to repeat the column based on sample xml data. I do not find any options to do this, I am able to do this with rows but not columns.

Just want to know is it even possible with this tool? If NOT, is there any alternative solution to achieve this?

I really appreciate your inputs.

Thanks

Krish

[radzmar]

How does your XML look like and which element of it should represent a repeatable row or column?

[muraliv29958402]

Below is the sample xml and the image how the output should look like. We are not sure how many industries needs to be displayed. It should depend on number of industry tags comes in the input xml and grow the table as per that..

<Primary_Data>

<Industry>

       <Name>Industry1</Name>

       <Value1>1.1</Value1>

       <value2>2.1</value2>

</Industry>

<Industry>

       <Name>Industry2</Name>

       <Value1>1.2</Value1>

       <value2>2.2</value2>

</Industry>

     <Industry>

       <Name>Industry3</Name>

       <Value1>1.3</Value1>

       <value2>2.3</value2>

</Industry>

<Industry>

       <Name>Industry4</Name>

       <Value1>1.4</Value1>

       <value2>2.4</value2>

</Industry>

</Primary_Data>

     

[radzmar]

You can create such table by using floating subforms.

Subform (Table) = floating left to right, not repeatable, bound to Primary_Data

  Subform (Lables) = floating top to bottom, not repeatable, no binding

  Subform (Column) = floating top to bottom, repeatable, bound to Industry[*]

    Textfield (Name) = bound to $.Name

    Textfield (Value1) = bound to $.Value1

    Textfield (Value2) = bound to $.Value2 

The result is the desired table.

[muraliv29958402]

Thank you so much. It worked. Just one more question on this. Is there a way to make the entire column(Industry) hidden if value2 comes as 0 or null in xml?

[muraliv29958402]

Never mind. I am able to write some script to get it worked. Thank you so much.