Passer de JOTFORM gratuit à une soution pérenne

bonjour,

Nous avons créer un formulaire de santé dans le cadre d'un projet de thèse scientifique. Ce formulaire répondu par nos patients via un lien mail se retrouve dans un googlesheet avec plusieurs feuilles de calcul nous permettant d'interpréter au mieux les réponses apportées.

Cependant, après 150 réponses nous n'avons plus le lien avec le google sheet.

Quelles solutions pouvez vous nous proposer ?

Cabinet du DR Lartigau

Hi pouillot,

Thanks for reaching out to Jotform Support. Our French Support agents are busy helping other Jotform users right now, so 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 French, let us know and we can have them do that. But, it might take a while until they're available again.

Now, coming back to your question, I understand you created a form and you integrated it with Google Sheets. However, submissions on that form are no longer sent to the Google Spreadsheet it is integrated with, is that correct?

I’m sorry you're having difficulties with this. I’ll do my best to help you. We can push the missing submissions of your form to the Google Spreadsheet it is integrated with. Can you send me the link to your form so we can do so?

It is important to note that we do not recommend manually updating the Google Spreadsheet because that could break the integration. As a workaround to that, you can reintegrate your form with Google Spreadsheet. Let me show you how to do it:

1. In Form Builder, in the orange navigation bar at the top of the screen, click on Settings.
2. In the Settings menu, click on the Integrations option on the left side of the screen.
3. Select the Google Sheets integration.
4. Then, click on Remove Integration, and then Yes, Remove!
   

Now, let's connect the Google Sheets Integration again. Remember that if you choose to create a new spreadsheet, the integration will create a new spreadsheet with a different link. And, if you use an existing spreadsheet, even if you select the same spreadsheet and use the same worksheet name as before, it will create a new worksheet in the existing spreadsheet.

1. In Form Builder, circle back to Settings at the top of the page.
2. In the Settings menu, click on the Integrations option and Google Sheets integration again.
3. Now, select and connect your Google account.
   
4. Select an option.
5. Choose your form fields.
6. Click on Save, and that's it, you're done.

We also have a guide about Google Sheets integration that you can check out.

If you really need to modify the data sent to Google Sheets, you can import the data into another spreadsheet or worksheet using Google Sheets' IMPORTRANGE function.

Reach out again if you need any more help.