Forum Discussion

NicoleVarner's avatar
NicoleVarner
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 one with formula but cannot figure out how to do the 3rd entry.  I have a field that will count each time an entry is added. I just need the date of when it was logged.
Here is the formula from the field that is counting the entries in the logging field:

var text Dispositions = [Log Disposition];
Count(
Part($Dispositions,3,"]"),   
Part($Dispositions,4,"]"),
Part($Dispositions,5,"]"),
Part($Dispositions,6,"]"),
Part($Dispositions,7,"]"),
Part($Dispositions,8,"]"),
Part($Dispositions,9,"]"),
Part($Dispositions,10,"]"),
$dispositions)

------------------------------
Nicole Varner
------------------------------
Formulas and functions
Tables and fields
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew 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's avatar
      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's avatar
        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
        ------------------------------