Assistance with a trim formula
I am using the following formula in a text formula field to trim out just the value (which is a date) of a log edits text field. The formula is including the ------------ after the user name in the ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendtry this
Trim(Right([my update field],10))
That will take the 10 rightmost characters.
But then I suggest changing your field type to be formula date
ToDate(Trim(Right([my update field],10)))
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Thanks Mark. Both of these work however I forgot to mention that my logging field is set to put new entries at the top instead of the bottom. This is because the field is logging dates and we want to see the most recent date at the top. Can the formula be adjusted for that or do I need to change that setting? I don't have a lot of data loaded yet so I can reload it if the setting has to be changed.
------------------------------
Rachel Miller
------------------------------
- MarkShnier__You
Can you copy and paste (not a screen shot) what the data look like for a multiple entry logging?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------Last Access Date is the logged field and Last Accessed - Date Only is my formula field. I should also mention that I didn't have logging turned on initially which is why you don't see it as a log entry for 06-16-2023.
-- [JUL-03-23 Rachel Miller] --------------
06-30-2023
06-16-202306-16-2023
------------------------------
Rachel Miller
------------------------------- MarkShnier__You
This should work, but but only if you show the updates on one line - it's too difficult to deal with those extra hyphens.
Show the name and date on the same line as the entry
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------