Forum Discussion
MarkShnier__You
Qrew Champion
Can you post me the copy and paste of the data for some sample data in the field the field and I will make the formula for you.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
TrishWehrle
4 years agoQrew Cadet
Here's the logged field example that made me realize my formula was wrong. It returned the value of May-26.
[MAY-12-20 8:54 PM Jason Khalaf] EE Contact with (close contact)
[MAY-22-20 12:55 PM Adam Walters] Living with
[MAY-26-20 8:58 AM Barry Smithley] EE positive
Here's one example where the log has 'living with' as the latest entry:
[APR-06-20 12:10 PM Trish Wehrle] EE Contact with (close contact)
[MAY-26-20 10:18 AM Leah Schooling] Living with
------------------------------
Trish Wehrle
------------------------------
[MAY-12-20 8:54 PM Jason Khalaf] EE Contact with (close contact)
[MAY-22-20 12:55 PM Adam Walters] Living with
[MAY-26-20 8:58 AM Barry Smithley] EE positive
Here's one example where the log has 'living with' as the latest entry:
[APR-06-20 12:10 PM Trish Wehrle] EE Contact with (close contact)
[MAY-26-20 10:18 AM Leah Schooling] Living with
------------------------------
Trish Wehrle
------------------------------
- MarkShnier__You4 years agoQrew Championwhat is there are two of them ("living with")for some reason, do you want the first one or the last one.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- TrishWehrle4 years agoQrew CadetIf there are two then the most recent one.
Thanks!
------------------------------
Trish Wehrle
------------------------------
- MarkShnier__You4 years agoQrew Championtested :)
var text ReplaceLivingwithByABar = SearchAndReplace([Logged field],"Living with","|");
If(Contains($ReplaceLivingwithByABar,"|"),
ToDate(Left(Right(NotRight($ReplaceLivingwithByABar,"|"),"["),9)))
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------