Spreadsheet to Form Widget: condition to pupulate fields does not work if this widget is used.

  • Profile Image
    ckosters
    Asked on January 23, 2018 at 11:08 AM

    Hello, 

    I am having difficulties when I import data using the Spreadsheet to Form Widgit. 

    In one of my questions, I have a calculation that if "Pool on Premise" is answered "Yes" then in the field "Pool on Premise Comment" a test string will appear that says "Pool On Premise - 5 points" 

    This works fine normally as so: 1516723437Pool On Premise Yes.PNG

    But if I use the Spreadsheet to Form Widgit, and import data, which has NOTHING to do with the pool on premise question, this quesiton is just in addition to the data I imported.

    1516723520Pool On Premise - Filled.PNG

    Then I select "Yes" for the "Pool on Premise" Question and the calculation doesn't work to complete the text string for the "Pool On Premise Comment" field.  

    1516723636Filled Pool On Premise Yes.PNG

    The data that was imported shouldn't have any weight on other questions in the form. I am trying to just have certain data imported and then ask other questions surrounding that data. 

    Thanks in advance for your help. 

  • Profile Image
    BDAVID
    Answered on January 23, 2018 at 12:44 PM

    Please make sure to remove the label from the Excel file column header, of the field that will be populated through conditions. So, it will not be affected when the code is entered in the spreadsheet to widget. Otherwise, it will take the value that comes from the spreadsheet.

  • Profile Image
    ckosters
    Answered on January 23, 2018 at 01:13 PM

    I do not have the Pool on Premise as a field in the spreadsheet. 

    This is the spreadsheet I am importing from:

    1516731162Excel Jotform.PNG

  • Profile Image
    BDAVID
    Answered on January 23, 2018 at 01:25 PM

    I have been able to reproduce the issue in one of my forms, where the spreadsheet does not contain the fields that get populated through conditions.

    I have forwarded this issue to our developers, you will be notified via this thread when the issue gets fixed.