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

Tap the Share icon in Safari
Scroll the menu and tap Add to Home Screen.
Tap Add in the top-right corner.

To install this app on Android

Tap the 3-dot menu (⋮) in the top-right corner of the browser.
Tap Add to Home screen or Install app.
Confirm by tapping Install.

FMForums.com

Sign In

Email Address

Password

Remember me
Not recommended on shared computers

Forgot your password?

Or sign in with...
Sign Up

Calcuation based on portal value

Followers

August 3, 200619 yr

I am trying to write a calculation for a field that will compare a fixed date to a list of dates within a portal. If any of the portal lines has the fixed date then the script should return a value of "Yes." Within the portal the fixed date will never occur more than once per record.

This is what I've come up with, but it is only returning yes if there is only one entry in the portal and the entry matches the fixed date:

If( MultiplayerInServiceDate = Dates_Titles::AirDate;"Yes";"")

where MultiplayerInServiceDate is fixed and Dates_Titles::AirDate is the field within the portal.

The actual portal is in a layout that is based on the Titles table, not the Dates table.

I'm using FMP 8.03 on WinXP.

Thanks!