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.

Help with search (find) using a calculation

  •
Nakizimbo
in Finding & Searching

Featured Replies

Okay, calculations are not my strength and I am struggling with soemthing which I believe shoudl be relatively simple. I have a searchable  field which will always contain a one or two digit number.  For example, if I want to search for all records containing a number between 0 and 4 I can do this by entering "<5" in the search box.  However, because of the nature of my database I do not want my user to have to enter "<5" into the search box but I simply want him to be able to enter "5" which then becomes calculated as <5 so as to bring up all records with 0, 1, 2, 3, or 4.  If I can do this within my "show custom dialogue Script" that would be great or can it be done as a calculation in autoenter ?  any help appreciated.

Add to your script right after the Custom Dialog step and before the Perform Find step:

 

Set Field[YourTable::YourField; "<" & YourField]

  • Author

Thank you very much. Works perfect.

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.