Solved: Execute an action on a set of rows changes wrong f... - Page 2

Open_YourEyes · 12-12-2019 12:49 PM

Hey guys,
I’m using a “execute an action on a set of rows” action.
The problem is that the rule changes also the value other columns:
Action1:

Action2:

The goal is to just change the value of “ERP” like in action1 just on many rows where rule of action2 is true.
When Im running the Action2 (execute an action on…) with the action1 as refecerenced action all the values of the view are chaning (e.g.: the “user”).

What I’m doing wrong?
Can someone help me?

Phil

I am not sure I understand what you are reporting. Can you clarify?

The Data Change action is only updating the value of the single field you specify.

However, if your table contains fields that have AppFormulas or Worksheet Formulas, then those field values will be recomputed and potentially updated whenever the record is updated. In your case the update is being triggered by the Data Change action.

If you want an AppFormula to be evaluate exactly once when the record is first created, you should specify that expression in the InitialValue property. InitialValue expressions are not reevaluated on updates.

Forgive me if I misunderstand what you are reporting.

View solution in original post

Execute an action on a set of rows changes wrong fields