How to create a report of all submissions across all active forms within a time range?

Actualmente puedo integrar en un archivo de cáculo de drive los resultados de mis formularios que se dividen por pestañas, pero me gustaría poder toda la información en una única pestaña ¿es esto posible?

Hi noelia.escobar,

Thanks for reaching out to Jotform Support. Unfortunately, our Spanish 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 Spanish, 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, coming back to your question, are you looking to create a report of all submissions across all active forms within a time range? If so you can use our Combine Submission Data app to combine the submissions from all the forms into a single .csv file. That file can then be imported into Excel. The Combine Submission Data app also has the feature to only include dates in a set time range that you require:

If that’s not exactly what you’re looking for, can you explain a bit more so I can help you better?

Reach out again if you have any other questions.

Mil gracias Joseph!!!

Una pregunta más, ¿este informe se puede automatizar para tenerlo todos los meses o cada vez que quiera el informe mensual tengo que seleccionar uno a uno los distintos formularios con la información que quiero agrupar?

Hi Noelia,

Thanks for getting back to us. Currently, the Combine Submission Data app does not support the automatic sending of CSV files. You would need to manually select the forms and the specific data you wish to be included and generate the CSV report each time.

However, as a workaround, you might want to check the Digest Email feature. This allows you to receive scheduled reports automatically, which can include the total number of submissions, a chart showing off the selected field(s), and submission details of the selected forms all in one email. Let me walk you through it:

1. On your My Forms page, click on My Forms on the top-left side of your screen.

2. In the menu that opens, click on My Reports.    3. On your My Reports page, click on Create Report on the top-left side of the page.

4. In the menu that opens, click on Digest Emails on the top-mid side of the menu.5. Set up the following:

• Email Subject
• Email Recipients
• Repeats
• Send Date
• Send Time
• Time Zone

6. Click on Next on the bottom-right side of the page.

     7. Select the forms that you want to receive the regular digest emails for.

8. Then, click on Next on the bottom-right side of the page.

   9. After customizing the layout of your Digest Emails as you want, click on Create Digest on the bottom-right side of the page.

10. In the menu that opens, click on Create Digest and that's it. 

    You can also check our guide How to Personalize your Digest Emails and Digest Emails page.

Give it a try and reach out again if you have any other questions.

Buenos días,

Lo que necesitamos son los datos de los formularios mensualmente compilados en un único archivo y en una única hoja.

La integración con Combine Submission Data es perfecta pero perdemos tiempo seleccionando los archivos y la información que necesitamos mes a mes, si crees que hay alguna forma más ágil de obtener esta información, lo agradeceré.

Hola Noelia,

Muchas gracias por ponerte en contacto con el Soporte de Jotform. Como alternativa, podéis probar Jotform Digest, que incluirá todos los envíos que hayáis recibido y lo podéis programar para cada mes. Podréis añadir los campos que os interesan o hacer reportes que se envíen cada mes. Os dejo aquí una guía de como hacerlo. Es muy sencillo y podéis añadir diferentes formularios.

Espero que haya sido de ayuda y no dudes en contactarnos si tienes alguna otra pregunta.