Forum Discussion

KariLang's avatar
KariLang
Qrew Member
4 months ago

Field in report with logged fields

For a specific field, (project status)  we have the box checked ---Log the edits to this field, and show them on forms----we would like to run reports off this filed, but off what the current project status is only.  When we go to make reports, its pulling all the log edits.  Is there a way to filter by this field . ( Example we would like to filter by Active and if you change the field [DEC-14-23 xxx xxxx] New Request, Active )



------------------------------
Kari Lang
------------------------------

3 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    4 months ago

    Tell us if the latest updates are being logged at the top of the Logged  field or the bottom.  



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • KariLang's avatar
      KariLang
      Qrew Member
      4 months ago

      It is logged at the bottom fo the field. 



      ------------------------------
      Kari Lang
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew Champion
        4 months ago

        OK here are my cheat notes

        Parsing Append Only Fields

        so... if you have a text field set to Log Changes where the new entries act in the default manner which is to be at the bottom of the updates, here are some formuals to use to parse out the values from the most recent entry.  I am also assuming that you are logging the date and not the date and time.

        Most recent value (formula text field type)

        Trim(Right([my update field],"]"))

        Date of most recent update (this needs to be a formula date field)

        ToDate(Left(Right([my update field],"["),9))

        Who did the most recent update (formula text field type)

        Trim(NotLeft(Left(Right([my update field],"["),"]"),9))

        Parse out the date and time of the update

        var text DateAndTime = Left(Right([append only with date /time],"["),18);
        var date TheDate = ToDate(Left($DateAndTime," "));
        var timeofday TheTime = ToTimeOfDay(NotLeft($DateAndTime,9));


        ToTimestamp ($TheDate, $TheTime)



        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------