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.

Find in a Portal Field

jimpres
in Portals

Featured Replies

I have two files. Sites and Letters. The site file has fields with computer information in the fields. There is a Site Name field, System Type field, MaintExDate and a Computer Serial Number field. On site or "Site Name' could have 12 records (12 computers at that site).

The Letters file has a portal in it that has the related System Type, Compuer Serial and MaintExDate in it. The relationship is based on the unique site names.

So the Letters file displays a Site name and in the portal all the computer systems related to that site.

Based on the maintenance expiration date (MaintExDate) I want to only display in the portal those systems that have or will have in the next three months MaintExDate expired so I can send them a letter. I have tried to search the MaintExDate but if any of the dates are valid all the system serial numbers show up. I also tried omitting the valid dates but then all the records in the portal were omitted.

Is the answer to use a global with the date range in it and then find on the MaintExDate?

All help appreciated...

Create an account or sign in to comment

https://fmforums.com/topic/466-find-in-a-portal-field/
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.