Spreadsheet to form widget related questions.

  • Ryan
    Asked on December 14, 2023 at 8:57 PM

    Two questions --

    1) Can a single spreadsheet by used by multiple forms that need the same lookup fields?

    2) is there an API to update/replace the spreadsheet, instead of manually uploading a new spreadsheet?

    Thanks!

  • Rene JotForm Support
    Replied on December 14, 2023 at 11:39 PM

    Hi Ryan,

    Thanks for reaching out to Jotform Support. Yes, you can use a single spreadsheet for your forms. Unfortunately, there is currently no possible way to dynamically update the sheet added to the Spreadsheet to form widget field even using API. This process has to be done manually.

    Let us know if you have any other questions.