Skip to main content
Question

Extract any information from file field

  • March 31, 2020
  • 0 replies
  • 34 views
Forum|alt.badge.img+14
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
------------------------------

Forum|alt.badge.img+17
  • EvanMartinez
  • Community Moderator
  • April 1, 2020
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
------------------------------
Terms & ConditionsAccessibility statement