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.

performing AND request in a repeating field

Featured Replies

  • Newbies

I am not a filemaker developer or very technically savvy with the system, but I need to perform an "AND" request in a repeating field.... but in find mode you are only given one empty field to enter your find text.... Is there any easy way to solve this issue? Is there an "AND" request function or something?

Just as an example: I want to find in a repeating field records that are labeled "Education" AND "Science" , but given that there is only one field to enter information on in find mode I have to perform the find as "Education" then add new request "Science" and then scroll through to find those labled both. There must be an easier way.... please advise if you know.

Just put a space between the two pieces of the request:

Education Science

and only records with both will be returned.

Similarly, you can do the same in a number field:

>=3 <=5

is the same as the bultin:

3...5

!@#$%@&#%&*)(^%%#@!!@$# and bloody hell!

Where were you when I got that warning about "Are you sure your're doing a Find? It looks like you're entering data."?

You are a gem! (I am getting really sick of learning how much I didn't know before this forum.)

Why the bloody hell don't FMP include this sort of stuff somewhere?

I'll check this myself but, so it ends up here, does this work also with scripted Finds?

Yes, scripted finds too.

Looking at the help for FM7, it also doesn't say this, even in the help section for finding with multiple criteria using AND (it only talks about multiple different fields). Thats odd.

In FM7 (at least), you can use newlines to break it up also, which is nice when you want to paste a list from some other app. (You can't type a newline directly, or it will do the find - but paste is okay.)

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.