Typically, portals in FileMaker are used for showing related data. However, a portal based on the same table as its layout would simply display the current found set. If you made the portal large enough, the layout would appear as a list view- which wouldn’t be very helpful. So, in this blog, we will make the portal smaller and create a powerful layout design, the Master Detail portal.

If data requires or if users request more data in the “list view”, I’d recommend using a slide control that displays the Found Set portal at full width- creating a list view feel, while still remaining on the same layout.

Position the second portal so it matches the original, and make sure the height is the same. The button, circled in red, simply needs to switch panels. But as far as the user can tell, the button expands/collapses the portals width, and shows more/less fields. It is a very user-friendly, and professional look.

Found Set Portal

The ‘Person’ portal will match the found set and clicking on a portal record will navigate to that record’s Form View record. That’s right- no scripting required, clicking the record will make that record active, the same way a list view layout behaves. This layout structure allows users to glance at the multiple records shown in the found set while having the ability to quickly navigate to view specific details. This concept removes the need to switch layouts between form and list view.

Something you will notice about using the Current Found Set portal is that the standard options, like sorting and filtering, are disabled. Since the portal only displays records of the found set, those functionalities will have to be handled on that level- through scripting or the FileMaker Menu.

Performing Finds

Typically, in portals, I use Merge fields and/or calculations to display “detail” data. I think it looks nice, as well as prevents accidental data modification. The downside to that is it could remove some capabilities within ‘Find Mode’. For example, say the user wants to perform the most basic of Finds: Search by a Person’s last name. If you look back at the first picture of this blog, you’ll see there is no actual field for Last Name.

The data’s there- it’s included in the <<description>> calculation in the Master portal, as well as the <<nameFull>> calculation in the title. However, if a user enters Find mode, the merge fields disappear, and the user may not be able to perform the simple find. I recommend creating at least 1 of 2 design techniques.

The first technique is a Search box that uses triggers to script finds from browse mode. I’d also recommend that the triggered script utilizes the script step: Perform Quick Find, that way your search box can search the data of multiple fields.

The second technique or option is similar to the slide control we set up for the “expanded” Master portal earlier. You could make an additional panel; with all the fields a user would want to search by in their most basic form. Then use an OnModeEnter script trigger to take the user to that panel when they enter find mode.

Hopefully, this blog has provided you with enough information to give the master detail concept a try. Sometimes a regular list view is still better, depending on the functionalities provided to users, but the master detail concept allows for the data modification capabilities of a detail view while allowing a glance into other records of the found set, the way a list view would.

