Can I upload a dynamic file in the Spreadsheet to form widget

  • Roster
    Asked on March 21, 2023 at 11:03 PM

    What if we would like to data to be pulled live from a Google Sheet, instead of uploading static data that cannot change?
    Is there a way to integrate with Google sheets to pull data live?

  • Mary_Ed JotForm Support
    Replied on March 22, 2023 at 3:22 AM

    Hello Roster,

    Thanks for reaching out to Jotform Support. Unfortunately, the feature you’re looking for isn’t currently available. Your form submissions can only be integrated into Google Sheets. But, this cannot be done by linking the Google Sheets to the Spreadsheet to Form Widget.

    I've gone ahead and escalated your request to our Developer Team. When or if it's developed depends on their workload, how viable it is, and how many other users request it. If there are any updates, we’ll circle back to this thread and let you know. 

    Thanks for your patience and understanding, we appreciate it.

  • carolyn.parker
    Replied on March 31, 2023 at 8:29 PM

    I am interested in this feature as I want to display a staff roster with recurring shifts. The calendar embed is ok but doesn't display as well as the table in jotform's calendar view.

    Is there an option to create recurring shifts from a form that I have overlooked?
  • Leonidas JotForm Support
    Replied on April 1, 2023 at 4:57 AM

    Hello Carolyn,

    Thanks for getting back to us. To avoid confusion with the thread, I moved your other question to a new thread and helped you with that here.

    Let us know if you have any other questions.