Hey everyone,
Is there a way to cause an action to affect a data change on a different (non-child) table?
Specific example: I made an app that tracks textbooks at a school. There is a โinventoryโ table of all books and an โactivityโ table that tracks each bookโs activity (assigned to student, returned, etc.). The inventory table has a โstatusโ column where users can mark that a book has been reported missing. Letโs say a book is marked missing, and then someone scans an โactivityโ item for that book โ I want the app to immediately recognize that the book is no longer missing, and run an action to change the value of the Status column in the โinventoryโ table! Is there a way to do that?
Thanks in advance!
@Zecharya_Michelsohn1 You can try using the action type โexecute an action on a set of rowsโ. This action will perform another action on a set of rows from a table that you can choose. The rows are identified by an expression that returns the rowsโ IDs. In your case, you need to ensure that the expression only returns the ID of the book in question. The action to be executed will be a separate action that updates the bookโs status. Finally youโll need a workflow rule that will perform the top level action (the one that performs an action on a set of rows) when triggered (the trigger can be scanning โactivityโ item).
Is there an example of this? I did not quite get it
Worked like a charm! Thanks!
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |