Jump to content
  • 0

Triggered Action is not Working


Aleksandra
 Share

Question

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

Triggered Action.png

Link to comment
Share on other sites

5 answers to this question

Recommended Posts

  • 0

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.



 

Link to comment
Share on other sites

  • 0

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. 

Link to comment
Share on other sites

  • 0

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

Trigger 1.png

Edited by Aleksandra
I need to add screenshot
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...