bulk actions

[giovaninicarlos]

Hi appsheet community

Library 

Our data base population: Books for sure. Each book on its shelf. Each shelf has its number. 40 books a shelf or so. Many shelves  at different stores, say Store1, Store2 and so on. View is Table format.

We change some books (30) from shelf123 at StoreA to shelf456 at StoreB.  Editing each row is endless work. 

Action: UPDATE shelf number and Store. 

Do this: DATA, Set the values of some columns in this row

Shelf=INPUT("SHELF", NUMBER(""))

Store=INPUT("STORE", TEXT(""))

This bulk action takes me to the point where I can select the books, hit the UPDATE icon, and...  is not saving any changes. It makes me hit CANCEL to go back where I started the process.

Any ideas?

[TeeSee1]

One way to do this is

1. Create a 'control' table with
   • id: key (could be the next col)
   • useremail: if multiple people do updates simultaneously, use this in a security filter
   • Shelf: ref to Shelves
   • Store: ref to Stores
2. Modify the formulas of your existing action to
   • Shelf = INDEX(SELECT(control[Shelf], TRUE),1)
   • Store = INDEX(SELECT(control[Store], TRUE),1)

Now you first select the destination Shelf and Store in the control table.

Select books to bulk change and apply your modified action.