Jump 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.

FIND on container fields

DonH
in Finding & Searching

Featured Replies

Is it possible to do a FIND on a container field JUST to see if there is something in it? Or maybe looping over the entire database and some type of check to see if there is anything in the container field.

You will need to do a baloon calculation on the field and do a find on it.

your calculation would look like this:

Case(Image of File=0,"No", "Yes")

Note: Image of File is your container file name.

HTH

Lee

  • Author

Case? Hmmmm. Looking looking. In FM6 where is that?

create a new field, make it a calculation, use the calculation modified as stated previously, and then make the results of the calculation "text".

HTH

Lee

Hi Don,

I believe that a calculation (number) with not IsEmpty(Container) may be a TAD more efficient when searching through large-record databases. Then you would just Find on this calculation field for a 1. I may be wrong though. crazy.gif

LaRetta

  • Author

Ahhh okay. I was doing it in the script. A calculation field sounds much easier.

Baloon? mad.gif Ah, you mean Boolean! shocked.gif

Poor George must have just rolled over in his grave. wink.gif

Back off

  • 2 weeks later...
  • Author

Baloon calculations are for floating numbers. smile.gif

Create an account or sign in to comment

https://fmforums.com/topic/19109-find-on-container-fields/
Go to topic listing

Important Information

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

I accept

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.