FileMaker Nested Portal

In-Depth FileMaker Relationship Course:

Looking for a FileMaker Developer?

Video Information:
This FileMaker tutorial is going to show you how create a multi-level nested portal.

Skill Level: Advance
Recorded with: FileMaker Pro 17

Exercise File Download:

[mitziperdue]

I feel so lucky that I found this. It solved a huge problem I had for tracking donations to a foundation, that then went to other charities, that then went to individual recipients. I had spent hours getting nowhere. Now my beautiful database works gorgeously. Sunny, you're my hero! You rescued a lady in distress!! And besides, you explain everything so clearly.

[thesheeplelookup]

THank You so much, very well explained. ANd it is a simple easy to understand solution, some i found were way too complex for what i needed.

[trevorradebe]

Thank you so much...I've been searching the net for a while trying to find a solution to this. Beautifully done...thanks man!

[siputurbo]

from 0 in database system, for now i can create my own system. thanks sunny.

[inajohansson]

You saved my day :) I love your tutorials, the best pedagogic on the web!

[hectormejia]

Wish I could contribute back to you by buying your course- but times are tight atm.. for the time being ill enjoy your free awesome content here... I thank you for that my friend.. good day!

[Chrisdgallego]

I'm gonna try to implement this in my solution. I think this way is really helpful to find products in a list of 11 categories with around 250 products.. Lets see if I can apply it. Thanks

[davefryaustin]

Great tutorial, very helpful and easy to understand.

[butterfliesandbugs]

Why are the example apps "Not Modifiable"? I would like to recreate the app from the BEFORE app, as Sunny goes along, but can't do it as downloaded.

[mialarmacomcsi]

hi sunny great job, excelent videos, i have a quiestion, i need 5 operators log in to file maker data base with different termnials lets say invoice so every one can make an invoice how can we set that up ?

[isabelle]

Thank you for your tutorial. One question however. Your explanation is based on the "Main" layout based on the category table. Can we do this 3 levels-thing for exemple on another layer (for exemple "customer" based on another table) ?

[proteus]

Can you help me with the template invoice. After I go to send invoice by email, it says $, but i need to change to £ British Pounds. Can you help?

[csauve]

Cool video! Instead of using a global field couldn't you use a filter in the third portal base on the product id?

[vasurabaib]

This solution is awesome, and simple to set up. But what if the User had multiple windows open and were on the same layout? What would be a good solution then, since a GLOBAL field is shared across the file in a User Session?

[peterart]

Hi Sunny, thank you for the great video. I have successfully implemented your solution for my application. I have one question... How to set up any indication on which colors are displayed for which Product if the arrow in the Product table is clicked? Maybe a conditional formatting for the button or better yet - and additional field above the Color table that displays the product name? Thank you.

[alfredwitt]

Really a great video, very understandable. However, the script for the OnRecordLoad Trigger is missing "Select Product to show its color". I can not find a solution.

[pademo]

Hi Sunny, Fantastic Video. One question: Could you make the color field in the color field into a drop-down list? If so, how? I tried to do this but instead the drop-down list showed all the colors.

[Gudidi]

Great video Sunny. How would you do this if the category, product and color fields were in the same table? Also what if you wanted to find all product that were Black? Kind of the reverse direction search.

[Heldermc]

What if I need to show how many Products do I have in each Category, and the some in a product's Portal shows how many colors do I have in each product?

[javisanchez]

Hello. I have applied this tutorial to my list. But how can I do to record the choices that I made? I would like to put those choices made in a list so I have that info ready to use or print, but I don't know how to do that. Thanks for the tutorial!