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.

Find doesnt work on email field

saad
in Finding & Searching

Featured Replies

  • Newbies

Hi,

I have a database in filemaker 8.5 which contains customer record. Email is a text field and contains customer email address but when I try to search on email field (from filemaker ->going in to find mode), it doesnt bring any result, however there are records matching the typed email address. If i remove the @ sign from email and search then it brings the matching result.

Can any one please tell me the reason for this and how i can fix this.

thanks

This has been mentioned before, abd it's confounded quite a few people.

Since the dawn of time "@" has been used as a wildcard character in searches. That's why finds in e-mail fields don't work as expected.

The solution is to tell FileMaker NOT to use @ as a wildcard: this is done by enclosing it in quotes, making it into literal text.

It's easier quoting the whole address.

"[email protected]"

  • Author
  • Newbies

Thanks alot that solved the problem.

Create an account or sign in to comment

https://fmforums.com/topic/54037-find-doesnt-work-on-email-field/
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.