Bug between Spreadsheet to Form widget and Condition

  • Profile Image
    Zbulo
    Asked on November 18, 2021 at 05:47 AM

    Hello Jotform team,

    I'm experiencing a conflict between the "Spreadsheet to Form"-widget (on page 1) and an "Update/Calculate field"-condition (filter for End).

    Even though the condition has IF states that stop it from running, the field "End" into the condition would write, if triggered, is still being erased/overwritten with blank.

    1637232007_61962d876cb49_

    In my scenario, I'm selecting at 14. Radio field (id31) the value "Group departure", which triggers the "Spreadsheet to Form"-widget to populate several fields. Having selected another value than "Private departure" should stop the condition.

    On the live form the widget populates all values, but the End field is being erased / overwritten in the blink of a second.

    When I disable the condition this is not the case, thus the condition clearly seems the culprit here. This may be a bug? Please advise. Thanks!

  • Profile Image
    Jovanne_A
    Answered on November 18, 2021 at 07:48 AM

    Hi, thank you for contacting support.

    Please allow me some time to conduct some tests. I will get back to you as soon as I have more information.

    Thank you.

  • Profile Image
    Zbulo
    Answered on November 26, 2021 at 04:22 AM
    Just got a "Support ticket answered" notification, but haven't received a
    reply yet.

    ...
  • Profile Image
    Richie_P
    Answered on November 26, 2021 at 04:58 AM

    My colleague is checking on your conditions and will get back to your once he has further information.

    Thank you.