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.

Suppress No Records Found message

Featured Replies

This is going to seem very trivial, but my users have asked for it, so here goes:

I have an opening script that searches for duplicate or incomplete records. Most of the time there are no records to correct.

Is there a way to suppress the "No Records Found" message, and just exit the script if there are no records to display?

Use Set Error Capture On before the Find.

Use If [ get (foundcount)=0]

in your script to probably Go to a Layout.

  • 3 weeks later...

I have a script that does exactly this and works well.

Our situation requires it to go a step further in that it creates a new record once it arrives at the new layout.

What I'd really like it to do is even one more step and set two fields of that new record with the data entered into those fields in the original find request.

Any thoughts?

You'd need to capture their search criteria. One way is to have them enter criteria in global fields. Then the Find button would run a script that enters find mode, sets the fields to the globals, and performs find. If no recs are found, go to layout, new record and use set field to set the desired fields to the globals.

  • 2 weeks later...

That's what I've been trying but I must have a flaw in my logic because I've spent hours on this now and just can't make it work.

I hate asking for someone to do the work for me but is there an example script you can show me?

  • Author

Here you go

?

  • Author

Sorry for that - User Name is John, and no password is necessary

  • Author

Even more embarrassing Password is Gracie!

Thanks, I got there in the end but this is nice and elegant and helps a lot.

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.