Sample Triggered Actions

[astroboy]

Hi everyone, I've been exploring Triggered Actions lately so I've decided to share some of those that I've created. I hope this somehow helps in building your applications, especially those who are just starting to get their interest in Triggered Actions.

[astroboy]

For starters, let's start with one of the most basic Triggered Actions template that you can try. Basically, this triggered action inserts records to a second table upon insert.  Here's the two table designs that I've created just to give you a better visualization of what this trigger does.

Table 1:

Table 2:

*These two tables contain the exact same table design but I've decided to change the name of the fields to avoid confusion.

Here's how the Triggered Actions look like:

The event that I've selected for this is the 'insert data' event so it will trigger whenever new records are inserted on the table. I then added an 'INSERT INTO' block and selected the destination table which is the 'User_Table_Sample2'. To be able to select the fields that I want to use as a reference for the fields in the destination table, I added a 'SELECT FROM' block and selected the table 1 which is also where this Triggered Action is placed. Lastly, you can now add all the fields that you want to include on the trigger.

[NiceDuck]

After this, you may want to try making a triggered action for saving the fields history/ previous value to another table.  If you are interested, please see this thread
 

 

[astroboy]

I've been practicing on working with application task and I was able to make this simple template with a workflow that transfers the record to the second table if the record isn't there yet. here's the screenshot:

 

[astroboy]

1 minute ago, astroboy said:

I've been practicing on working with application task and I was able to make this simple template with a workflow that transfers the record to the second table if the record isn't there yet. here's the screenshot:

 

In case you are wondering, you may also combine triggered actions and application tasks to achieve your desired workflow. Here's a video tutorial that I'm using as a reference: 

 

[ParkLoey]

On 9/27/2020 at 2:14 AM, astroboy said:

For starters, let's start with one of the most basic Triggered Actions template that you can try. Basically, this triggered action inserts records to a second table upon insert.  Here's the two table designs that I've created just to give you a better visualization of what this trigger does.

Table 1:

Table 2:

*These two tables contain the exact same table design but I've decided to change the name of the fields to avoid confusion.

Here's how the Triggered Actions look like:

The event that I've selected for this is the 'insert data' event so it will trigger whenever new records are inserted on the table. I then added an 'INSERT INTO' block and selected the destination table which is the 'User_Table_Sample2'. To be able to select the fields that I want to use as a reference for the fields in the destination table, I added a 'SELECT FROM' block and selected the table 1 which is also where this Triggered Action is placed. Lastly, you can now add all the fields that you want to include on the trigger.

Hi there! Just wanted to add that if you want to reference the newly inserted or updated record, you should use the #inserted table instead of the actual table name (where you applied the trigger). This also applies if you want to reference the deleted record, you use #deleted. It is stated here in this article: https://howto.caspio.com/tables-and-views/triggered-actions/#:~:text=The-,%23inserted,-table represents data

Hope this helps anyone starting out with Triggered Actions!