Triggered action help

[mdav20]

I'm confused by triggered actions and I'm hoping someone can help.

I have two tables for tracking asset's by serial numbers.

 

One is asset information (make, model, size, serial number, etc) the other is asset hours which tracks when a asset is used and has installed_hrs and removed_hrs to track the time.

Asset information has a field called "Status"  (installed, spare, out for repair)  I would like a trigger that when installed_hrs (asset_hours table) > 0 the "status" in asset information table changes to "Installed"

 

So basically changed a field in one table based on a field in another table.

 

Thanks

[joshua]

Hi Mdav20,

Here's a screenshot of the Trigger Action setup that we created based on the data and conditions you provided. You may apply enhancements in case needed.

 

We also encourage you to watch our video tutorial in creating Triggered Actions in Caspio from a 3rd party online resource, as seen below:

Let me know if you have any other questions regarding this.

Thank you.