Forum Discussion

Qrew Member

5 years ago

Pulling information from a logging field

I am trying to pull information from a multi-line text field that is logging each entry. I don't need the first or last entry in the field. I need the 3rd entry. I know how to get the first or last ...

Formulas and functions

Tables and fields

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

5 years ago

Third from the top or the bottom?

Can you post a copy and paste of an example of the logged field and the results you expect?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

NicoleVarner
Qrew Member
5 years ago

I am trying to pull the date and time from the 3rd entry. ( [Sep-30-20 12:26 PM Nicole Varner] Left Voicemail 7)
This might not be the path I need to go.
This is what we are trying to get:
We need to know when the user has changed the disposition of the entry 3 times. We need to capture the date and time when the 3rd change happens.
We have a field that will count each entry in the above field. That field is called Total Calls.
I tried creating a formula field that when the Total Calls field = 3, pull the date and time:
If([ Total Calls]=3,Now())
But when the user opens the entry to change the disposition for the 4th time, the Total Calls field still shows 3, which causes the formula field to change to the current date and time.

------------------------------
Nicole Varner
------------------------------
- NicoleVarner
  Qrew Member
  5 years ago
  I was able to pull the 3rd entry (3rd from the top) to pull into its own field with this formula:
  var text Dispositions = [Log Disposition];
  (Part($Dispositions,4,"["))
  The field type is Text formula.
  But the date is showing as SEP-30-20. Any suggestions on how to convert month to a number and the year to show the full year?
  
  ------------------------------
  Nicole Varner
  ------------------------------
  - NicoleVarner
    Qrew Member
    5 years ago
    Nevermind! I got it to work!
    
    ------------------------------
    Nicole Varner
    ------------------------------