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.

search for non-blanks

BetterDayz
in Script Workspace and Script Triggers

Featured Replies

Hi there,

This is probabbly an extremely basic question but I've been at it for the longest time. How would one make a script to search for for fields that aren't blank? Basically, I have a database with records of shot numbers. I want to do a search for completed shots. Those completed shots would have the completion date in the completion field instead of having a blank field.

Any help would be appreciated.

Thanks

In "Find" mode, put an = equal sign in the field of choice and click the "Omit" checkbox. this will find all records that are blank in that field and then omit them, leaving you with all records with entry in the field.

HTH

Lee

smile.gif

You can also put in ">0" in the field. This will work on text and number fields. It won't work on date or time fields.

Create an account or sign in to comment
Go to topic listing

Important Information

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

I accept

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.