For today learning Appsheet tips I would like to focus on Action or Behavior to do some tasks for us
Action can do many things for us ,but today I will focus on how to update the column in the table
This is a leaning project about the School library
First step let's go to Google drive make new folder like School Library
On the Books table is consisted of
Book ID
Book Title
Book image
Book Author
Book Status (Enum : Borrowed / Available )
Book borrow table consisted of
Borrow ID
Book ID
Date begin
Date end
Date return
Borrow Status (Enum : Borrowed / Returned )
NOTE: consider to Add some books data sample for learning steps into the books table
Create first Action to update the books status whenever the book was borrowed and added into the borrow table.
On Appsheet left menu panel navigate to The Behavior Section
Select + under the Books table
Action name like : Change book status to Borrowed
Table : Books
Do this Data : set the values of some columns
Set these column : Book status = Borrowed
And save
Create a 2nd action
Select + under the Books table
Action name like : Change book status to Available
Table : Books
Do this Data : set the values of some columns
Set these column : Book status = Available
And save
Test Action
Navigate to UX
On Book menu view
Click on the action icon and open the table to see the result