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.

FM Server and Enter FInd Mode / Perform Find Mode--script fails

Rich S
in Script Workspace and Script Triggers

Featured Replies

We're running FM Server 19.5.1.43 with a hosted file that I set up to run as a scheduled script that would send e-mails to people notifying them that their certificate or license needs renewing. However, it fails every time it runs. As a troubleshooting step, I disabled all the script steps, created a new one with a Perform Find on  CertExpiration__lxd field (with * as the operator), and attempted to run the script again from the server. It failed again.

According to the Help documentation, Perform Find should execute without problems but upon looking at Enter Find Mode in Help, it's only partially supported by the server; it doesn't say why it's only partially supported nor any alternatives to use because it's not fully executable.

Is there a kernel of knowledge or workarounds I can use? TIA for your help!

Screen Shot 2022-07-15 at 10.27.37 AM.png

  • Author

Here ya go:

 

2022-07-15 11:10:23.967 -0500    Information    146    fmp19    Schedule "Cert_License_Expiration_Notice" run now by "esu7".
2022-07-15 11:10:23.967 -0500    Information    689    fmp19    Schedule "Cert_License_Expiration_Notice" has started FileMaker script "E-mail Notification that Certificate/License is up for Renewal".
2022-07-15 11:10:24.138 -0500    Information    645    fmp19    Schedule "Cert_License_Expiration_Notice" scripting error (103) at "ESU7CRM : E-mail Notification that Certificate/License is up for Renewal : 25 : Perform Find".
2022-07-15 11:10:24.154 -0500    Information    645    fmp19    Schedule "Cert_License_Expiration_Notice" scripting error (101) at "ESU7CRM : E-mail Notification that Certificate/License is up for Renewal : 45 : Go to Record/Request/Page".
2022-07-15 11:10:24.170 -0500    Information    644    fmp19    Schedule "Cert_License_Expiration_Notice" completed; last scripting error (101).
2022-07-15 11:10:24.170 -0500    Information    126    fmp19    Schedule "Cert_License_Expiration_Notice" scheduled for 07/16/2022 06:00 AM.

One quick one to reduce errors is on line 44 (above go to record next )  add this step, it will remove the 101 errors. 

Exit Loop If ( Get(RecordNumber) = Get(FoundCount )  ) 

Error 103 is Relationship Missing you need to go to the correct context so you need to add Go To Layout . 

You may try to delete the Enter Find Mode and Perform Find steps, save the script and re add these and try again.

 

 

  • Author

MANY thanks--it works now.

 

Life is good. : )

Create an account or sign in to comment

https://fmforums.com/topic/109103-fm-server-and-enter-find-mode-perform-find-mode-script-fails/
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.