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.

Omit unique values from a found set

Featured Replies

I am trying to omit all individual records (filtering on Name) from a found set of 4 produts, that have to be posted.

So that I am left with all customers who have purchased more than 1 product, allowing me to post them together.

I can get as far as a sorted list, but I have to wade through all the individual orders to find people who have purchased more than 1 product.

I know you can use a ! to find unique records, but only on the entire database.

Any suggestions for scripting this?

Thanks

Daniel

Hi Daniel

Instead of trying to explain this in a language I hardly master, have I made a template for you, showing how I would deal with the matter. What I exploit here, is reporting and the new "Match Found Set" feature arriving with FM8's GTRR.

--sd

Invoicing.zip

  • Author

Soren,

Taken me ages to get my head round this but thanks to you your example I am finally there.

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.