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.

Finding number of characters in field

tiepolo
in Finding & Searching

Featured Replies

  • Newbies

Hello all. I'm a complete newbie to Filemaker so this question may be a stupid one. I could not find the answer in the Filemaker Help, so I'm asking here. I need to find all records that exceed a specific amount of characters. For instance, I would like to find all records that have more than 15 characters in the "name" field. Is this possible? If so, how do I go about doing this find? Thanks in advance for the help.

Hi, welcome to FM Forums! :wink2:

Create a calculation (number) with:

Length ( nameField ) > 15

Perform a Find on this calculation for a 1. This calc produces a boolean result 1 for yes and 0 for no.

Your script step would be:

Perform Find [ ] ... Find Request criteria would be, select field and just type: 1 ... and ADD.

LaRetta

Edited by Guest
Added pseudo script-step

  • Author
  • Newbies

That worked perfectly! Thanks so much for the tip.

Create an account or sign in to comment

https://fmforums.com/topic/45413-finding-number-of-characters-in-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.