_THISROW_BEFORE & _THISROW_AFTER SHow If Constraint

[tejaderts]

Hoping someone can help

I have a ticketing App and a [Activity] column in which each activity has its own owner (this is where the Show If kicks in).

After Owner no. 1 updates the ticket, It will go to the responsibility of owner no. 2 but the _THISROW_BEFORE & _THISROW_AFTER seem to be not working.

Are there any work around?

Codes:

IF(
AND(
OR(
([_THISROW_BEFORE].[Activity]="Activity1"),
([_THISROW_BEFORE].[Activity]="Activity2"),
([_THISROW_BEFORE].[Activity]="Activity3")
),
([Activity]="Activity4")
)
,NOW(),[_THISROW_BEFORE].[Activity4 Date]
)

[Aurelien]

Hi @tejaderts 

---

@tejaderts wrote:

but the _THISROW_BEFORE & _THISROW_AFTER seem to be not working.

---

This works for bot components, not for editing unfortunately.

You may prefer using another column to store previous values, that will be updated through grouped actions.

Actions: The Essentials - AppSheet Help

[tejaderts]

Thanks for the fast Revert.
other than the action button, do you have any other suggestion on how can I do timestamping for each Change in [Activity](each activity, has its own column for the time-stamping)?

[Aurelien · Accepted solution]

Yes. 

There is a type for this 🙂

Column data types - AppSheet Help

And you can set the focus on a specific columns if needed.

[tejaderts]

thank you so much