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.

Perform find with variable and quotations

  •
innodat
in Finding & Searching

Featured Replies

I need to search for an email address in my database. As you know the address needs to be enclosed in "...", like "[email protected]", for it to return any search results.

I need to execute that find with the help of a variable:

Enter Find Mode

Set field ($EmailAddress)

Perform Find

How can I get the quotations to be part of the variable? Or inserted the moment the variable is used for searching?

You need to use the (back slash) character BEFORE the " (quote character) to allow FM to interpret the " as a piece of text and not a directive as it normally would. You also need to enclose this inside ""

Set $var: """

  • Author

You saved my day, thank you!

As you know the address needs to be enclosed in "...", like "[email protected]", for it to return any search results.

No, I don't know that. I believe it's enough to escape the @ character, so that it doesn't act as a find operator.

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

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.