Forum Discussion
MarkShnier__You
Qrew Legend
Adam,
Can you post these two questions below as separate questions on this forum and for each try to better explain them with an example? I'd like to help but not able to understand either one.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
Can you post these two questions below as separate questions on this forum and for each try to better explain them with an example? I'd like to help but not able to understand either one.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
AdamHollman
5 years agoQrew Trainee
TASK THREE - I have a Notes On Progress field set with Log the edits to this field, and show them on forms option turned on am using the formula Trim(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:
And I only want the last comment below to be added to a field, and not the original comment of 'commissioned'
Thanks, Adam
------------------------------
Adam Hollman
------------------------------
For example, the notes on progress cell shows:
[OCT-18-19 xxxx@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-19 xxxx@warnerbros.com] Following the rating's success, we're working on a primetime edition now |
Thanks, Adam
------------------------------
Adam Hollman
------------------------------
- MarkShnier__You5 years agoQrew LegendSo it looks like you only enabled logging after some comments were entered as the "Comissioned" entry has no logging as who who made the entry or when.
Also do you have the new entries set to log at the top of the list? Normally they default to show at the end of the field. Obviously the formula needs to be different if you want to hive off the first entry at the top of the logging as opposed to the last one.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------- AdamHollman5 years agoQrew TraineeYes 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
------------------------------- MarkShnier__You5 years agoQrew Legendtry this
Left([Logging at the top],"\n")
The "\n" is the delimiter for a line break / carriage return, so that says to do a packman type gobble from the left up until the first carriage return.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------