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.
Hi Sunny, It is so much fun watching your videos and I am learning tons of stuff :) Can I have more steps in a nested portal. For an example 5 steps like this: Main level - second level - third level - fourth level - fifth level. I pick a Main level object and the portals get filtered for just that object.
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!
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) ?
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.
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
3 years later, yes, this works. And it keeps the relationships correct. I actually used a global variable instead of a global field. I created a script that sets the global variable to the primary key of the selected record in the portal, then the child portal has a filter on it for it's foreign key to equal this global variable. Then in the script refresh the port as the last step.
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?
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.
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.
For the same table question... well its going to be quite tricky, one way to do it is to convert data from your 1 table into 3 temporary table with help of ExecuteSQL, and do the exact same thing as this tutorial. In terms of the reverse search, you can just create a layout with the "color" table and search in there of the black color item. I don't think a nested portal styled layout is the best structure for this specific use case.
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!
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.
3 years later, yes, this works. And it keeps the relationships correct. I actually used a global variable instead of a global field. I created a script that sets the global variable to the primary key of the selected record in the portal, then the child portal has a filter on it for it's foreign key to equal this global variable. Then in the script refresh the port as the last step.
@@FMBeginner I am really stuck at this. I managed to do it beautifully for 3 tables as per your solution. For the 4th Table, would I need to create two global variables - 1 for the 1st table and 2nd for the 2nd table and filter for both or is there some other way to do it?
@@FMBeginner My structure is as follows:- 1.) Category 2.) Designs 3.) Color Code 4.) Join Table which shows all the colors in that particular color code of that particular design
I've been playing with this exercise and I have a problem a bit difficult to resolve here but maybe it could be answered in a general point of view. why could do the next error happens? I just use two levels (categories and products). After click in some categories, the category 1 has change its name to the next category I clicked, replacing its name by the category I clicked after. So if I click on category one end then on category category two, the first one is autorenamed to the secong one clicked. So I get category 2 and category 2. Twice. I'm not sure if you understand what I mean. Thanks
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?
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 ?
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.
Hi Sunny, It is so much fun watching your videos and I am learning tons of stuff :)
Can I have more steps in a nested portal. For an example 5 steps like this: Main level - second level - third level - fourth level - fifth level. I pick a Main level object and the portals get filtered for just that object.
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.
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!
from 0 in database system, for now i can create my own system. thanks sunny.
You saved my day :) I love your tutorials, the best pedagogic on the web!
Thank you and you're welcome!
Thank you so much...I've been searching the net for a while trying to find a solution to this. Beautifully done...thanks man!
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) ?
Great stuff. Thanks!
great lecture... thanks
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.
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.
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
Great tutorial, very helpful and easy to understand.
Cool video! Instead of using a global field couldn't you use a filter in the third portal base on the product id?
Thats actually a nice way to do it that I never thought of! I haven't tested it but I think your suggestion might just work without all that hassle!
@@FMBeginner Could you please provide the details of how to do it (if it works). Thanks!
3 years later, yes, this works. And it keeps the relationships correct. I actually used a global variable instead of a global field. I created a script that sets the global variable to the primary key of the selected record in the portal, then the child portal has a filter on it for it's foreign key to equal this global variable. Then in the script refresh the port as the last step.
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?
I have the same question. Did you figure this out?
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.
Sorry I meant * color field in the color Portal *
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.
For the same table question... well its going to be quite tricky, one way to do it is to convert data from your 1 table into 3 temporary table with help of ExecuteSQL, and do the exact same thing as this tutorial.
In terms of the reverse search, you can just create a layout with the "color" table and search in there of the black color item. I don't think a nested portal styled layout is the best structure for this specific use case.
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?
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!
Hi Javi, you likely need some sort of checkbox to select the object. And your print script can then find all the checked item to print it
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.
I am not too sure what you mean by trigger is missing the script. Are you opening the file with the latest version of FM?
@@FMBeginner Sorry, I saw that you used the same script for the button in the portal and the OnRecordLoad Trigger. Right?
Can you use a filter in the colour portal ? by using the global field ?
Yes you can.
3 years later, yes, this works. And it keeps the relationships correct. I actually used a global variable instead of a global field. I created a script that sets the global variable to the primary key of the selected record in the portal, then the child portal has a filter on it for it's foreign key to equal this global variable. Then in the script refresh the port as the last step.
hi, thanks again,
i learn so much.
can you do this with more than 3 tables?
Yes, same principle as the 2nd layer with more global field and more script. basically more "tricking"
@@FMBeginner I am really stuck at this. I managed to do it beautifully for 3 tables as per your solution. For the 4th Table, would I need to create two global variables - 1 for the 1st table and 2nd for the 2nd table and filter for both or is there some other way to do it?
@@FMBeginner My structure is as follows:-
1.) Category
2.) Designs
3.) Color Code
4.) Join Table which shows all the colors in that particular color code of that particular design
I've been playing with this exercise and I have a problem a bit difficult to resolve here but maybe it could be answered in a general point of view.
why could do the next error happens?
I just use two levels (categories and products). After click in some categories, the category 1 has change its name to the next category I clicked, replacing its name by the category I clicked after.
So if I click on category one end then on category category two, the first one is autorenamed to the secong one clicked. So I get category 2 and category 2. Twice. I'm not sure if you understand what I mean. Thanks
Probably best to check your set field script, I have a feeling you're targeting the wrong field
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?
You will need to learn how to use the Count calculation function in conjunction with relationship
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 ?
Hello Sunny. First thanks for your videos. Can you send your email? I want to contact you. Thanks