ContributionsMost RecentMost LikesSolutionsRe: Is there a way to track who modified a specific field being changed?Evan/Mark thankyou for your responses. I've been told automatons will be phased out soon and to use pipelines for this. Unfortunately I'm not realm admin but I'm trying to duplicate the functionality in audits onto a table. Mark - I'm hoping my audit table would have these fields (and can restrict the number of fields as the trigger): Field Changed - this will actually show me the name of the field that's changed in the main table. So if my automaton has 10 fields to look for triggers, this will show the specific field changed. I can't see a way of adding the actual field name from the main table into this field in the audit table - any hints? Old Value New Value Changed by Changed date ------------------------------ Adam Hollman ------------------------------ Simple formula, but not simple to me.Hi all - first off, obviously I'm not a coder hence the request. I have a field called 'Episodes x Duration' and in there it holds TV production data of how many episodes by how many minutes per episode. So you'll have 10x60 (10 episodes of 60 minutes each) etc. I have one formula in a total episodes field taking the episode count of 10 using: var text LastEntry = Left([Episodes X Duration],"\n"); Trim(Right($LastEntry, "[")) But I need one for a new Duration field to automatically pick up the duration of 60. Can someone help with that formula please? And also I'd like a field called 'Total Minutes' which turns the value in the field into a calculation and takes the value 10x60 and applies =10x60 and shows the result 600. Looking for a formula for that also please? Looking forward to the community helping me, thanks all. Ad ------------------------------ Adam Hollman ------------------------------ Re: Is there a way to track who modified a specific field being changed?Hi Evan, Hope you're well. I found your response very useful above and also want to track all changes to all fields in my productions database. I have over 100 fields, isn't there a way I can run an automation which creates a new record in an 'update' database but copies over which field was changed and the actual change in the field without linking the specific field in productions to the field in updates. I basically don't want to have to copy the whole records fields, i just want to copy which specific field has changed into the update database. Thanks ------------------------------ Adam Hollman ------------------------------ Re: Intro & Queries - Warner Bros. International TV Production Mark – many thanks once again ------Original Message------ Its always best to post the complete error message along with your actual code to help us debug. But I can see that there was a mismatched quote on the last line Trim(Right($Last Entry, "]")) ------------------------------ Mark Shnier (YQC) Quick Base Solution Provider Your Quick Base Coach http://QuickBaseCoach.com markshnier2@gmail.com ------------------------------ Re: Intro & Queries - Warner Bros. International TV Production My apologies I received a syntax error on that one. I copied in the total formula and there was an error on the logging at the top part, and the ($Last Entry part, and then the last "])) part. Thanks again. var text LastEntry =Left([Logging at the top],"\n"); Trim(Right($Last Entry, "])) ------Original Message------ np, try this var text LastEntry =Left([Logging at the top],"\n"); Trim(Right($Last Entry, "])) That should packman gobble form the right up to the first ]. The trim gets rid of any extra white space (blanks). ------------------------------ Mark Shnier (YQC) Quick Base Solution Provider Your Quick Base Coach http://QuickBaseCoach.com markshnier2@gmail.com ------------------------------ Re: Intro & Queries - Warner Bros. International TV ProductionMark, coming back to you on this formula, what if I want to remove the brackets and the date/name tag from the latest comments formula please? [OCT-23-19 xxx.xxxx@warnerbros.com] ------------------------------ Adam Hollman ------------------------------ Re: Intro & Queries - Warner Bros. International TV ProductionI think I've still go the idea in my head of a formula which runs from the standard Date Created and Date Modified fields. So: If Date Created is less than 30 days old show 'NEW' orIf Date Modified is less than 30 days old show 'UPDATED' and if neither, keep blank. And then work on another field to create a formula based on that field with colours etc. ------------------------------ Adam Hollman ------------------------------ Re: Intro & Queries - Warner Bros. International TV ProductionPerfect. This is wonderful, thankyou so much. ------------------------------ Adam Hollman ------------------------------ Re: Intro & Queries - Warner Bros. International TV ProductionYes only after I imported the database in, oh hindsight! And yes, new comments are at the top. There is always a line break between new and old comments if that helps. ------------------------------ Adam Hollman ------------------------------ Re: Intro & Queries - Warner Bros. International TV ProductionTASK THREE - I have aNotes On Progressfield set withLog the edits to this field, and show them on formsoption turned onam using the formulaTrim(Left(NotLeft([Notes],"]"),"[")) in another field to trim off all the other tracked notes when running reports, but I need a formula which if there are no other updated or edited notes, it shows the original note OR the updated note. Can someone help? For example, the notes on progress cell shows: [OCT-18-19xxxx@warnerbros.com] Following the rating's success, we're working on a primetime edition now Commissioned. And I only want the last comment below to be added to a field, and not the original comment of 'commissioned' [OCT-18-19xxxx@warnerbros.com] Following the rating's success, we're working on a primetime edition now Thanks, Adam ------------------------------ Adam Hollman ------------------------------