Move records from one table to another based on a field's value

[CaptnK]

I have two tables, Active_Users and Inactive Users. 

Each table has a user id, name, and status.

I would like a trigger invoked on insert and updates to the Active Users table.

The trigger moves records from Active Users to Inactive Users where the status = "inactive" in the Active Users table.

Any help appreciated.

[AtayBalunbalunan]

There may be various solutions to this using Triggered Actions, CaptnK. You may refer to the following as a sample reference.

 

 

 

It is highly advisable to work on test tables and data when troubleshooting Triggered Actions to prevent modifications of your actual live data. You may try the above and check if it works for you.

 

 

[roattw]

Going back on this answer a bit.  These both be included in triggered actions correct, not just one or the other? Thx

[IamNatoyThatLovesYou]

Hello @roattw, Yes the sample that was provided are for Triggered actions. However, you may try this on Application Tasks as well. You may  check it out here.

[Flowers4Algernon]

Hello! For more information regarding Triggered Actions, you may refer here: https://howto.caspio.com/triggered-actions/triggered-actions-2/