Automation Filters Multiple Values
The goal is to make updates to multiple values in table A with user input values in table B. The issue I am running into is when the update is provided with any blank values (because they only want to update some of the values)
I have tried two approaches and both are causing issues:
- I built a single automation for updating all the values. But as I described above, if the user leaves any of the values blank it pushes the blank value to table A and potentially overrides data. Is there a way to put in a filter on the trigger of an automation to say only update value x if it is not blank, value y if it is not blank, value z if it is not blank or any combination?
- I also tried making an automation for each value (an automation for x, an automation for y, and any automation for z) that has the condition if the field is not blank in the trigger statement but this is causing issues when they are trying to run at the same time. Currently these automations only work properly if all values are filled in. If only one values if filled in it does not execute the update.
The end goal is to have an automation that will push updates to table A when I make updates in table B for the fields modified ONLY. i.e. I go into table b for record XYZ, if I left field x and field y blank in table B, then make NO updates to table A. If I update field z in table B, then push this update to table A.
Please let me know if you have any ideas on how to get the higher level automation to work as this is the desired method since I have 2 forms of updates and at least 3 fields per.
------------------------------
Thanks in advance,
Jennifer Paschal
------------------------------