Skip to main content
Question

Formula to capture most recent file size

Forum|alt.badge.img+14
I've inquired before, and am hoping that in the last year someone has figured this out. Is there any way to have a formula field return the current file size in a file attachment field? The end goal is to tell if an image file has been reduced in size or not, which I can do if I can return the file size....

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

  • AustinK
  • Registered
  • August 24, 2020
I see where you had posted about this previously and even see the thread you posted in. https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=1ffadf07-9840-4550-a49d-c2b3f1dde0fa&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer

These are in JavaScript because afaik this cannot be done in a native way, I don't think. I see you replied to Dan there, is the issue that you need the script adapted to your exact use case? Have you given it a try at all and do you have anything started that can be worked off of?

To make the code in the post you replied to work you will need some changes. That specific code works by looking for a change in a field on the form which sounds different than what you want. Can you describe the exact workflow you expect here? To me it sounds like you need this: The record opens and the script runs and pulls the size of the file attachment, It then compares this size to the size in a field called "File Attachment - Old Size" and if the current value is smaller than that value it marks a checkbox saying the record is complete, if there is no older value it puts the current value into the "File Attachment - Old Size" field. Something like that?
Terms & ConditionsAccessibility statement