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?