Spreadsheet to Form widget: Allow selection of access code from a drop-down field

  • alfredmylne
    Asked 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

    1. Allow drop down selection based on the list in the spreadsheet
    2. 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 Support
    Replied 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.

  • alfredmylne
    Replied on March 10, 2021 at 1:09 PM

    Please submit these items as feature requests.

    Spreadsheet to form widget

    Drop down selection from based on the contents of the spreadsheet

    Ability to populate a number field.

    Please advise how long such a request can take to be actioned.

    Thanks

    David Gray

  • Mike_G JotForm Support
    Replied 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. 

  • alfredmylne
    Replied on March 11, 2021 at 2:55 AM
    That’s great service - thanks!
    David Gray
    ...