popolare i campi del modulo tramite dropdown che attinge a google sheets

Buongiorno,

Vorrei sapere se esiste un modo e quale potrebbe essere per:

durante la compilazione di un modulo un utente cliccando su un menu a tendina trova una lista di nomi che vengono da un foglio google sheets (Attenzione: il foglio google si autoaggiorna con sempre nuovi dati e anche il menu a tendina deve trovare tutti i dati del foglio AGGIORNATO)

e selezionando uno di questi nomi, i successivi campi del form (cognome, indirizzo, codice fiscale, email etc) si autocompilano con i dati corrispondenti del foglio google

ESEMPIO

Foglio google:

nome, cognome, indirizzo, email

Modulo jotform:

il campo NOME è un dropdpwn che trova i dati del foglio google. Selezionando uno dei nomi gli altri campi (cognome, email etc) si popolano con i dati del foglio google.

Non voglio che questa operazione avvenga caricando un foglio excel, ma che il dropdown prenda i dati sempre aggiornati dal foglio google.

Se necessario l'uso di una API o di zapier potete spiegarmi.

Grazie mille

Marcello

Hi marsido2,

Thanks for reaching out to Jotform Support. Unfortunately, our Italian Support agents are busy helping other Jotform users at the moment. I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in Italian, let us know and we can have them do that. But, keep in mind that you'd have to wait until they're available again.

Now, let me help you with your question. We have the Spreadsheet to Form widget. It allows you to upload an external spreadsheet to your form and use the values on the spreadsheet to prepopulate your form. Values are automatically populated when the column headings match your form field labels. This widget supports full name, email, phone number, scale, single and multiple choice, short and long text entries, drop-down, and rating values. An extra work here is you will need to update your spreadsheet every time new data comes in the Google Sheet meaning you will need to upload a new spreadsheet to the widget for it to match with the new data in the Google Sheet.  Let me show you how to use it:

• In Form Builder, click on the Add Form Element + menu on the left side of the page.
• Under the Widgets tab, search for the Spreadsheet to Form widget and add it to your form.

• In the Widget Settings window that opens up, upload your data file and customize the other options. 
• Then, click on Update Widget.

• In the final stage, add the fields to view values and name them the same as on the spreadsheet.

Give it a try and let us know if you need any help.

Hello

Thanks for the answer.

I don't want to update my spreadsheet every time new data comes in the Google sheets, this means I will have to upload a new file every time the Google sheets will update, and/or anyway I would have to work myself and not automatically.

I would like that every time the Google sheets will update, the drop-down field will also update automatically, without any work from my side.

i imagine there is not a direct way to do it, but what about using an API or other ways to let the form take data from a Google sheet?

thank you 

Hi marsido2,

Thank you for getting back to us. In order for the Spreadsheet to form widget to work, you will have to upload an Excel file with data in it. Just to confirm if I understand your requirement, do you want the new data added to your Google Sheet file to automatically update the drop-down field? If so, please know that we don't have a feature that will automatically update the uploaded Google Sheet file in the Spreadsheet to Form widget. If there is new data added to your sheet, you will have to re-upload the Google Sheet file with the new data for it to be used by the widget. Kindly confirm if this is the feature you are looking for so we can submit a feature request.

I haven't tried this process with API before but you can check our API Documentation for reference.

Once we hear back from you, we'll be able to help you with this.

Yes, I confirm that I want to automatically update the dropdown field when a new spreadsheet row is added to the google sheet.

Don't want to update the uploaded file, I want (best) that the dropdpwn field will be connected directly woth the google spreadsheet, and take the data from there (when a new data is added to the sheet, this new data would appear on the dropdown field).

Is it possible to realize this? Even using zapier or API or other way?

thank you

Buongiorno marsido2,

Grazie per averci ricontattato. Purtroppo no, non è possibile compilare automaticamente i campi di un menù a tendina utilizzando le informazioni contenute in un foglio di calcolo online che viene aggiornato periodicamente. La maggior parte delle integrazioni, incluse Zapier, funzionano inviando i dati da Jotform ad una piattaforma esterna e non sono programmate per fare il contrario.

Anche utilizzando Zapier non credo sia possibile, le azioni che si possono compiere quando avviene un trigger non sembra che coinvolgano l'aggiornamento dei campi di un determinato menù a tendina. Puoi verificare le azioni che puoi fare con Zapier qui.

Per quanto riguarda l'utilizzo di API, in questo caso potrebbe essere possibile farlo tuttavia, l'impostazione potrebbe essere piuttosto complicata.

Rimaniamo a disposizione per ulteriori chiarimenti.