Forum Discussion
QuickBaseCoachD
11 years agoQrew Captain
No problem. maintain your current field but rename it to be Request Status Update. Show that field only in Edit mode.
Make new fields to parse out any or all of the three components of a logged field - the WHO did it WHEN and said WHAT.
Last Updated Value
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))
So in your case you want the first one as a formula,text field, and then show that field on all reports and also In View mode of the form.
Make new fields to parse out any or all of the three components of a logged field - the WHO did it WHEN and said WHAT.
Last Updated Value
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))
So in your case you want the first one as a formula,text field, and then show that field on all reports and also In View mode of the form.