Changing a value by changing a certain value

[shalom]

I want to do that every time I change the value in column A (but only of column A)

The value of column B changes to another value (but I can edit column B manually)

[dbaum]

Set the properties of Column B:

• Reset on Edit: [_THISROW_BEFORE].[Column A] <> [Column A]
• Initial Value: The default value you want

[shalom]

But it will give me back my initial value

Any change in any value in the row

[dbaum]

For the Rest on edit property of Column B, enter an expression that returns TRUE given the condition where you want Column B's current value to be overridden and  reset to the column's defined initial value.

For the Initial value property of Column B, enter a value (e.g., 10) or else an expression  (e.g., [Column A] + 10) that returns the value you want to be the default.

[shalom]

Thank you for renewing me  " Reset on Edit  "  I did not know of its existence

Can you explain to me the purpose of the formula

"[_THISROW_BEFORE].[עמודה A] <> [עמודה A]"

[dbaum]

That expression evaluates whether the value of column A changed. It returns true if the prior value does not equal the current value. 

[shalom]

תודה 🙏

[shalom]

The bot is currently running the action on any "all record" change
Then page B cannot be edited