Hello everybody. Guys, I’m developing a library-oriented AppSheet, but I’m having difficulty executing the following function. I need that every time a book is loaned in the “Loans” database (View “Loan”), I need the book that is rented to become “unavailable” in the “Books” database.
You would build an automation bot that is triggered by the addition of a new row in the Loans table. This bot should change the status of the relevant book in the Books table.
Start here: AppSheet automation: The Components - AppSheet Help