How do I make multiple forms (duplicated) stand on their own to populate the same sheet?

I duplicated a form three times, how can I make them stand on their own to populate the same form? Now when I make a change on one it duplicates that change to all three forms.

Tags:

Best Answer

  • jmyzk_cloudsmart_jp
    jmyzk_cloudsmart_jp Community Champion
    Answer βœ“

    Hi @Trisha Baumhover

    I was able to reproduce your problem.

    I made a copy of the form that contained logic, and when I changed the logic on the original form, the same logic on the copied form also changed to that content.

    When I reverted the original form to how it was before the change, the change remained in the duplicate forms.Β I could remove the changes manually.

    I could not go through all of the patterns of changes in each form, including original and duplicates, and test whether the changes affect each other, but the following is certain.

    "Changes to the logic on the part of the duplicate form do not affect the logic of the original form or any other copied form."

    Based on that, I created a form assuming that I had a choice of new or existing and that if existing, I would change the discount rate depending on the contractor, and if new, I would change the discount rate depending on the size (SML).

    Adding the new logic on the duplicate form, as described above, without changing the first original form, did not cause any problems.

    I suggest creating many duplicate forms and making the changes in the duplicate forms without making any changes to the original form.

    Please take a look at the published example in the following URL.

    Β Please take a look at the form image in Sheet Summary, as well.


Answers