Spreadsheet to form widget: ability to link to Google sheet or Onedrive

  • allroadsit
    Asked on November 11, 2021 at 3:48 AM

    Was just looking for a field that would create a drop down from a linked list. My application is project ID's, to implement this currently i'll have to edit the form every time we start a new project or finish a project. If i could link it to a spreadsheet in OneDrive or similar it wouls save time in having to make the edits and remembering to do them in the first place!

    +1 for this feature...

  • Girish JotForm Support
    Replied on November 11, 2021 at 3:50 AM

    Let me escalate your requirement to our back end team as a feature request.

    We will not be able to provide an ETA or timeframe but when this feature would get implemented we will inform you via this ticket.

  • allroadsit
    Replied on November 11, 2021 at 4:35 AM

    Thanks Gerard,

    The possibilities would be endless if we could draw data from a spreadsheet as well as populate a spreadsheet with answers from forms! Or keep going and and open up your db, let us draw from any table and make it a full db app!

  • Michal_S Jotform Support
    Replied on November 11, 2021 at 5:53 AM

    Hello!

    Yes, I agree - the possibility to use dynamic data sources for the Spreadsheet to Form widget has already been requested a few times and I also think it would be very useful.

    My colleague has forwarded your request to the developer team, but as he stated, we cannot provide an ETA on the feature.

    Thank you for the suggestion!

  • Zbulo
    Replied on November 16, 2021 at 3:35 AM

    Not meaning to hijack the request, but the option to look up live data from an online source on the form would be a real game changer. Currently the lack of this ability or rather limitation to a static, uploaded file are the only reasons for me to divert away from Jotform to other tools for certain applications.

    I'm very impressed with the features and speed the Jotform team churns out releases, a public roadmap with voting feature may help both your team and us as user to a better overview. Thanks!


  • Michal_S Jotform Support
    Replied on November 16, 2021 at 5:01 AM

    Hello!

    I will be splitting your inquiry into a separate thread and will address it there:

    https://www.jotform.com/answers/3514356

    Thank you!

  • appnovo
    Replied on November 16, 2021 at 6:46 PM

    It's very important. The spreadsheet widget need to have connection through url link
  • Girish JotForm Support
    Replied on November 16, 2021 at 10:45 PM

    Hello @appnovo,

    I have moved your request to a new ticket: https://www.jotform.com/answers/3517114