I need to run an database update only if the value of a datacell is TRUE. I have applied the policy in multiple way, but it seems to have some issues. To verify I wrote the value of the Datacell to the Table and I am getting correct Value
As shown in the figure below I have applied multiple formulas like
Thanks for your post and screenshot, I can help you out with this -
First, I want to highlight your good practice to test the returned values in a data cell. That's a great way to verify values and help check the syntax of your formulas
In regards to your question, the formulas you've tried should work, which means there may be an issue later in your automation.
I would just note that for this particular automation, you do not need to use the IF function, since the run options are already going to run only if the provided conditions are met. (So you can perhaps use =$[v_NWCell]=TRUE for the sake of simplicity).
When you say you're seeing issues, what is happening when you try your automation? Let us know too other details around how you set up the automation, and the goals you intend to achieve with it.
Hi Alyssa, I am facing similar issue I have applied the filter need to populate multiple Cells and if they are populated then only create a new record for the same.
Attaching the screen shot, Can you help Thanks