I am attempting to set up custom reports for our app. A brief example of what our app does:
We collect responses from our employees, who are participating in advising mentally challenged people with volunteer work. During the day, these responses collect a wide array of information that is input into a spreadsheet via a forum view. At the end of the day, or at any given moment, we need the ability to “merge” these responses (or, some of the data fields) into an easily readable and printable document for storage/filling. Each reponse is individualized, and each individual may have several responses in any given day, depending on how many different community “sites” they end up visiting (since each site requires a feedback note on how the activity went).
Currently, we use an add-on on Google Sheets, but would like to get away from using the back-end sheets workbook as much as possible. There are just too many opportunities for data loss, and we’ve had that exact issue before.
Due to this, I’ve taken to AppSheet’s built in reporting! So far, I have some questions:
1.) Am I able to set up a way to trigger a report, other than adds/updates/deletes? Say an employee wanted to export a specific response, at any given time. How would I do this?
2.) Am I able to set up a way that we can select date ranges, and then export those responses for, say, a specific “date” or “site name” or “participant name”?
3.) How difficult would it be to have a report run statistical information - from another portion of this workbook, that contains race, household income, address info, etc, and be able to pull said numbers for statistical tracking? We would want to be able to “report” on the percentages of various ethnicity/racial groups, as well as male to female ratios, etc.
I know this is all very possible, but I don’t really have an idea of where to start with this in AppSheet.