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.

Match a word to another table's contents?

VodooMD
in Calculation Engine (Define Fields)

Featured Replies

  • Newbies

Hey guys,

I'm relatively new to Filemaker, so I'd greatly appreciate any help:

I have a table called 'Articles' with about 2000 records of publications with a field that contains addresses. Those addresses have within them the country name, although not always in the same place. I also have another table with the names of every country. I would like to be able to perform a count of the Articles that were written in each country. (Eg: 'Canada = 13 articles, Ireland = 4 articles and so on) by seeing if any of the countries in the 'Countries' table is a match anywhere in the address field for all the 'Article' table records.

Could anyone point me in the right direction? Thanks a lot!

Simon Rascovsky MD, M.Sc

Simply define an relationship from "Countries" table to "Articles" table country-->address.

Then create an calculation field (in Countries table)

Count(TheAboveRelName::nameOfSomeNonEmptyFieldInArticlesTable)

Dj

Create an account or sign in to comment

https://fmforums.com/topic/26899-match-a-word-to-another-tables-contents/
Go to topic listing

Important Information

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

I accept

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.