Our Preferred 5 Star Hosting Provider - Award Winning FileMaker Pro Hosting
Results 1 to 3 of 3
  1. #1
    Forum Member
    Join Date
    Aug 2014
    Posts
    2
    Location
    Canada
    FileMaker Pro Software
    FileMaker Pro 16 Advanced / Go
    OS
    Mac
    Skill Level
    Intermediate
    Last Post
    09-08-2017
    Local Date
    09-20-2017
    Local Time
    10:52 AM
    Last Active
    09-08-2017

    Hidden Summary Field still being calculated on FM Go

    Hi,

    First, I'm using the latest versions of FM Go 16 and FM Advanced 16.

    I have hidden summary fields (based on which users are logged in) that work well on the Mac version of FileMaker but it's giving me issues on FM Go. I basically set a Global Variable to "hide" when a specific user group logs in (it's part of my launch script). As expected, on the Mac, when the user goes to this layout, the layout loads instantly and the summary fields are hidden. When I do the same thing with FM Go on my iPad (same layout, same user...) it forces the Summary fields to be calculated, however, the fields are in fact hidden once the calculation is done. Because of the nature of this calculation, it's extremely slow to summarize (hence I why I hide it for this user group).

    So, why would a hidden field work fine and not summarize when hidden on the Mac version but on iPad with the same layout and user it summarizes (very slowly) even if the fields are in fact hidden even after it summarizes.

    Thanks for any suggestions or tips.

    Alex

  2. #2
    FileMaker Mentor
    Join Date
    Aug 2015
    Posts
    99
    Location
    Broomall, PA USA
    FileMaker Pro Software
    FM 16 Advanced
    OS
    Windows
    Skill Level
    Intermediate
    Last Post
    09-19-2017
    Local Date
    09-20-2017
    Local Time
    10:52 AM
    Last Active
    09-20-2017
    My guess would be you can't stop a summary field from summarizing. It's probably doing it on your desktop, but happening so fast you don't see it.
    Try removing the summary field from the layout. If that works, maybe you'll have to create 2 similar layouts, one with, and one without the summary field and navigate appropriately.
    If this is only when the file opens, maybe freeze window and/or go to splash screen of the same table occurrence first. I found things much slower on Go, and have to strip down layouts to make things go faster. Especially type aheads and portal filters tend to bog down on Go vs. Pro.
    Last edited by Steve Martino; 09-08-2017 at 11:30 AM. Reason: typo

  3. #3
    Forum Member
    Join Date
    Aug 2014
    Posts
    2
    Location
    Canada
    FileMaker Pro Software
    FileMaker Pro 16 Advanced / Go
    OS
    Mac
    Skill Level
    Intermediate
    Last Post
    09-08-2017
    Local Date
    09-20-2017
    Local Time
    10:52 AM
    Last Active
    09-08-2017
    I know the desktop isn't summarizing it because I have a toggle to "unhide" the summary fields and when I do, the summarize calculation starts and takes a few minutes to complete (both on iPad and desktop). On the iPad, it does the long calculation regardless and when it's done the fields are still hidden unless I toggle to "unhide" using a button I created. So even though FileMaker isn't supposed to calculate a hidden summary field, it's doing it on iPad but not on desktop.

    Basically, regular users only have about 50 records and I want them to see the Summary fields (the summarization happens nearly instantly for them) but admin users have 3,600+ records and by default, I want the summary fields hidden unless the admin user toggles from hidden to un-hide/show.

    I ended up using a slide panel and by default it displays an empty panel if the user group is "admin" and then the "unhide/show" toggle displays the panel with the Summary fields which then also triggers the long calculation process (which is what I want). For regular users, it simply displays the panel with the summary fields.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Summary and Calculated field results to another table
    By Michelle Wagner in forum FileMaker Pro 12 - All versions
    Replies: 14
    Last Post: 08-21-2012, 11:02 AM
  2. Calculated Fields in reports. Not summary or totals...
    By mlprice in forum Calculations and Define Fields
    Replies: 3
    Last Post: 05-14-2009, 10:02 AM
  3. Calculated summary field involving a value list
    By macnificent in forum FileMaker Pro Versions 5 & 6
    Replies: 1
    Last Post: 05-31-2002, 02:44 PM
  4. Help! Calculated field Total of summary field giving incorrect result. Help!!!
    By ecpmII in forum Calculations and Define Fields
    Replies: 2
    Last Post: 03-15-2002, 06:03 PM
  5. Help! Calculated field Total of summary field giving incorrect result.
    By ecpmII in forum FileMaker Pro Versions 5 & 6
    Replies: 2
    Last Post: 03-08-2002, 02:47 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.