Jump to content
  • 0

Triggered Actions


Joemac
 Share

Question

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!

Link to comment
Share on other sites

4 answers to this question

Recommended Posts

  • 0

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:
image.png.a68c2eed986c5f0d32d61c51253ca5f6.png

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

Sample insert:
image.png.c03deb5f932d48183032d755472047ae.png
Sample Output in Client Table:
image.png.68636f0802ce659238ca066a30635f4a.png

I hope this helps.

Link to comment
Share on other sites

  • 0

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/

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...