Triggerred action - SET field to somewthing WHERE: How to SET two fields?

[roattw]

I have the following TA that updates a field in one table when the same field in another table is updated.  If I want to do the same for a second field, do I have to rebuild/duplicate that entire Purple Update>Set>Where segment?  Not seeing hows to add a second Where condition.  I see how to ADD a new Set field, but not how to add its related Where to this (without copying the entire action set).

 

[futurist]

Hi @roattw

You can just put an OR block on the Where so you could set more conditions. Using an OR block essentially means that as long as either of the two conditions you have set is met, the Trigger will run. 

[NiceDuck]

I'm not completely getting it but do you mean that you will need a different condition for the other field?

In that case, try using a seperate if then block per each field that you want to have conditions instead of putting them on a single Where statement.

 

[NiceDuck]

Kinda like this one:

 

The base condition for joining will be handled by the Join clause, then use a seperate case when block for each field if they have their own conditions.