Forum Discussion

KyleMcAfee's avatar
KyleMcAfee
Qrew Trainee
5 years ago

Date and Time Stamp of Created File

I am trying to capture how long it takes to do each proposal on average.  The proposal is basically done when you create the Exact Form Plus pdf (which is a button).  I know how to compute duration of new records going forward but I am having a hard time figuring how to compute duration on old records.  The the only way I have been able to think of, is to compare DATE CREATED to date/time stamp of the pdf (the proposal) that was created.  How do I capture/reference date and time of a created file or some other work around?

------------------------------
Kyle McAfee
973-229-9099
------------------------------
APIs and custom code
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    In the button which creates the Juiced EF+ document there is typically a line which reads

    & "&faid=1272&efpdte=1299"

    That means to put the file attachment into field ID 1272 and the date/time into the field 1299.

    So if you have that line enabled, then you should have a field with the date and time of the PDF creation.




    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • KyleMcAfee's avatar
      KyleMcAfee
      Qrew Trainee
      5 years ago

      It worked Perfect!!!  Thanks so much Mark!

       

      Kyle McAfee

      Estimating & Database Design

      Supor Heavy Haul

      15171 Cronewood Lane

      Memphis, IN 47143

       

       

       

       

       

       

       



    • KyleMcAfee's avatar
      KyleMcAfee
      Qrew Trainee
      5 years ago

      Wow!  Let me try this.  I will let you know.  Thanks so much!

       

      Kyle McAfee

      Estimating & Database Design

      Supor Heavy Haul

      15171 Cronewood Lane

      Memphis, IN 47143