Reference multiple selected rows for a filtered view or to average two rows

AppSheet AppSheet Q&A
1

How do I reference the built-in selection tool (the box with the checkmark) for an expression to average bulk selection values? I would like to select multiple rows of data and have an action connected to that selection which will lead to an average of my selected data.

1 Like
2

Welcome to the AppSheet community.

May we know if your app has multiple users or a single user?

Also from how many maximum rows, the user is likely to shortlist the rows by manual selection?

Please also elaborate what you mean by the following

There is bulk select option and AppSheet filter. Which of these you have in mind. If possible, please share a screenshot.

2 Likes
3

image
image377Ă—338 12.6 KB

Here is a screenshot. I want to be able to reference the rows from the bulk select in an expression

2 Likes
4

Thank you.

Please respond to the following questions too.

Also please update what you mean by

References has a deeper meaning of references between tables in AppSheet and hence this question.

2 Likes
5

Multiple users. And I want an expression similar to filter(context(“bulk selected”)) for example. That way I can filter just the bulk selection and see an average of the bulk selected in a filtered view

1 Like
6

Please take a look at the sample app referred below as one option how it could be accomplished.

The app selects rows with colors based on the user selection in a slice and then creates a chart based on filtered data in the slice.

In your case the selection needs to be used for averaging instead of charting. In the filter instead of enum selection, you could have enumlist to select multiple rows based on user selection of the enumlist values.

https://www.appsheet.com/template/appdef?appId=Interactivedashboardfilter-71626&appName=Interactivedashboardfilter-71626#UX.Views.Dashboard

Finally, the sample app is for just one user. In case of multiple users, you would need a Users table with one row per user. Then these each user’s distinct rows will store the filter selection of each user. Otherwise one user’s selection could overwrite the other user’s in the absence of the Users table.

3 Likes