Spreadsheet to Form widget: Ability to select an excel file that is already used on another form

  • AgilityAssoc.Canada
    Asked on February 5, 2021 at 4:11 PM

    I just wanted to add a note. This may be a totally different issue.

    I use the Spreadsheet to Form widget on a number of our forms, these are XL spread sheets.

    I also use G-Sheet integration to collect some data. 'It would be so very, very helpful if I could use a forms integration to update a G-sheets fields that is used by the widget(s).

    We frequently have to repeatedly upload a particular (same) XL sheet to your DB for the widgets in a number of forms. Example, an XL-sheet is loaded into your DB for 3 forms 3 times. My thought is, your system could do this updating automatically, by using the sheet(s) already in your DB. If the XL-sheet, or G-sheet, was uploaded only once, then each form requiring it, would be updated at the same time. Having the spread sheets all in g-sheet format would be a big step to realizing this process, I think..

    Thanks again, Best Robert

  • Nikola JotForm Support
    Replied on February 5, 2021 at 4:20 PM

    If I understood correcly, you want to have the ability to select an excel file, in widget settings, that is already used on another form. So, once a file is uploaded you can use it on any other form. And you also want that the excel file is automatically updated when you add new data in Google Sheets (as per your request on the other thread).

    I will raise your request to our developers. If there is any update, we will inform you here.