Logging edits to a record

Yes this is possible. An append or prepend text field (QuickBase calls this property "Log entries" now) accumulates a short log of changes to itself. However, when used in conjunction with the image onload technique you can gather those fields that have been changed along with the old and new values and stamp this information into the append or prepend text field. In other words, the append or prepend text field would never receive human keystrokes - rather the script injected into the page will monitor for changes to field values and assemble a string of text reporting these changes and automatically insert the generated text into the append or prepend text field. When the form is ultimately saved the append or prepend text field will be holding a miniature report of changes to all fields being logged and QuickBase will stamp the date/time and user using the native operation of the append or prepend field.. This may seem fantastic that you can do this but the edit form actually contains both the new values of the fields and the old values of the fields in hidden form elements.

I will come up with an example shortly - I have to finish watching my morning cartoons now.

I know that there is a third party add on which does this.  It basically received the Notification emails when a record was changed and parses out the changes  and records them to a QuickBase database.

That is a ridiculous solution. Why not retarget a spy satellite and then call the QuickBase API when the changes are beamed back to HQ. This feature can be directly implemented in a QuickBase form.

Thanks. Curious about the image onload technique, will wait for the example.

Here is your example:

Come Mr Tally Man Tally Me Bananna
https://haversineconsulting.quickbase.com/db/bi5q4vzj9



Edit Record 1 and Log Everything Like the NSA Does
https://haversineconsulting.quickbase.com/db/bi5q4vzmc?a=er&rid=1

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=305

Notes:

Back to watching cartoons ...

kind of a newbie here... where is the code inserted? and how would you log entries for a database that has 350 fields (and growing). I could really use this as an audit trail for my records!!

Great answer by the way!

Hi  Dandiebolt,
Thanks for providing such a wonderful information above and prompt response !!

I checked out link provided by you https://haversineconsultingr.quickbase.com/db/bgm2m4g?a=dr&rid=305
and found java script code for on change action which logs the old and new values of input field in log type field.

In Home settings-->Pages--> I created test.js page and writen the similar code but its not working.
Do i need to add any js or html library in order to execute the js code ??

Please Dan provide your valuable suggestion to me so that i can execute that script properly.

Thanks in advance !!!

I am in conference mode and unlikely to be able to reply until next week.

Thanks Dan ...not a problem .. Please take your time ..and i will be waiting for your response. :)

Can you please explain how this is done step by step. Thanks