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.

Passed Date Portal Filter

falkaholic
in Portals

Featured Replies

Hi,

I'm trying the make a portal that only shows tour dates to come, and hide passed ones. For example, if a band is having a tour date on 07/16/03, it will show in the portal, once 7/16/03 passes, so will the row in the portal.

The problem is, there is no way to have a relation with dates you can't index. Since there child records have to be static dates and not calculations. As well, tour dates could be a year or more in the future, so having a calc in the parent file of a long date range in the only way I can figure this - and I don't like that way tongue.gif

Anyone else got ideas?

The must read for date ranges is:

http://www.onegasoft.com

The best i've seen in the last 4 years.

With the calculations developed from Mr. Edoshin your problem is solved.

The attached files solves this problem.

Only thing that you have to implement is update of todaydate field in Master (tourTest) file:

Thru triggered calculation or with scripts (when accessing the portal layout, or at opening of db etc.)

Dj

falkaholic .zip

  • Author

Cool. Thanks alot.

I still have to get my head around how it works and implentment it.

Thanks again.

Create an account or sign in to comment

https://fmforums.com/topic/18299-passed-date-portal-filter/
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.