Discussions

 View Only
  • 1.  Date and Time Stamp of Created File

    Posted 06-24-2020 10:13
    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
    ------------------------------


  • 2.  RE: Date and Time Stamp of Created File

    Posted 06-24-2020 10:20
    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
    ------------------------------



  • 3.  RE: Date and Time Stamp of Created File

    Posted 06-24-2020 10:35
    Edited by Evan Martinez 06-24-2020 14:34

    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

     

    FacebookLinkedIn

     

    Supor Logo Registered Email

     

     

     

     






  • 4.  RE: Date and Time Stamp of Created File

    Posted 06-24-2020 12:08
    Edited by Evan Martinez 06-24-2020 14:34

    It worked Perfect!!!  Thanks so much Mark!

     

    Kyle McAfee

    Estimating & Database Design

    Supor Heavy Haul

    15171 Cronewood Lane

    Memphis, IN 47143

    FacebookLinkedIn

     

    Supor Logo Registered Email