Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Display multiple tables based on values from xml

mankuu33664440
Level 2
Level 2

Hi, I'm new to livecycle designer. 

We have a requirement of displaying multiple tables from the xml values. 

 

<member_table num=1>

     <name>

    <skills>

        <SKILL1>

        <SKILL2>

        <SKILL3>

   </skills>

</member_table>

<member_table num=2>

     <name>

     <skills>

        <SKILL1>

        <SKILL2>

   </skills>

</member_table>

 

For each member number,

1. I should display member table which has one row with name

2. I should display skill table with all skills listed (this differs from member to member) 

 

 

Approach :

Built member table and skill table in a subform, and used action builder to repeat the subform for every member. I am able to get member table correctly as it has only one row. But skill table is getting with only one row, and first value is getting filled.

 

Please help on how to retrieve all the skills into all the skills tables based on member number. 

1 Accepted Solution
Kosta_Prokopiu1
Correct answer by
Employee
Employee

OK, here we go: https://documentcloud.adobe.com/link/track?uri=urn:aaid:scds:US:0b9769f5-5a7c-489f-99fa-9de489d4a89b

The structure of the data is vital for success here. See if you can adapt your data accordingly. Check also the Binding tab under Object.

I hope that helps - it is only a quick sample - you may have to adapt to your data and real form....

Kosta_Prokopiu1_0-1608139984306.png

 

 

View solution in original post

10 Replies
mankuu33664440
Level 2
Level 2

If my xml has 10 members data, then I should be displaying all 10 members member tables and 10 skill tables.

 

Please give me some idea on how to further implement this

 

@

Kosta_Prokopiu1
Employee
Employee

There is a reason for that 🙂

You have created a hierarchical data structure and want to consume the data in more than one dynamic subform/table construct. That does not work because the data is gone through once (your member table) and then there is no "Reset" so your skills table are out of data. For that to work you could restructure your XML data like so:

 

<root>
    <member_table>
        <member>
            <number>1</number>
            <name>Name 1</name>
        </member>
        <member>
            <number>2</number>
            <name>Name 2</name>
        </member>
    </member_table>

    <skills_tables>
        <skill_table>
            <number>1</number>
            <name>if required in the skill table</name>
            <skills>
                <skill1>Skill 1</skill1>
                <skill2>Skill 2</skill2>
                <skill3>Skill 3</skill3>
            </skills>
        </skill_table>
        <skill_table>
            <number>2</number>
            <name>if required in the skill table</name>
            <skills>
                <skill1>Skill 1</skill1>
                <skill2>Skill 2</skill2>
            </skills>
        </skill_table>
    </skills_tables>
</root>

 

Kosta_Prokopiu1
Employee
Employee
I just realizeed - loose the numbers in the skill tags. <skill> instead of <skill1> etc - then you are truely dynamic
mankuu33664440
Level 2
Level 2
But this way of displaying all member tables at once and skill tables at once is not helpful in the form. Member table along with the skill table should be displayed together
Kosta_Prokopiu1
Employee
Employee
What do you mean with displayed together? In your description it sounded as if you have a simple table with the members, one row for each member and that is followed on the document by a number of individual skill tables. Reorganizing your data will make the skill tables be filled, otherwise you get what you have now. They are still in the same document? Maybe you can explain a bit more what that should look like.
mankuu33664440
Level 2
Level 2
hI , Added the image of the required form structure. We have such 30 sections of member along with skill table to be displayed on form
mankuu33664440
Level 2
Level 2
great, thank u in advance. I am waiting for your help on this desperately.
Kosta_Prokopiu1
Correct answer by
Employee
Employee

OK, here we go: https://documentcloud.adobe.com/link/track?uri=urn:aaid:scds:US:0b9769f5-5a7c-489f-99fa-9de489d4a89b

The structure of the data is vital for success here. See if you can adapt your data accordingly. Check also the Binding tab under Object.

I hope that helps - it is only a quick sample - you may have to adapt to your data and real form....

Kosta_Prokopiu1_0-1608139984306.png

 

 

View solution in original post