Triggered Actions

[Joemac]

Newbie trying to create  a triggered action.  If a customer in my Clients Table has any associated records in a completely different table I want a specific field within the Clients Table to equal yes.   

So an example if a client from the clients table has project in a projects table the field in the client table would equal yes...if they dont have a project it would equal no.

I have a unique identifier for the client which would be in both tables.  I'm just not familiar with how the triggered actions work.  Thanks!

[Tubby]

Hi @Joemac

If I understood your workflow correctly, once a project is added to the project table and it is associated to a client that is existing in the client table, then the yes/no field for the client will be checked. Is that right? Feel free to correct me if I'm wrong. If that is the case then try a similar triggered action as this:


This Triggered Action is created in the Project Table and will run once a new project is created.

Sample insert:

Sample Output in Client Table:


I hope this helps.

[Joemac]

@Tubby So appreciate you doing this for me!  I think I can follow this and set it up.

[astroboy]

Hello there, since your workflow seems to have many tables with related records, I suggest joining those tables to your Triggered Action as seen on the example provided above. Also, you may try playing around CASE WHEN blocks if you have any conditional scenarios that you need to prompt using triggers. For more information, you may check this HowTo article:

https://howto.caspio.com/tables-and-views/triggered-actions/

[autonumber]

Hello! I just wanted to add to their answers. Here's a video that demonstrates more triggered actions.
https://www.youtube.com/watch?v=ZdkQOvLX4ok

https://www.youtube.com/watch?v=wA7KR9dygh4

https://www.youtube.com/watch?v=w6T1cqg0gnk