Spreadsheet to form: Condition to insert value in field is not triggered.

  • CoastEnvironmental
    Asked on June 19, 2019 at 6:06 PM

    On our form:

    https://form.jotform.com/91677033925261

    I have installed spreadsheets to form widget to autofill it (type 163)

    But I also have a condition on the form to change the location address if location = a certain value.

    It doesn't seem to trigger and the only way I found to make it happen is selecting the field and filling it again. Is there another way to trigger the condition, perhaps with a button or mouseover?



  • Ashwin JotForm Support
    Replied on June 20, 2019 at 2:24 AM

    I am not sure if I have understood your question correctly. Do you mean to say that when the value is populated in form fields from "Spreadsheet to form" widget, the condition to insert value in another field is not triggered?

    I did test your form and I am not able to replicate the issue. The location address is populated automatically. Please check the screenshot below:

    1561011836insertCondition Screenshot 10

    I would suggest you to please test your form again and get back to us if the issue persists.

    We will wait for your response.

  • CoastEnvironmental
    Replied on June 21, 2019 at 1:49 PM

    Yeah it wasn't working initially, but not sure what happened. I managed to get it working fine so all resolved. 


    Thanks