trigger action at "end-status" field going from "no" to "yes"

[Asheetbogo]

i have a table which collects "durations": (start-time / end-time / Button "end-status" (yes/no)

when i edit one of the data-rows i want to update "end-time"  with actual time (eg: = Now()) if  "end-status" field changes from "no" to "yes". 

a) i created "action" with "set these colums" > "end-time" = Now() 

>>> this woks fine!

b) how can i trigger this action if "status" field (yes/no) of the this data-row changes from "no" to "yes" (... not on change from "yes" to "no")

many thanks in advance for help!!!

[graham_howe]

Take a look at the following article in the help documentation. You should be able to construct an expression which performs the time stamp only if the status field has changed from no to yes.

Accessing column values before and after an update

Access the value of a column before and after a record is updated.

[Asheetbogo]

hello graham_howe: thank you so much - a very interesting way to do it - i will test it out ...

[SkrOYC]

Make sure to use [_THISROW_BEFORE] and _AFTER] with ISNOTBLANK().

I had problems with it in the past.

So it should end like this:

AND(
  ISNOTBLANK([THECOLUMN]),
  [_THISROW_BEFORE].[THECOLUMN]<>[_THISROW_AFTER].[THECOLUMN]
)

[Asheetbogo]

hello  skrOYC: many thank`s for your hint - i will test it out ....

[Steve]

Tracking Changes Using "Change" Column Types | AppSheet Help Center