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
Solved! Go to 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
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.
is there any other way that using Automation area i new to this still
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.
ok ill try that
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
.
Something like this
User | Count |
---|---|
42 | |
25 | |
25 | |
17 | |
12 |