Forum Discussion
MarkShnier__You
Qrew Legend
Parsing Append Only Fields
so... if you have a text field set to Log Changes where the new entries act in the default manner which is to be at the bottom of the updates, here are some formuals to use to parse out the values from the most recent entry. I am also assuming that you are logging the date and not the date and time.
Most recent value (formula text field type)
Trim(Right([my update field],"]"))
Date of most recent update (this needs to be a formula date field)
ToDate(Left(Right([my update field],"["),9))
Who did the most recent update (formula text field type)
Trim(NotLeft(Left(Right([my update field],"["),"]"),9))
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
so... if you have a text field set to Log Changes where the new entries act in the default manner which is to be at the bottom of the updates, here are some formuals to use to parse out the values from the most recent entry. I am also assuming that you are logging the date and not the date and time.
Most recent value (formula text field type)
Trim(Right([my update field],"]"))
Date of most recent update (this needs to be a formula date field)
ToDate(Left(Right([my update field],"["),9))
Who did the most recent update (formula text field type)
Trim(NotLeft(Left(Right([my update field],"["),"]"),9))
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
BobFaulk
2 years agoQrew Member
Just figured it out...
Trim(Left([my update field],"]"))
Thanks again!
------------------------------
Bob Faulk
------------------------------
Trim(Left([my update field],"]"))
Thanks again!
------------------------------
Bob Faulk
------------------------------
- BobFaulk2 years agoQrew MemberI have another question...How to I take that date I extracted and now turn it into the number of days from that last contact to today?
------------------------------
Bob Faulk
------------------------------- DonLarson2 years agoQrew CommanderBob,
You need a Duration field
Today()-[Calculated Note Date]
Then make it display as Days in the format section
------------------------------
Don Larson
------------------------------- BobFaulk2 years agoQrew MemberSo if I add that to my formula...
Trim(Left([my update field],"]"))
What does that look like?
------------------------------
Bob Faulk
------------------------------
Related Content
- 17 days ago
- 12 months ago