Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
5 years ago

Extract any information from file field

I am looking to extract any information from the file field. Ideally, it would be the size, but I'll even take the number of revisions. I can perform a work around with that info, but the real hero move is to tell me size of the file attachment, using a formula field.

------------------------------
Mike Tamoush
------------------------------
File attachments
  • EvanMartinez's avatar
    EvanMartinez
    Quickbase Staff
    5 years ago
    Hi Mike,

    Is this information you need right on the record to be available dynamically or is this more information you want to be able to pull from time to time? Currently our formula fields do not support pulling out data on the size of a file attachment field or its version unfortunately. A lot of that information is available in your app settings under the App Management header. There is an option to 'Manage file attachments' and under that you can pick a specific table and get a list of all file attachments in the table including which record they are related to, their size, what version they are and if they are the current version being used. 
    In the past when someone needed help auditing their existing file attachments we exported this list, filtered it down to just the records with a current version and imported it into the table to get them the current version, size, and date created so they could then audit it. You just want to be sure you use the Record ID field to match them up to the right record in your app (if you use a custom key field you just need to make sure to indicate you want record id as the match when you do the import). I hope that information is helpful as a for now option.

    If being able to access this info via the formula functions would be helpful I would suggest adding that as feedback on our User voice. User Voice is a tool used by our product team to track customer interest in new features and enhancements to existing features in Quick Base. The Quick Base User voice can most easily be accessed from the My Apps page in Quick Base by clicking on the orange Feedback tab that appears on the right of the page or at http://quickbase.uservoice.com by signing in with your Quick Base credentials. If you do submit that feedback I would suggest adding a link back to it here so that other users can add their vote as well. 


    ------------------------------
    Evan Martinez
    Community Marketing Manager
    Quick Base
    ------------------------------
    • MichaelTamoush's avatar
      MichaelTamoush
      Qrew Captain
      5 years ago
      Thanks Evan. This is something I need for a more dynamic purpose.

      I use Juiced Add On to resize images. However, I need a trigger to let me known that the file has been resized. I thoght that this could be looking at the file size (which is confirmed not possible), but I thought I could even get away with seeing if there was more than one version, or if anything else changed that I could use as a trigger.  Seems like my best bet might have to be using formulas or dynamic rules to log modified times when the file link changes and start comparing those. I was hoping for something simpler.

      ------------------------------
      Mike Tamoush
      ------------------------------