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

  • Profile Image
    deanwitherden
    Asked on November 11, 2021 at 03: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...

  • Profile Image
    gerardw
    Answered on November 11, 2021 at 03: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.

  • Profile Image
    deanwitherden
    Answered on November 11, 2021 at 04: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!

  • Profile Image
    Michal_S
    Answered on November 11, 2021 at 05: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!

  • Profile Image
    Zbulo
    Answered on November 16, 2021 at 03: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!


  • Profile Image
    Michal_S
    Answered on November 16, 2021 at 05: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!

  • Profile Image
    appnovo
    Answered on November 16, 2021 at 06:46 PM

    It's very important. The spreadsheet widget need to have connection through url link
  • Profile Image
    gerardw
    Answered 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