-
alfredmylneAsked on March 3, 2021 at 7:48 AM
Dear Sir
I am trying to create a complex form which uses various parameters and involves several complex calculations. it would be immensly helpful if the Spreadsheet to form widget would do the following
- Allow drop down selection based on the list in the spreadsheet
- populate number fields (seems barmy that it can handle every other type of field!)
Can you advise if this is possible
Thanks
David
-
Mike_G JotForm SupportReplied on March 3, 2021 at 8:26 AM
We would like to apologize for any inconvenience.
- Allow drop-down selection based on the list in the spreadsheet
We would like to apologize for any inconvenience. We can submit this as a feature request to our developers. However, a workaround that may work to meet your requirements is to pass the data from a drop-down field on your form into the Spreadsheet to Form widget field. You can set the options in the drop-down field to match the Access Codes in the Spreadsheet uploaded in the Spreadsheet to Form widget.
- populate number fields (seems barmy that it can handle every other type of field!)
We can also forward this as another feature request to our developers but, as a workaround, you can pass the data from a Short Text field that gets its value from the Spreadsheet to Form widget into a Number field on your form using conditions.
Reference Guide: How-to-Insert-Text-or-Mathematical-Calculation-into-a-field-using-a-Condition
Feel free to let us know if you need any further assistance.
-
alfredmylneReplied on March 10, 2021 at 1:09 PM
-
Mike_G JotForm SupportReplied on March 10, 2021 at 7:11 PM
As you have requested, I have forwarded your concern to allow drop-down selection based on the contents of the spreadsheet uploaded in the Spreadsheet to Form widget to our developers. Although we guarantee that it will be implemented anytime soon, please be assured that once the feature becomes available, we will notify you right away on this ticket.
As for the ability to populate a Number field on the form with data from the Spreadsheet to Form widget, I have moved it to a new ticket considering it is about a new topic.
Here's the link to the new ticket: https://www.jotform.com/answers/2958221
We will be responding to that ticket shortly. If you have any follow-up questions about that topic, please refer to that ticket to avoid confusion.
-
alfredmylneReplied on March 11, 2021 at 2:55 AMThat’s great service - thanks!
David Gray
...