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.

A question about "finding" records

Featured Replies

  • Newbies

I have a database that has a number field with numbers from 1 through 35. If I want to select the records with numbers 1, 5, 32, is there an easy way to do it....instead of multiple requests? Please help! Thanks....

Not easy, no. Sorry. But the difficult way may be worth it for you. Why do you not want to enter multiple requests?

Jerry

I wonder what he means by multiple requests. He might mean, enter find mode, find the "1" records. Enter find mode again. Find "5" records. Enter find mode again. Find "32" records.

Dale, do you understand that you can create multple request before performing the find? Enter find mode, enter 1 in search field. New request; enter 5; new request; enter 32. Now perform find.

Also, you could use a global field, a checkbox and a relaltionship to show all the records in a portal.

I'm wondering if there isn't something else these records have in common that the find could be based on, that would return these records 1, 5, and 32?

Lee

  • 1 month later...
  • Newbies

This is a little late (only here when I need help), but...if you want to find those exact numbers all of the time, why not another field (calculated field--If(yourfield=1 or yourfield =5 or yourfield=32, "x", ""). Then you could find on the new field (find new field=x) or create a script that will do it.

Another way would be to make a "Dummy" find. Enter find mode (find 1), and without entering anything in any of the fields, control N for new request (find 2), control n for new request (find 3). Do this for as many finds as you'd like. Then create a script that would be to restore the find. When you perform the script you would be taken to find mode with three (or your number of finds) blank find request. You could then enter your numbers to find.

Create an account or sign in to comment

Important Information

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

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.