"Select all" for bulk actions

AppSheet AppSheet Q&A
1

is there any way to select all rows in a slice (or group in a slice) and run a bulk action on all of them?

The application requires users to perfrom an action on the entire slice or group of rows in a slice all at once, so this would be much better than having them check off every single row before running the action.

Thanks!

2

To my knowledge, there is no “select all” option in multi-select mode. If the set of rows can be described by an expression, you could create an action to apply to the list the expression generates.

3

Thanks Steve,

The rows can definitely be described by an expression as they are already grouped in a slice - how could i achieve this?

4

You could use an action of type Data: execute an action on a set of rows with a Referenced Table of the table on which the slice is based, a Referenced Rows expression that produces the keys of the rows in the slice, and a Referenced Action of the action you want applied to each row.

2X_7_7fa8d9812bc46e76f18b9bc2ed17477380691bf8.png
2X_7_7fa8d9812bc46e76f18b9bc2ed17477380691bf8.png777×486 42.5 KB

Note that you’ll have to find somewhere to surface the button for this bulk action, and it cannot be an overlay on a deck, gallery, or table view, unfortunately.

3 Likes
5

I’m having exactly the same problem as in this topic.
To work around the problem that there is no ‘select all’ in bulk mode, I created my own select all action ‘execute an action on a set of rows’. This action sets for all rows the column ‘select’ to ‘true’.
The only problem is that my ‘select all’ button is visible in every row in the table view. This is not very logical.
Is there really no other workaround for this problem?
By the way, the reason to use a ‘select all’ is, that sometimes it’s is needed to apply, or do something on almost all rows, but not all. Then just push ‘select all’, and then de-select some.

2 Likes
6

Jan_Lambrecht:

Is there really no other workaround for this problem?

Nothing simple.

1 Like
7

I see two solutions:

  1. The possibility to display user created actions on the top of bottom of the screen.
  2. A real ‘select all’ created by appsheet.

I also thought on using a dashboard view with

  1. A view with only custom made action buttons (select all and de-select all)
  2. The table view itselves.
    The drawback of this is that when scrolling down in the table, the buttons are going out of the screen.
2 Likes
8

Bulk Select Multiselect Select All Tips & Tricks ?

We can do Bulk Select in Table, Deck and Gallery View. [Multiselect] We can even navigate to a view that’s already in Bulk Select Mode. (My Table View is called “Text”) This is the expression for the Action type “App: go to another view within this app” LINKTOVIEW(“Text”) & “&selected=” & ENCODEURL(“”) [Multiselect2] Or even navigate to a view that’s in Bulk Select Mode and items preselected. Like Select All. (My Table is also called "Text) LINKTOVIEW(‘Text’)&‘&selected=’&ENCODEURL(…

2 Likes
9

Lastimosamente no existe la opcion de selecionar todo en appsheet aun, una opcion con la cual yo me movilizo para ejecutar acciones sobre filas en la version de escritorio, es usar el Boton Shift + el cursor. Selecionas el primer registro y de forma posterior junto al boton presionado puedes desplazarte hasta el final y seleccionar todo.

BMACHERO_0-1667848685899.png
BMACHERO_0-1667848685899.png380×425 30.5 KB

y asi seleccionas todos los registros de 1 sola vez (SHIFT - CLICK).

BMACHERO_1-1667848726793.png
BMACHERO_1-1667848726793.png409×908 89 KB

6 Likes
10

Hi @BMACHERO may you please elaborate it ? I’ve clicked on SHIFT (on my Mac) select first record and move on the other records … but the other records remains unselected …

11

Thank you, @BMACHERO ! @FaCe , first do a regular click on one checkbox. Then hold shift and click on another checkbox several rows away. All the checkboxes between the first and second checkboxes will get checked.

3 Likes