40 comments

  1. Ryan, is the Found set portal you discuss on your Blog available for download?

    Posted by ashley colburn on March 24, 2021.

  2. best slot machines to play at the casino
    scatter slots topless
    grand casino slots

    Posted by AurlieOaot on July 8, 2022.

  3. thesis defense
    how do i write a dissertation
    writing a proposal for your dissertation

    Posted by ShaynaOaot on July 14, 2022.

  4. dissertation editing services
    help with dissertation writing
    defending dissertation

    Posted by JoeteOaot on July 15, 2022.

  5. sample dissertation
    dissertation writing assistance
    phd dissertation help proposal

    Posted by JoeteOaot on July 18, 2022.

  6. dissertation consulting
    write my dissertation
    phd without dissertation

    Posted by ChandaOaot on July 20, 2022.

  7. law dissertation writing service
    dissertation example
    dissertation service

    Posted by AvivaOaot on July 21, 2022.

  8. doctoral dissertation help thesis
    dissertation database
    writing dissertation

    Posted by DortheaOaot on July 21, 2022.

  9. writing a masters dissertation
    dissertation writing services uk
    creative writing lindenberg

    Posted by VerieeOaot on July 22, 2022.

  10. dissertation abstracts international
    ucl dissertation help
    dissertation paper writing service

    Posted by GlynnisOaot on July 23, 2022.

  11. psychology dissertation
    writing editing service
    +writing help

    Posted by SuzannOaot on July 24, 2022.

  12. mba dissertation writing services
    master dissertation
    free dissertation help

    Posted by SalliOaot on July 25, 2022.

  13. no deposit sign up bonus
    casino bonus online
    best online casino deposit bonuses

    Posted by TandiOaot on July 25, 2022.

  14. rutgers dissertation proposal help
    phd dissertation writing help
    writing services

    Posted by DarsieOaot on July 26, 2022.

  15. mathematics dissertation help
    buy dissertation online
    dissertation meaning

    Posted by MabelleOaot on July 26, 2022.

  16. wild casino online
    real money casino
    best casino online usa

    Posted by TandiOaot on July 26, 2022.

  17. cheap dissertation writing services
    how to write a dissertation proposal
    dissertation assistance

    Posted by JenneeOaot on July 27, 2022.

  18. us online casinos
    online casinos real money no deposit
    online casino no deposit welcome bonus

    Posted by AbagaelOaot on July 28, 2022.

  19. dissertation literature review
    order a dissertation
    masters dissertation help

    Posted by HerminaOaot on July 28, 2022.

  20. more casino games
    deposit bonus casino
    best online casino bonus

    Posted by ShaylaOaot on July 28, 2022.

  21. dissertation handbook
    dissertation proposal sample
    help dissertation

    Posted by AudreOaot on July 29, 2022.

  22. best online casino to win money
    casino sign up bonus
    online casino no deposit welcome bonus

    Posted by VerenaOaot on July 29, 2022.

  23. dissertation writing fellowships
    custom dissertation writing
    dissertation writing guide

    Posted by HestiaOaot on July 30, 2022.

  24. casino online real money usa
    online bingo real money
    online casino free signup bonus no deposit required

    Posted by DixieOaot on July 30, 2022.

  25. casino deposit bonuses
    sign up casino bonus
    usa casinos on line

    Posted by LaureenOaot on July 31, 2022.

  26. online mobile casinos
    welcome bonus casino
    casino games for money

    Posted by FranniOaot on August 1, 2022.

  27. online casinos us
    casinos online real money
    free no deposit bonus

    Posted by PearlOaot on August 2, 2022.

  28. us casino
    free money no deposit casino
    no deposit casino online

    Posted by BobbieOaot on August 3, 2022.

  29. Sağlık Personelleri İçin Üst Öğrenim Sayılan Bölümler 2022.
    tarihli Yükseköğretim Yürütme Kurulu toplantısında lisans tamamlama yapanların bitirdikleri bölümlerin üst öğrenim olup olamayacağı hususu değerlendirilmiş ve Sağlık Yönetimi, Acil Yardım ve Afet Yönetimi,
    Sosyal Hizmet, Biyoloji, Besleme ve.

    Posted by Dovato Hasta Yardım Programları on August 3, 2022.

  30. bonus casino
    welcome bonus casino
    free casino bonus no deposit

    Posted by LeslieOaot on August 4, 2022.

  31. Eczane Rehberi. Eczacı Odasına Kayıt İşlemi İçin İstenen Belgeler Listesi.
    Matbu Form (Beyanname) Eczane Açılışında
    İstenen Belgeler Listesi. Eczane Açılış-Nakil-Devir Yer Raporu Müracaat Formu.
    Eczane Mesul Müdürlüğü İçin Gereken Belgeler Listesi.

    Eczane Devir İşlemleri İçin Gereken Belgeler Listesi.
    Eczane Nakil.

    Posted by Dlaczego fluticasone nie jest dostępna bez recepty on August 5, 2022.

  32. best online casino us
    best online casino welcome bonuses
    no deposit online casino

    Posted by TrudieOaot on August 7, 2022.

  33. free vpn for firestick
    vpn free for pc
    free trial vpn

    Posted by HonorOaot on August 8, 2022.

  34. free cash no deposit casino
    best online casinos for real money
    online slots real money free bonus

    Posted by JaynellOaot on August 8, 2022.

  35. free trial vpn
    vpn client
    chrome vpn

    Posted by TeddieOaot on August 8, 2022.

  36. casino no deposit sign up bonus
    mobile slots
    online blackjack for real money

    Posted by DulceaOaot on August 9, 2022.

  37. free vpn service
    top vpn
    hideme vpn

    Posted by JenneeOaot on August 10, 2022.

  38. best bonus casinos
    casinos online usa
    casino no deposit free bonus

    Posted by CarolanOaot on August 10, 2022.

  39. netflix vpn free
    best canada vpn
    best vpn router

    Posted by JenneeOaot on August 11, 2022.

  40. real online gambling
    casino usa
    best online casino to win money

    Posted by FanyaOaot on August 11, 2022.

Leave a comment

Your email address will not be published.