I have a record that, when changing state, a field places the data of the user who made the change of state. But when you press an action button, this field changes with the data of the user who pressed it.
What can I do so that this field does not change and keep the data of the user who made the change of state but not of the user who pressed the button of an action?
Try this in the app formula of the field that records the user who made the change.
IF(CONTEXT(โViewTypeโ) = โFormโ, <change by user value>
, [_THIS])
Basically, this is saying that if the change is being made while on a Form, update the value to . Otherwsie, keep the value that is in the field ([_THIS]).
Thank you!
User | Count |
---|---|
20 | |
16 | |
4 | |
3 | |
2 |