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.

$variable in Find to produce exact Find?

Pat
in Finding & Searching

Featured Replies

I have a script that I am using to do a find where a search term is taken from a join table and put into the search field in the parent table. The search term is put into a $variable which is put into the search field in the Find Mode using Set Field. This is all part of a loop through a series of search variables.

My question is how can I put in the term so that it is an exact search? For example, the desired search term is 'tablet' and tablet gets set into the appropriate field, but the find results include anything with tablet in it (eg tablet, chewable).

I tried

"$variable" ,

"""& $variable & """

and that doesn't work at all.

Any suggestions? Thanks!

Try:

Set Field [ field ; "==" & $variable ]

Create an account or sign in to comment

https://fmforums.com/topic/45812-variable-in-find-to-produce-exact-find/
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.