Discussions

Expand all | Collapse all

Pulling information from a logging field

  • 1.  Pulling information from a logging field

    Posted 26 days ago
    Edited by Nicole Varner 26 days ago
    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
    ------------------------------


  • 2.  RE: Pulling information from a logging field

    Posted 26 days 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
    ------------------------------



  • 3.  RE: Pulling information from a logging field

    Posted 26 days 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
    ------------------------------



  • 4.  RE: Pulling information from a logging field

    Posted 26 days 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
    ------------------------------



  • 5.  RE: Pulling information from a logging field

    Posted 26 days ago
    Nevermind!  I got it to work!

    ------------------------------
    Nicole Varner
    ------------------------------