Hi, I have a column in my app and sheet where its only purpose is to record the edit made by the user.
Every time an entry is edited by one of the allowed users. I would like it to record the last record with the useremail, timestamp and what column was edited and what was the previous entry.
Currently, I made my app record the whole previous entry and i do not know an easier way to just record the column that got changed.
Here is an example of one of my smaller formulas in the โedited byโ column.
IF(
OR(
[_THISROW_BEFORE].[Date] <> [_THISROW_AFTER].[Date],
[_THISROW_BEFORE].[Operator] <> [_THISROW_AFTER].[Operator],
[_THISROW_BEFORE].[Cars Drained] <> [_THISROW_AFTER].[Cars Drained],
[_THISROW_BEFORE].[Operating Hours] <> [_THISROW_AFTER].[Operating Hours],
[_THISROW_BEFORE].[Downtime Hours] <> [_THISROW_AFTER].[Downtime Hours],
[_THISROW_BEFORE].[Notes] <> [_THISROW_AFTER].[Notes]),
CONCATENATE(USEREMAIL()," , ",NOW(),
", Date ",[_THISROW_BEFORE].[Date],
", Operator ",[_THISROW_BEFORE].[Operator],
", Cars Drained ",[_THISROW_BEFORE].[Cars Drained],
", Op Hrs ",[_THISROW_BEFORE].[Operating Hours],
", Down hrs ",[_THISROW_BEFORE].[Downtime Hours],
", Notes ",[_THISROW_BEFORE].[Notes]),
" ")
How would I make it where it would only Concatenate the useremail, timestamp and whatever entry was changed, instead of output all the previous values.
Any help would be greatly appreciated. Thank you in advance
Nas
PS: also how can I make the formula not record the first empty entry (when thisrow_before is blank) without making the formula huge.
LinkedIn
Twitter
