Skip 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.

Doing a "drill-down" calculation

Featured Replies

I'm trying to build a "drill-down" system in FileMaker and I've run into a wall.

Table "Fonts" has a portal pointing to table "Keywords", which in turn has a field called "Keyword Count" that, via a self-assigned relationship, counts how many times a given keyword is used. When I look at my layout in "Fonts" I see the keyword (e.g., "industrial") followed by a number; the number indicates how many fonts have this keyword attached to it. Any given font can have any number of keywords. That part works fine.

I wrote a script that, when you click on a keyword in the "Fonts" layout, omits any fonts that don't have that keyword attached. That part also works fine.

What I need to have happen is that number needs to dynamically change with the criteria. For example, let's say there are 200 fonts, of which 100 fonts have the keyword "industrial" and out of those 20 also have the keyword "deco". I first click "industrial" which reduces my found set to 100. I then click "deco" which reduces my found set to 20 - but the number next to "industrial" still reads 100. I need it to reflect not the total number of fonts with that keyword, but rather the total number of fonts with that keyword in the found set.

I've been experimenting with all manner of calculations and it never quite works the way I need it to. What's the best way to get this done?

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

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.