¿Cómo puedo controlar si todas las personas han completado todos los formularios?

Voy a enviar 6 formularios a mas de 100 personas en emails distintos.

Voy a poner para que me envie un email de confirmación cada vez que la persona rellene uno de los formularios.

Pero quisiera monitorizar si han rellenado todos los formularios todas las personas.

Se puede hacer una tabla tipo excell google sheet que registre como "recibido" cada uno de ellos de manera que se pueda ver ràpidamente quien falta por contestar y cual de los cuestionarios?

gracias

Hi ainhoa,

Thanks for reaching out to Jotform Support. Our Spanish Support agents are currently busy helping other Jotform users. 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 Spanish, let us know and we can have them do that. But, remember that you'd have to wait until they're available again.

About what you're trying to do, I’ll need a bit of time to look into this. I’ll get back to you as soon as I can.

Hi ainhoa,

Each form has a dedicated Jotform Tables where you can see the submission data. We can't automatically create a master file for 6 forms and tag which people filled out the forms. Jotform records the submission data per form. For now, you need to manually monitor who hasn't filled out which forms.

You may want to integrate a Google Sheets into each form where submissions are transferred to your spreadsheet. You can save it in 1 spreadsheet with different worksheets. Let me show you how to integrate it:

1. In Form Builder, in the orange navigation bar at the top of the page, click on Settings.

2. In the menu on the left, click on Integrations and select the Google Sheets integration.

3. Choose an  Action button and select Next.

4. For previously authenticated accounts, choose the account to use, then click the Add Action button.

5. On the next page, set up the options accordingly:

Spreadsheet Name — Enter the name of the spreadsheet that will be created.

Worksheet Name — Enter the name of the worksheet.

Fields to Send to Google Fields — The integration selects all fields by default. Uncheck the fields you wish to exclude.

Send Existing Submissions to the Sheet — If you have existing submissions in the form, you can send them to the spreadsheet by checking this option.

6. Finally, click the Save button to complete the integration.

If you select Create new spreadsheet, a new spreadsheet will be created in your Google account, where submissions will be collected. If you select Use existing spreadsheet, submissions will be collected in the spreadsheet you choose, which is already connected to your Google account. We also have a guide about How to Integrate Forms With Google Sheets that you can check out.

Check out the screencast below to see how you can manually track it:

Reach out again if you need any more help.