Triggered Action is not Working

[Aleksandra]

Hello,

For some reason, my triggered action is not working. Does anyone have an idea what could be wrong here? So, in the first one, I want to change the existing role to a Project Manager role in the Resource table (#inserted) anytime they get a Project Manager role assigned in the Project Team table and when their status in the Resources table is active. In the second case, I want to see the name of the Project team in the Resources table anytime they get a team assigned in the Project Members table and when their status in the Resources table is active. I've uploaded the screenshot of the triggered action I've created. It should run anytime someone updates an existing record and adds new records.

Thank you,

Aleksandra

[NiceDuck]

The trigger setup seems fine.

If no update on the #inserted is occurring, the only possible reason I am seeing there is that you are having mismatch values on the #inserted.email to the email field on your joined table. You may have to directly check them the values on the table.



 

[NiceDuck]

Oh! and make sure that the trigger is active/enabled. I've been on situation where I simply forgot to turn the trigger on.

[Aleksandra]

Thanks, @NiceDuck. I haven't figured out why this is not working yet. The trigger is active, and I have checked that I have users with the same email in both of the tables. Could there be a problem because the Project Team field is pulled out from another table? I have a Project Team table but I've created relationships between Project Team and Resources table and Project Team and Project Team Members table so I think there shouldn't be a problem with that part either. I am really puzzled by this. 

[Aleksandra]

Sorry for popping up with this again, but I checked everything and none of the update/inserts triggered actions I have in my app are not working. On the other hand, email triggers work fine. This is an example of another triggered action I've created. It should update the Hourly Rate field in the Project Members table whenever this field is updated in the Resources table.

It was enabled, there were email fields that match, and no matter what I try here it simply doesn't work. Does anyone have any idea why this is happening? Is it possible to contact someone from Caspio support about this? Please, ignore my post below this

Thank you all in advance,

Aleksandra

Edited November 25, 2022 by Aleksandra
I need to add screenshot

[Aleksandra]

This is a trigger I've created.

 

[Aleksandra]

To anyone who's reading this, I have figured out how to make the second trigger from this topic work. Here is a screenshot of it as someone might find this helpful. Still not sure why the first one is not working, but I'll leave a screenshot as a solution here as soon as I figure it out.

 

[CoopperBackpack]

Hello @Aleksandra,

According to your description you need to update the Project Members table whenever this field is updated in the Resources table.

So, you need to create a Trigger on the table where the action occurs. In your case this is the Resources table. 

Therefore this must be a Trigger that is executed on the update on the Resources table and updates the Project Members table. 

Due to this reason the first Trigger doesn`t work. It is created on the Project Members table and "listen" for the update. But there is no update action there as far as I understood the workflow. 

I think, the Trigger with the following design should work:

 

In this case, for example, if I update the Hourly_Rate value in the record with email = a@mail.com in the Resources table (let`s say change from 11.0000 to 55.0000)

 

Trigger will update the Hourly_Rate field in the Projects table for the records with the same email (in this example, the values will be replaced with 55.000)

 

Is it the result you are looking for?

To help you with the Trigger, I need to understand the relationships between the tables. 

[Aleksandra]

@CoopperBackpack, thanks for your answer. I think I figured out what is wrong with my first trigger. So, in the first trigger, I want to update the field Role in the Resources table whenever the field Role is updated/added in the Project Members table. In the second trigger action, I need to update the fields Hourly Rate and Availability in the Project Members table whenever these fields are updated in the Resources table. The second trigger works, but I will try to think about the approach for updating Role in the Resources table when it is added/updated in the Project Members table.