You can configure Automated Reports for your app. The reports will be sent in the form of Excel sheets to a specified list of recipients on a daily/weekly/monthly basis. Which columns are to be included in the reports and what filters need to be applied can also be configured here.
In Edit, go to Analytics, in that click on Automated Reports and click on the Add Report Button to get started.
Enter a name for the report
Comma-separated list of email Ids who should receive the Reports.
The reports will be sent over Email. Enter a subject for the email here.
Enter the body for the email here.
Choose one of Daily, Monthly or Weekly depending on how frequently the reports are to be sent.
Select a Time of the day when the reports are to be sent.
This option will appear if the frequency is set as weekly. You can configure the reports to be sent on any day from Sunday-Saturday.
This option will appear if the frequency is set as monthly. You can configure the reports to be sent on any date from 1 to 31. If this is set as 31, but that month doesn't have 31 days, the report will be sent on the last day of that month.
The report will be sent as an Excel File. You can set a prefix for the name of the file.
Choose the fields from the app whose data needs to be included in the report.
Apply some filters on the submissions to decide which data needs to be included in the report. For example, if you have set the Report frequency to Weekly, you can set the Submission Date Range filter to Last 7 Days. Additionally, you can put filters on any other fields of the app.
This is used to filter the status of data.
This is used to sort the data as ascending(upward arrow) or descending (downward arrow) with respect to a variable.
Once you are done with the configuration, you can send a report to verify the data immediately. Use the Send Now button for that. NOTE THAT THE REPORT NEEDS TO BE SAVED BEFORE CLICKING ON THE SEND NOW BUTTON.