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.

Script to Perform Find and Omit records that have a checked check box

Featured Replies

  • Newbies

I am out of ideas! :o I have a layout that performs a find of only requests for a certain day. But I want this find to omit the records that have a certain field checked. I named this field "semester request". In other words, this field is a check box and if the box is checked in the record, I want to omit the record from the find.

For this step of the script, I tried to put Perform find and then in Specify find, first action is Date Needed [//today's date] then next action is omit records [semester request] and criteria is @ (one character). This didn't work. I can't think of another way to indicate the criteria to omit a checked check box.

I also tried adding a script under the Found Sets using Omit Multiple Records, but it requires a number (the calculation must yeild a number?) so this didn't work. Maybe there's a calculation I don't know here.

Hope this makes sense! Thanks for your help and reply! ;)

What is the value list attached to the checkbox field?

  • Author
  • Newbies

The value is a custom value, with actually only one value called "Semester Request". I am thinking I need to figure out how to set a field to select check box or radio button.

Many Thanks! :qwery:

Well, "Semester Request" is more than one character, which is what you were looking for. So either look for "Semester Request" specifically, or use the "*" wildcard.

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.