Hey there!
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.
Help appreciated!
Thanks!!
User | Count |
---|---|
43 | |
30 | |
25 | |
23 | |
13 |