Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
Here are three useful formuals
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))
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))
- QuickBaseCoachD7 years agoQrew Captain... ie in View mode just show the formula for
Most recent value (formula text field type)
Trim(Right([my update field],"]")) - Data_SystemAnal7 years agoQrew CadetThank you so much work beautiful so now you helped in the past to only show the first input see in another formula the formula below
var text LogField = [Is the goal measurable?];
If(Trim(($logField))<>"",
"[" & Left(NotLeft($LogField,"["),"["))
but the formula above shows the date and QB user who made the input
"[MAR-05-19 pba@nextsteppcs.org] second input
How can I trim the first par with is the log entry ("[MAR-05-19 pba@nextsteppcs.org]) that only show me the date input (Second Input)
overall First value (formula text field type) is what I am looking for help
Thanks - Data_SystemAnal7 years agoQrew Cadetsorry I mean to say the Date input Only
- QuickBaseCoachD7 years agoQrew CaptainI am very confused by your question. I provided three different formula to use depending on which element of the append only fields you are trying to parse out.
My formulas only work if the new entries are on the end of the list. - JosetteTrux6 years agoQrew MemberHow would write the formula if the new entries are at the end of the list?
- AustinK6 years agoQrew Commander
My formulas only work if the new entries are on the end of the list.
Josette, it should already function that way.
- JosetteTrux6 years agoQrew MemberIt doesn't though. I used the formula provided here and it returns the oldest entry.
- QuickBaseCoachD6 years agoQrew CaptainThis particular set of formuals will work if you have the logging field set to show the new entries at the bottom.