changeTimestamp Data Type

[tvinci]

Hello AppSheet

Can I have a changeTimestamp data column that only changes when a user of a specific role makes a change in the table?

Right now both “Drivers” and “Dispatchers” interact with the same table so the changeTimestamp column only shows the timestamp of the most recent change.

I want to fix this by having a second changeTimestamp column that only changes when a dispatcher makes a change, and then have the first changeTimestamp column only change when a driver makes a change.

I have a users table that specifies everyones role and email address so I think a lookup function would suffice. I just don’t know where to put the lookup function. Maybe the update field?

Thank you.
Tiffany

[LeventK]

In the changeTimestamp type column, set an expression like:

AND(
	"Driver" = LOOKUP(USEREMAIL(),"USERS","EMAIL","ROLE")
	NOT([ColumnnA] = LOOKUP([_THISROW].[Key],"TableName","Key","ColumnnA")
)

[tvinci]

Thank you @LeventK. Where exactly do I put the expression? In App Formula?

[LeventK]

@tvinci
You can put it in the initial value like this:

IFS(
    AND(
		"Driver" = LOOKUP(USEREMAIL(),"USERS","EMAIL","ROLE")
		NOT([ColumnnA] = LOOKUP([_THISROW].[Key],"TableName","Key","ColumnnA")
	),NOW()
)