Forum Discussion

AnkitPruthi1's avatar
AnkitPruthi1
Qrew Member
6 years ago

Capture Date when document is uploaded in Field

Hi All!

Hope you are doing fine!

I have a query regarding capturing the date when a document is uploaded.

Is there anyway to capture this information?

Thanks!

------------------------------
Ankit Pruthi
------------------------------
File attachments
Quickbase Automations
  • AdamKeever1's avatar
    AdamKeever1
    Qrew Commander
    6 years ago
    Select to keep all revisions:

    Then when looking at a form, you can check revision history and see dates:



    Is this what you are needing?


    ------------------------------
    Adam Keever
    ------------------------------
    • AnkitPruthi1's avatar
      AnkitPruthi1
      Qrew Member
      6 years ago
      Hi Adam.

      Thanks for your response. Date being captured in above revision history is what i want, however in a field callled - Last Uploaded.

      So I basically want this information readily available in the report, rather than opening the form and clicking the revision history.

      Hope this clarifies :)

      Regards,

      ------------------------------
      Ankit Pruthi
      ------------------------------
      • EvanMartinez's avatar
        EvanMartinez
        Quickbase Staff
        6 years ago
        Hi Ankit,

        I have done this before with an Automation set up to edit a "Date File Attachment Uploaded" field every time someone specifically changes the file attachment field. In the Automation I just set it up to copy the Date Modified field over to my Date File Attachment Uploaded field any time the File Attachment field on that record changes. 



        If you want a full history of when that field has been changed you might need to look into an audit table that just tracks the history of a file attachment field changes but this simple version will give you the last date the file attachment field specifically was changed so long as you include that in your trigger. I hope that suggestion is helpful.

        ------------------------------
        Evan Martinez
        Community Marketing Manager
        Quick Base
        ------------------------------