I am new to appsheets and am hoping to get some guidance on developing an app that collects data via a form. I want to take this app a step further by taking the data collected into a dashboard and am specfiically looking for guidance on this part of it. I would like to be able to use the dashboard to slice and dice the data based on the data that is inputted/provided via the form. For example, look at a summary view of all the form submissions for the form submissions where "Value x" was the value (or one of the values) selected for Question 4. I would want to look at the data nicely displayed.
Are there any resources or guidance out there that can help in creating an associated dashboard/dashboard views connected to data collected via form created in the app?
1. Note : Dashboard is collection of ref views .
---------------------------------------------------------------------
@kmelendez128 wrote:For example, look at a summary view of all the form submissions for the form submissions where "Value x" was the value (or one of the values) selected for Question 4. I would want to look at the data nicely displayed.
2. If you want the above need, there multiple ways to achieve it example.
1. LINKTOFILTEREDVIEW()
2. Slice creation with row condition : [COLUMN] = "X"
3. Inline views with select() or filter() functions with conditions as you specify.. [COLUMN] = "X"
User | Count |
---|---|
15 | |
10 | |
9 | |
7 | |
3 |