_THISROW_BEFORE & _THISROW_AFTER SHow If Constraint

AppSheet AppSheet Q&A
1

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]
)

2

Hi @tejaderts

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

2 Likes
3

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)?

4

Yes.

There is a type for this :slightly_smiling_face:

Column data types - AppSheet Help

Aurelien_0-1669615896679.png
Aurelien_0-1669615896679.png764×301 35.7 KB

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

1 Like
5

thank you so much

2 Likes