how can i add a uses edit log

[Random_shadow]

how can I add a user log of a user edited a row and get it to say in a column
user1 edit at 6:00 pm

user3 edit at12:00 am

user5 edit at 3:00 am

on saving the row

[Markus_Malessa]

For starters you need a separate table, that table may have multiple ref type columns if you wish to record an edit for multiple other tables in a single table. Then you should have a column for User and Timestamp. Then use Automation and for each table you want an edit log add a bot for 'data change' 'updates only', then create a process with one step and for the action choose 'add a row to another table using values from this row'. For the field that links back to the table ref value = [_THISROW], User field = USEREMAIL(), Timestamp = NOW().

That's the most basic explanation I can provide. If that doesn't get you on the right track please feel free to ask for clarification.

[Random_shadow]

is there any other way that using Automation area i new to this still 

[Markus_Malessa]

You could attach the action of 'add a row to another table using values from this row' to the form 'save' event. You can locate this under UX, find your form, expand the behavior section.

[Random_shadow]

ok ill try that

[Random_shadow · Accepted solution]

i have found a way to use your code for the bot and intergrated it into the form 

i know there is a warning on the owner box it just to hide my email it was an example 
thank you @Markus_Malessa 
.

code i use put in FORMULA
time last edit----TODAY()& " , " &TIMENOW()

last edit----TEXT([Owner]) & " , " & TEXT([time last edit])
log users---TEXT([last edit]) & " | " & TEXT([log users])

if anyone els want to use it you can 

[Random_shadow]

 .

[Markus_Malessa]

Something like this