Will the Spreadsheet to Form Widget allow connection to an external Google Spreadsheet?

  • Profile Image
    BxClinic
    Asked on June 29, 2017 at 05:48 PM

    Is version2 of this widget going to allow connecting to spreadsheets online (like Google Sheers) via URL?



    This is a re-post of a comment on How to Use the Spreadsheet to Form Widget

  • Profile Image
    Jim_R
    Answered on June 29, 2017 at 06:55 PM

    Hey James, honestly, we don't know. It's a fairly new widget so we're not expecting a newer version any time soon.

    But, I can put this up as a feature request if you could provide some specific requirements. Are you only hoping to have an option to connect the widget with a Google Spreadsheet?

    Just reply to this thread with your confirmation or better yet, more details on how you want the widget to behave in the future so we can request it to our Developers.

  • Profile Image
    vaibhavTambade
    Answered on June 30, 2017 at 03:43 AM

    I am facing the same problem and, I think having this feature would solve a huge huge problem. It would just increase the scope of Jotforms. kindly let me know if this can happen?

     

  • Profile Image
    BxClinic
    Answered on June 30, 2017 at 04:26 AM

    Hi Jim,

    A Google spreadsheet would be one way. I'm a Zoho customer rather than a GSuite one, so to be honest, I'd be very happy with a "Jotform Data Module" where we could create spreadsheets (tables) that could be referenced by all our forms.

    So, for example, we could create an employees table, which records name, date of birth, address, email etc etc, and then whenever we create a form, the lookups related to staff could read the staff table. Similarly, a customer address table could add customers' shipping addresses to automatically generated emails when they complete a form.

    Tables would be a like engaging Warp Drive for Jotform!

    Have a great day :-)

     

     

  • Profile Image
    Charlie
    Answered on June 30, 2017 at 06:29 AM

    Unfortunately, the functionality you presented is quite far from the original concern you have with the enhancement on the Spreadsheet to Form widget

    The one you presented in detail involves more of the whole form builder itself, or perhaps an app integration rather than a single widget. If this involves the whole form builder itself, then this will be a major redesign on how data is handled. To be honest, forwarding this as a feature request will most likely have a lower priority and may not be feasible. The following issues will arise:

    1. The table you mentioned would be created where? Is it on the form builder or on a separate application instead?

    2. Referencing a lookup table on a newly created form is not possible without integrating it first. 

    3. I'm also note sure if I understand this one:

    "a customer address table could add customers' shipping addresses to automatically generated emails when they complete a form."

    It seems like this is a mixed of saving data on a table and using the same table as a lookup? 

    4. Based from #3, is the data module applied during the form is being edited or during the form submission? This seems to be a mixed based on my understanding.

     

    From your requirements, I presume you wanted the form fields to have the ability to lookup a central table or a database where they can pull data? This can be achieved but in a more complex way of using the form's full source code and creating a script to connect a database and pull data. This will involve a developer and your own server.

    So far, we have widgets that allows dynamically adding new entries on a field, below are some of them:

    https://widgets.jotform.com/widget/user_contributed_checkbox 

    https://widgets.jotform.com/widget/user_contributed_dropdown 

     

    On the other hand, the Spreadsheet to Form widget is a good start for a lookup table, but the spreadsheet cannot be updated real time, you need to re-upload the spreadsheet. I believe the first suggestion you have which is linking a Google Spreadsheet link to the said widget is more feasible and can be forwarded as a feature request, although I cannot guarantee that it will be implemented. 

    We appreciate your feedback and suggestion on this. Let us know what you think.

  • Profile Image
    Charlie
    Answered on June 30, 2017 at 06:30 AM

    @vaibhavTambade 

    To better assist you, I have opened a separate thread for your concern. Please refer to this link instead: https://www.jotform.com/answers/1188268. We will address it shortly.

    Thank you.