Submissions Page: Ability to set time frame based on variable days.

  • Pegazo1
    Asked on December 6, 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 Thread 1315799 Screenshot
  • Kevin Support Team Lead
    Replied on December 6, 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

    10 07 2017 1507372064 Screenshot 10

    I hope this helps. 

  • Pegazo1
    Replied on December 7, 2017 at 4:05 PM

    Kevin,

    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!

  • Kevin Support Team Lead
    Replied on December 7, 2017 at 5: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. 

    Thanks. 

  • Pegazo1
    Replied on December 8, 2017 at 10:45 AM

    Thanks for opening that feature request!