Track who changed a column
Iโve got a column which is an image.
I want to be able to track when, where and who either created or last changed it.
The when and where are done easily with ChangeTimestamp and ChangeLocation columns.
But what about the user?
I canโt use initial value because that will just log the creator
I tried this as an App Formula - IF([Photo1TimeStamp]=Now(),UserEmail(),โblahโ) Which I initially saw did work.
But If you click on anything else, the formula runs again and then will obviously return blah.
Anyone any ideas?
I believe the Data Change / Workflow would be the easiest solution because you can check the status with [_THISROW_BEFORE].[Image]<>[_THISROW_AFTER].[Image]
nice! Translate
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |