Automatic update of the date field, when a value changes in another field, but editable

[Gustavo_Eduardo]

Good day, friends, a question.

If I have a price field and next, I have a date field. I would like that if I change the price field, the date updates. In other words, let's say the price of an item is $10, and the date is January 9, 2024. If on the 10th, I find out it costs $11, I would like that when I type the new price, the date automatically changes to the date it is being entered. However, I would like that date to be editable. Can someone help me with this? Thank you.

[Gustavo_Eduardo · Accepted solution]

What I did was the following:

I configured the date field with an initial value equal to TODAY() and set the condition that it be reset if the price field is blank or if it has changed.

IF(
     OR(
                 ISBLANK([Price]),
                 [_THISROW_BEFORE].[Price]<>
                 [_THISROW].[Price]
            ), true, false
      )

[Gustavo_Eduardo · Accepted solution]

What I did was the following:

I configured the date field with an initial value equal to TODAY() and set the condition that it be reset if the price field is blank or if it has changed.

IF(
     OR(
                 ISBLANK([Price]),
                 [_THISROW_BEFORE].[Price]<>
                 [_THISROW].[Price]
            ), true, false
      )

[AleksiAlkio · Accepted solution]

This should be enough..
OR(
ISBLANK([Price]),
[_THISROW_BEFORE].[Price]<>[_THISROW].[Price]
)

[Gustavo_Eduardo]

I already modified it and it is more efficient as you suggest!! thank you @AleksiAlkio