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.

script triggered find on calculated key

Featured Replies

I'm so delighted with the simplicity of implementing a mac like find field [find_field] via the "onObjectModify" trigger which invokes a find script [peo_search] ... but when trying to do a find on a calculated field [peo_multikey] calculated as [ fname & lname & company & stnum & stname & city]

the find doesn't reveal all calculated records that contain find string ?

data viewer shows string exists within calculation for each record but it seems to miss some but not all?

script > peo_search ;

Set Error Capture [ On ]

If [ (IsEmpty ( find_field)) ]

Show All Records

Go to Record/Request/Page

[ First ]

Sort Records [ Specified Sort Order:lname; ascending ]

[ Restore; No dialog ]

Exit Script [ ]

End If

Enter Find Mode [ ]

Set Field [peo_multikey; find_field]

Perform Find [ ]

Go to Field [find_field]

Your concatenated field needs returns btw the values. find_field should be a global.

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.