How do I replicate rows from expanding table into three separate read only tables based on selection from dropdown | Community
Skip to main content
jeffm70816839
jeffm70816839
September 2, 2021
Solved

How do I replicate rows from expanding table into three separate read only tables based on selection from dropdown

  • September 2, 2021
  • 1 reply
  • 1210 views

How do I replicate/copy rows from expanding table into three separate read only tables based on selection from dropdown in the expanding table. The Items table has several columns for the user to complete about items being purchased, the last column has a dropdown (Disposition) to choose how the item should be accounted for (expendable, durable and non-expendable) I want put the items from each category in a table on it's own page. What is the best way to accomplish this?

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Kosta_Prokopiu1

@jeffm70816839 that can be achieved with scripting...

Basically you create 4 dynamic tables. The first one being the source, the other 3 positioned in separate pages.

The change on the drop down will trigger some script where you select the static table, add an instance and copy the needed columns.

This is not trivial though. What happens when you change an existing one. You need to remove the matching from one table and add it to the other. 

When you delete the main entry, you also will have to find and remove the corresponding entry in the correct table.

This is too complex for me to conjur up a quick example. I simply don't have the time for it.

 

You might consider filling those tables not while the user is still editing the main table but place a script either in a button or as part of the submit or close. It runs through 1 time and builds up all tables with the correct entries.

 

Alternatively, if you must update immediately, you could "destroy" and "rebuild" the other tables. That might not be the best experience for the user though - especially the longer the table gets.

1 reply

jeffm70816839
jeffm70816839Author
October 6, 2021

Is there a way to copy a row in an expanding table based on a choice from a column in the table and paste in a new table on a separate or summary page? I assume there is a way to do this with java. Any help would be greatly appreciated.

    Kosta_Prokopiu1
    Adobe Employee
    Kosta_Prokopiu1Adobe EmployeeAccepted solution
    Adobe Employee
    October 7, 2021

    @jeffm70816839 that can be achieved with scripting...

    Basically you create 4 dynamic tables. The first one being the source, the other 3 positioned in separate pages.

    The change on the drop down will trigger some script where you select the static table, add an instance and copy the needed columns.

    This is not trivial though. What happens when you change an existing one. You need to remove the matching from one table and add it to the other. 

    When you delete the main entry, you also will have to find and remove the corresponding entry in the correct table.

    This is too complex for me to conjur up a quick example. I simply don't have the time for it.

     

    You might consider filling those tables not while the user is still editing the main table but place a script either in a button or as part of the submit or close. It runs through 1 time and builds up all tables with the correct entries.

     

    Alternatively, if you must update immediately, you could "destroy" and "rebuild" the other tables. That might not be the best experience for the user though - especially the longer the table gets.

      jeffm70816839
      jeffm70816839Author
      October 9, 2021

      I was leaning towards having a button on the 3 Summary pages (but again I don't know Java enough to create the script) to run that would populate a filtered copy of the original table after it's completed to avoid the issue of multiple adds or deleting rows.

      Any Java guru's out there that can give me a sample that could do this?

       

        Terms & ConditionsAccessibility statement

        Loading footer...