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.

select random records from a find

Featured Replies

Our company tracks TV programs. Each record has information like show name; producer; distributor; assessment notes. There are created date and modified date fields. Sometimes we only have show names to start with and only pass this show information on to clients when all the information is complete (exported to a PDF as they don't use FileMaker). There are hundreds of shows and I want to be able to select them based on 2 found sets. 1. the most recently created AND the most recently modified. (I have no problem doing this.) 2. Manually de-selecting some records from this set (this is my problem). I created a single check box for each record (which I did using a single box from a value list) then did a new find for just those records that were checked, till I realised that this changes the modication date for future searches.

and ... ?

Which is the question ?

  • Author

Sorry I wasn't clear.

My question is how to manually de-select or select some records from a found set. For example like choosing random items from a shopping list.

I got confused by your use of the term 'random', which has a very specific meaning in Filemaker (and in computing in general). Choosing random items is NOT the same as choosing items at random.

Anyway, I believe this should answer your question. Note that all these commands can be assigned to buttons as individual steps or included in a script.

  • Author

Thanks comment. I've had the honor of seeing your work in these forums.Your solution was perfect. I kept thinking it was a complicated solution when it was a tool already built into FM menus.

Create an account or sign in to comment

Important Information

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

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.