Highlighted

Column rules and repeat Column based on Sample xml data

muraliv29958402

01-11-2017

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

Replies

Highlighted
Highlighted

muraliv29958402

01-11-2017

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>

      Industry Table.png

Highlighted

radzmar

MVP

02-11-2017

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 

1339661_pastedImage_0.png

The result is the desired table.

1339662_pastedImage_4.png

Highlighted

muraliv29958402

02-11-2017

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?