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

  • Profile Image
    Pegazo1
    Asked 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!

  • Profile Image
    Kevin_G
    Answered 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

    10-07-2017-1507372064.png

    I hope this helps. 

  • Profile Image
    Pegazo1
    Answered on December 07, 2017 at 04: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!

  • Profile Image
    Kevin_G
    Answered 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. 

    Thanks. 

  • Profile Image
    Pegazo1
    Answered on December 08, 2017 at 10:45 AM

    Thanks for opening that feature request!