Forum Discussion
WilliamLatimer
7 years agoQrew Cadet
Yes, I am talking about the Date - Name part. In the screenshot I shared above, the logging details makes it hard to read the actual values in that list view. In the subsequent details page, then I do want to see the logging details of Date - Name.
- EverettPatterso7 years agoQrew CaptainOk, you can just make two formula fields. Use one on the list view and use one on the details page.
Last Log Without Date/Name = Trim(Right([My Field],"]"))
Last Log With Date/Name = If([My Field]="", "", Left([My Field], " ") & "] " & Trim(Left(NotLeft([My Field],"]"),"["))) - WilliamLatimer7 years agoQrew Cadetstruggling with syntax. Below is my attempt to do the Last Log Without Date/Name:
- EverettPatterso7 years agoQrew CaptainTry it without the If Statement
Trim(Right([Status],"]")) - WilliamLatimer7 years agoQrew CadetThat works, but it now is showing the history of values rather than only the most recent.
- WilliamLatimer7 years agoQrew CadetThis is what it was prior to this last change:
var text LogField = [Phase];
If(Trim($logField)<>"",
"[" & Left(NotLeft($LogField,"["),"[")) - WilliamLatimer7 years agoQrew CadetActually, its showing the last 2 values. Strange!
Current value and the prior value. There are a total of 4 values historically in the field its referencing. - EverettPatterso7 years agoQrew CaptainIs the logging field set to show new entries at the top or bottom?
- WilliamLatimer7 years agoQrew CadetAt the top.
- WilliamLatimer7 years agoQrew Cadetjust as your screenshot, I deselected "show entries at the bottom of the field
- EverettPatterso7 years agoQrew CaptainThis one should work
Trim(Left(NotLeft([Change Log],"]"),"["))