Skip to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Record Size & Container Field

Featured Replies

Hi there.

This question either has no answer or is so simple I will look foolish.

I have client with a Filemaker 7 database who records artwork in container fields. The database is now around 2GB in size yet there are not that many records.

Is there any way that I can determine the size of an image in a container field? I would have thought that the size if the displayed field may have had some bearing on it, but unsure.

I want to be able to flag fields with images that need reduction so we can trim the database down a bit.

Or... does FmPro not work like this with variable record sizes.

Enlighten me please. :(

Greg

Have you considered using image references? Also, they should immediately upgrade from the much-troubled FM7.

i don't recall if FP7 has the length function but that's what you need to do.

Create a calculation field Length (containerfield)

This gives you size of the container field in bytes. Do Length(containerfield)/1024 for kilobytes

:(

  • Author

Thank you both. I will look into these options.

Cheers,

Greg

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.