Automatic updating file excel / Widget

Hello, is it possible to link an excel file in google drive and activate automatic updating when I add a new location via the widget.

Thanks

Hi Stéphane,

Thanks for reaching out to Jotform Support. I'm not sure that I understand what you want to update. By the means of the Spreadsheet to Form widget, you can automatically update the fields of the form when filling in a dedicated field of a form, which could be for instance the Field named No ID. But in that case, since the Excel file must be embedded into widget itself, you need to reload the Excel file into the widget to update its content.

At the contrary, if you want to update an Excel file in Google Drive when a respondent submitted the form, it's not possible anymore, but you can use the Google Sheet integration to automatically update a Google sheet of yours with the submissions received from your form.

Reach out again if you want to be more specific, or have any more questions.