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.

Count of Blanks

aguest
in Script Workspace and Script Triggers

Featured Replies

I was just wondering if there was a way of getting filemaker to count blanks. I've got a GRade field, which for some reason hasn't been popluated in all instances (Although I've not forced it to before saving record). I want to be able to count the number of blank records but filemaker won't seem to do this for me.

As you can see from screen shot I've writen a simple SQL statement which is returning an array, the first row of which I would expect to see 3 instead of 0 as there are 3 blank records in the time period been checked.

Any help greatly appreciated.

ExecuteSQL.png

Have you tried doing a find for blank fields? 

Enter find mode, enter the equal sign = into the field

Perform Find.

This should give you all records that are blank in that field.

 

I was just wondering if there was a way of getting filemaker to count blanks.

​Count records, rather than potentially empty fields; i.e. COUNT ( * ) instead of COUNT ( Grade ) 

    •
    • Like 1

    Create an account or sign in to comment

    https://fmforums.com/topic/97247-count-of-blanks/
    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.