transfer data bulk selection

AppSheet AppSheet Q&A
1

Hi,

I have a table A with some cols, ID_A col included and NAME col as well. Then, I have another table B with some cols too, ID_B col included and a SELECTION col. What I want is the next: I would like to select some rows from table A using the system based checkboxes and send all the NAME col values of that selection to SELECTION col of specific-single row of table B (this SELECTION col is an EnumList).

I’ve tried to create an ‘execute an action on a set of rows’ on table A place ‘set the values of a row’ action on table B, writing the next code on setting de SELECTION value: [SELECTION] + LIST(LOOKUP([_THISROW].[ID], “table A”, “ID”, “NAME”), but it doesn’t do anything when I execute the action with some selected rows. I’ve also tried different combinations of that formula (SELECT or FILTER instead the LOOKUP), but I didn’t success.

Any idea of what can I do?

Thank you very much!

2

Not supported. The AppSheet feature that allows you to select several rows by checking them, is a Bulk processing feature - meaning it will apply the same process to each row selected. You are describing a “bulk selection” feature - apply a process to all rows selected collectively.

You can build your own Bulk Selection feature in a couple of ways:

  1. Add a column that “marks” the row as selected. Then use an Editable table or an Inline button to “select” all the rows. The trick here is how to trigger the process that then operated on the selected row collection. There are many ways depending on your use case.
  2. Add an EnumList column used in Form View to select the rows from a dropdown list. The advantage here is that you could also set other properties to be used in the processing and when you Save you can automatically trigger the process.

This is very high-level. I fyo have questions please ask.

I hope this helps!