ContributionsMost RecentMost LikesSolutionsRe: Historic Log - Field / Record Modifications by User I've already tested this and it appears to work for what I need so far. The only thing I'mstruggling withis the "Then on the audit logging table you would create the same field by formula - the table that the entry was logged from eg "Orders" and the Record ID#" I might have something mixed up. Take a look below. Audit Table Screenshot- See Task # field.This is fed by an action from my Task table based on the Record ID in the Task table fed to a text field in the Audit Table. I would like to have a URL Button taking you to that Task # record from Audits to Tasks. Is that what you meant? And Vise Versa between tables. Formula not working - URLRoot() & "db/" & [_DBID_TABLE_2] &"?a=er&rid="&[Record ID]&"&dfid=2&tab" Task Table Screenshot - Report Link, as you can see I'm now showing the audit trail data I need in the record via report link field. However, I do not need the Task # formula button here. Action Under - Support Tasks Table Re: Historic Log - Field / Record Modifications by User I'm soaking up the knowledge,I can see your suggestion being applicable to us as well. Especially if we need to track a larger # of fields later down the road. It's still much appreciated. Also, if you have details on that beta please share. Re: Historic Log - Field / Record Modifications by User This is clicking a bit more for me. I can see where this is going with how it functions a little better. Quick question though, you say "create a child table of Audit Logs for the table you are tracking". I need to track from multiple tables,two currently with the possibilityof a third we planned to add.Will I need to create more than one child table for audit logs. Or can I simply map or build relationships betweenmy Audit Log table fields to fields in bothmyCustomers table & fields in my Support tasks table? Customer (Parent Table) -= Support Tasks (Child Table) Customer - = Slow Pay Tasks (Child Table - Potential NEW table) ------ Audit Log (Child Table) Fields: User, Date/Time, Old Value, New Value, Field Name (Mapped to Field in Table I'm tracking?) ----- For some context here some examples of the fields and tables I need to track. Support Task Table -Fields: Start Date, Sent Date, Finished Date, On Hold (Checkbox), Cancelled (Text Drop Down) Customer Table - Fields: Agent Assigned (Text Dropdown), Renewal Date, Renewal Amount (Numeric), Contact Date, Contact Type (Radials / Checkbox) I think I will give this a try as it seems a little more simplistic before I resort to Joshua's method. Yourtime is greatly appreciated. Hope I explained this properly. Re: Historic Log - Field / Record Modifications by User Hi again Joshua, So far your suggestion seems to meet my needs best based on itsdescription. My use of coding in QBapps has been very limited however, I consider myself a novice in that area.Any chance there's a walkthrough example somewhere I can reference to get my bearings? Basic steps etc.The related forum discussionsbounce all over and many of the links no longer work. Re: Historic Log - Field / Record Modifications by User Hello Joshua, Thank you for the suggestion, that is something I've been researching via the below forum post. In combination with Append or Prepend text fields. The challenge I had there is the walkthrough is specific to text fields. I also have Date and checkbox fields to contend with and would need to build this out for approx. 15 fields individually between my two table records. This is one possible solution I have yet to try, but wanted to research my options and see what other suggestions where out there. https://community.quickbase.com/quickbase/topics/logging-edits-to-a-record Re: Historic Log - Field / Record Modifications by User10 fields should be more than enough for my need. I have two separate table forms or record types I need to track edits for, with only 6 - 8 fields in each record I'd need to track field modifications for.Historic Log - Field / Record Modifications by User I'm trying to track edits / modifications by user, for multiple fields in a form or record. I cant seem to figure out how to create a basic audit log. That gives measimple historic view of changes to arecord. I need to show the user who made a change and what fieldswere changed on that record with date & time stamp at the minimum. It also needs to allow simplereporting. Our basic app layout Customer Table (Primary)- Support Task Table (Child) Customer Form (Cust Record)- Support Task Form (Task Record) Each customer record is assigned an Account Manager (User) Task records share a related field with customersfor Account Manager to show whos assigned to that account. Support Task Records have a 2nd assigned agent, Fulfillment Assistant (User) not present in the customer table. Looking for something like the below per record. Similar to the last modified by butlogging the complete trail andspecific fields changed, suggestions? Example 1: Task # 123456 ---- (Field Name) Modified byJohn Doe3/6/2018 11:18 AM (PST) (Field Name) Modified by Christian Stamper 3/7/2018 9:10 AM (PST) (Field Name) Modified by Christian Stamper 3/7/2018 9:18 AM (PST)