In this EP2 I would show you guys how to create the bot to work automation for us let see.
from the left menu navigate to the Automation
Create New bot
Name the bot like "Update book Status when borrow"
On Event select Data Change
Add data
Add a step
name a step like : run action book borrow"
choose
Run action on row
referenced table : Books
reference rows : Select(Books[Book ID],[Book ID]=[_THISROW].[Book ID])
Referenced action select : Change book status to Borrowed
Save
Create 2nd bot to run the action when the book was returned
Go to Automation
New bot and name : update book status when return
On Event select Data Change
data update
Add a step
name a step like : run action when book was returned "
choose
Run action on row
referenced table : Books
reference rows : Select(Books[Book ID],[Book ID]=[_THISROW].[Book ID])
Referenced action select : Change book status to Available
Save
ไม่มีความคิดเห็น:
แสดงความคิดเห็น