Our Preferred 5 Star Hosting Provider - Award Winning FileMaker Pro Hosting
Results 1 to 3 of 3
  1. #1
    Forum Member
    Join Date
    Mar 2012
    Posts
    14
    Location
    Memphis, TN USA
    FileMaker Pro Software
    FMPA 16 FMS 16
    OS
    Mac
    Skill Level
    Intermediate
    Last Post
    06-03-2017
    Local Date
    07-28-2017
    Local Time
    01:48 PM
    Last Active
    06-03-2017

    Using global to set date range for portal filtering

    I'm using a portal to display records with dates in a range. I'm attempting to use a global to set the number of days in the range. If I filter using this formula:


    Dashboard_Calendar::calDate > Get ( CurrentDate )
    and
    Dashboard_Calendar::calDate ≤ Get ( CurrentDate ) + 3


    the portal correctly shows all events dated in the next three days.


    But if I try to use the global instead of the hard-coded number, like this:


    Dashboard_Calendar::calDate > Get ( CurrentDate )
    and
    Dashboard_Calendar::calDate ≤ Get ( CurrentDate ) + Dashboard_Calendar::calDateNextXDays


    it does nothing.


    What am I doing wrong?

    Thanks.

  2. #2
    FMT Preferred FileMaker Consultant - Trainer jaymo67's Avatar
    Join Date
    Sep 2014
    Posts
    75
    Location
    Chino Hills, CA
    FileMaker Pro Software
    FileMaker 15 Advanced
    OS
    Mac
    Skill Level
    Developer
    Last Post
    07-18-2017
    Local Date
    07-28-2017
    Local Time
    11:48 AM
    Last Active
    07-18-2017
    Most likely you need to add a script trigger with a Refresh Window script step to run each time you change the global field. To test this theory, try running your current script and then manually choose Refresh Window from the Records menu. If this updates your portal then attach a script with Refresh Window to the modification of your global field.
    FileMaker Developer for over two decades. Certified in FileMaker 7, 8, 9, 10, 11, 12, 13, 14 and 15.

  3. #3
    Forum Member
    Join Date
    Mar 2012
    Posts
    14
    Location
    Memphis, TN USA
    FileMaker Pro Software
    FMPA 16 FMS 16
    OS
    Mac
    Skill Level
    Intermediate
    Last Post
    06-03-2017
    Local Date
    07-28-2017
    Local Time
    01:48 PM
    Last Active
    06-03-2017
    There was no script. Just the relationship. But refreshing the window did it. So I'll add the trigger. Thanks very much for your help.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Portal filtering with global value. Two sets of Parentheses won't work
    By Woodeye in forum FileMaker Pro 12 - All versions
    Replies: 5
    Last Post: 04-02-2013, 09:34 PM
  2. Date filtering in Portal
    By dsloane in forum FileMaker Pro 12 - All versions
    Replies: 2
    Last Post: 12-16-2012, 02:21 PM
  3. Filtering portal data set without the use of a global match field
    By kirkrr in forum Portal & Relationships
    Replies: 1
    Last Post: 01-05-2011, 04:08 AM
  4. Filtering a portal via a global field - SUPER slow?
    By beju0506 in forum FileMaker Pro 9
    Replies: 5
    Last Post: 02-19-2008, 01:58 PM
  5. Portal Filtering in Date Ranges
    By Falco in forum Portal & Relationships
    Replies: 2
    Last Post: 08-22-2003, 08:49 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Welcome to the Original FileMaker Forum
With designated forums for almost every FileMaker topic...FileMaker Today is a FREE to join community where you can boost your FileMaker expertise, build better apps & solutions and interact with over 42,000+ FileMaker Developers from all over the world. If you're building FileMaker solutions, this is the place for you.
Follow FMT
We Are FMT
FMT is home of The World's leading FileMaker News Site, Worldwide Developer Directory, FileMaker Connect Community and so much more.