- ckostersAsked on January 23, 2018 at 11:08 AM
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:
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.
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.
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.Page URL:
- JotForm SupportBDAVIDAnswered 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.
- ckostersAnswered 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:
- JotForm SupportBDAVIDAnswered 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.