I have a main table “Books” where each record represents a book title. The columns/fields store details about each book, e.g. title, author, a URL to the cover image, etc.
One column in the table is an ENUM field called “Cover Type”. It categorizes the basic cover design of each book.
The possible values for this ENUM field is stored in another Table “Possible Cover Types”. For example, “Landscape”, “Person”, “Other”
I successfully have set the ENUM field to autocompute the suggested values based on the possible cover types options listed in the “Possible Cover Types” table. (e.g. Cover Type[Possible Cover Types].
In the Detail View for each Book, I have a Quick Edit for this Cover Type Enum Field, showing as buttons. So going through each book record, I can quickly set the Cover Type for each book with one click.
Challenge: Bulk Select/Edit
But I also want to set the Cover Type of multiple books in bulk. For example, I have a Gallery View or List View of all books that shows the thumbnail/image of all book covers.
Appsheet natively allows the user to select multiple books in such Gallery or List view. And then one can of course set an Action to be performed on these selected books.
HOWEVER, I am struggling to define an action that bulk sets the Enum “Cover Type” field, pulling and using the possible Enum Values from the “Possible Cover Types” table and letting me choose one of the possible options and bulk set it in all selected records.
I was trying to define an ACTION of the type: “Set values of some columns of this row” – and bulk apply this action to all selected. But I struggle to find the syntax to use this to set the value of an enum field. Also the ACTION type “Execute an action on a set of rows” does not get me any further.
What am I missing? Is this possible at all? And if so how?