- Pegazo1Asked on December 06, 2017 at 11:02 AM
We want to export to Excel, each morning, all of the previous day's submissions to all of our forms.
1) So far I see how to export submissions from a single form, but not all forms
2) And I don't see where to select only the previous day's activity
It seems like this ought to be pretty straightforward -- a lot of JotForm users must need to do this -- but I still haven't found how to do it. Help? Thanks!
- JotForm SupportKevin_GAnswered on December 06, 2017 at 12:11 PM
I think you may want to try the reports to cloud app: https://apps.jotform.com/app/reports_to_cloud
This will send the submissions to the integrated Dropbox account, you may also try with the Google Sheets integration: https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet
But so far, it's not possible to send submissions based on time frames, you can only manually do this while you're downloading the submissions from your account:
I hope this helps.
- Pegazo1Answered on December 07, 2017 at 04:05 PM
We don't mind downloading the spreadsheets directly to our desktops, so we don't need to use Dropbox or Google Sheets, but thanks.
My first question was about reporting on all our forms, not just one at a time. You didn't address that question. Is it possible? How can this be done? I imagine that other organizations, too, would like to report on multiple forms at once.
I appreciate that we can limit the time frame under "Submissions". In the list of possible time frames, I'd like to suggest that JotForm adds the choice, "Yesterday". And for Monday mornings, it would be nice to have the choice, "Past three days" (so it would select Friday, Saturday and Sunday transactions). This would mean fewer clicks, compared to having to select "Custom Time Frame" and specify the dates. I imagine a lot of organizations would like to have "Yesterday" and "Past three days" as options in the time frame list.
Thanks and talk to you later!
- JotForm SupportKevin_GAnswered on December 07, 2017 at 05:38 PM
Unfortunately, it's not possible to download an Excel report for all the forms, although we have a combine submissions app that generates a CSV file from all your forms: https://apps.jotform.com/app/combine_submissions
Now, the time frames you would like to are not currently possible, but I will open a feature request for this, although we cannot provide an ETA, we will keep you updated via this thread.
- Pegazo1Answered on December 08, 2017 at 10:45 AM
Thanks for opening that feature request!