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.

Deleting Omitted Found Set

Featured Replies

  • Newbies

I need help to be able to delete the first fixed number of records in a found set. For Example I have a total of 70,000 records. When I do a find on a certain field it displays a found set of 6,000 records. I need to be able to delete the first 500 records in this found set of 6,000. When I used the 'Omit Multiple' and enter 500 it omits the first 500 records of my found set but when I select to 'Show Omitted Only' it then show the 500 records I want to delete AND the other 64,000 records that I do not want to delete.

Does anyone know how I can just delete the first 500 records in a found set efficiently as possible as I need to do this procedure over and over again many times.

Thanks, Steven

Try going to record number 501 and omitting 5,500 records, or rather Get (FoundCount) - 500.

Go to Record [501]

Omit Multiple Records [Get ( FoundCount ) - 500]

*Edit sorry Michael didnt see your reply.

Edited by Guest

  • Author
  • Newbies

Thank you so much for your help!

It was so obvious...

Thanks, Steven

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.