Expandable tables with user entered values that change to a Protected state after adding an instance of a subset of pages | Community
Skip to main content
nowackem
nowackem
New Participant
May 12, 2021
Question

Expandable tables with user entered values that change to a Protected state after adding an instance of a subset of pages

  • May 12, 2021
  • 13 replies
  • 2360 views

Using a subset of two pages, I have programmed a 2-page dynamic form to "Add an Instance" of said two pages by clicking a button. Basically the 2+(dynamic) pages can repeat in proper order infinitely. On page 1, I have a table with repeating rows which works fine. The issue is that I need this table to show the user input values in the repeating rows when another subset is added BUT (here is the kicker) make it cumulative. So if the user added 2 instances of the row and put values in these 2 repeating rows on the #1 subset of pages, I need these to change their state to protected and keep the values on the #2 subset but have the table still be expandable below those values. If the user adds 2 more values on #2 subset then all 4 rows with user input values show up protected on the #3 subset of pages and so on. Because of the cumulative nature of this particular form, all user added values need to stay in proper order. This was hard to explain so please let me know if I need to try again. My file is at the link below. 

https://drive.google.com/drive/folders/1Hom9xW6S4QT7Pee6RuTb1NW6zGb5RNJv?usp=sharing

 

Does anyone know if this is possible or maybe willing to check it out? This might be beyond the limitations of Designer but I wanted to run it through you guys first.  

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

    13 replies

    Show previous replies
    Kosta_Prokopiu1
    Kosta_Prokopiu1
    Employee
    May 14, 2021
    ok, I think I may have got it. Example, I have 1st Affidavit, I enter 20$ page total, accumulated total shows also 20 $. Now I add another Affidavit and enter 30$ in the same line, page total shows 30$ but Accumulated shows 20$ on page 1 and 50$ on page 2. If I make an amendment on page 1 the 20$ accumulated jumps to 50+$ depending on the change. This you do not want? Correct?
    nowackem
    nowackemAuthor
    New Participant
    May 14, 2021
    Hi @kosta_prokopiu1, My aplogies. This is a hard one to explain. #2 and #3 subset are what I was calling it when you click the "Add Add'l Pages" button at the bottom of page 2 where it will add an instance of subsetAffidavit. Doing it this way will allow Page1 and Page2 to be repeated infinitely (in proper order) as the user continues to click the button. Page1 > Part II is the table I'm struggling with. The user needs the ability to add rows according to their requirements, but once the user adds info into the WkCat field (1st row), I this particular object to change to protect when the user adds another subsetAffidavit. Reason being is that the last column in this table is cumulative amounts and it will mess up the numbers if they change the rows as they add subsetAffidavit instances. Each set of pages equals a job for a contractor, each job may have different WkCat amounts. If a job doesnt need a specific WkCat the user entered for a previous job it needs to stay there with its cumulative total throughout the form. Please let me know if I need to try again with my explanation.
    Kosta_Prokopiu1
    Kosta_Prokopiu1
    Employee
    May 14, 2021

    Hi @nowackem, 🙂 I am still trying to grasp what the exact behavior is. #2 and #3 subset does not help me much.

    Sorry, the comment escaped prematurely.

    Are we looking at Part III table only with subcontractor groups or is the first table also included?

    Terms & ConditionsAccessibility statement

    Loading footer...