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.

Comparing 2 fields in find

Featured Replies

I have an unusual find that i need to perform and i'm not quite sure how to perform it.

a little background. We converted our old system to filemaker rouhgly 2 months ago. The old system contained one big text field for each record that contained the notes. It also contained a date field for when the record was created.

When i did the export from the old software, for some reason on a few records it did not export all of the notes. So far i have only found a few records but am unsure if there are more.

Since 99% of the time there was a note entered the same day the record was created, what i would like to do is:

Perform a find on the text field to see if it does not contain the date field.

Hope this makes sense

No calculations are performed during find. You need to use either a calculation field or a looping script.

  • Author

I'm pretty sure that i'm not doing the right steps but here is what i was attempting.

The date field is actually a timestamp field so here is my script:

(note that =/ stands for does not equal sign)


Set Variable [$Start; Value:Left (datefield; 10)

Enter Find Mode []

Set Field [textfield; =/ $Start]

Perform Find []

Am i way of or on the right track?

The ≠ sign is not a valid find operator. You could find records that equal the value in the variable and omit them - but the value is going to be the SAME for ALL records. IIUC, that's not what you want.

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

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.