Bug between Spreadsheet to Form widget and Condition

  • Zbulo
    Asked on November 18, 2021 at 5: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  Screenshot 10

    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!

  • Jovanne JotForm Support
    Replied on November 18, 2021 at 7: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.

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

    ...
  • Richie JotForm Support
    Replied on November 26, 2021 at 4:58 AM

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

    Thank you.