FileMaker Nested Portal

แชร์
ฝัง
  • เผยแพร่เมื่อ 12 พ.ย. 2024

ความคิดเห็น • 44

  • @mitziperdue2820
    @mitziperdue2820 ปีที่แล้ว +1

    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.

  • @andreasringsparr3218
    @andreasringsparr3218 หลายเดือนก่อน

    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.

  • @thesheeplelookup
    @thesheeplelookup 4 หลายเดือนก่อน

    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.

  • @hectormejia1184
    @hectormejia1184 3 ปีที่แล้ว

    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!

  • @siputurbo
    @siputurbo 4 ปีที่แล้ว

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

  • @inajohansson5608
    @inajohansson5608 4 ปีที่แล้ว

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

    • @FMBeginner
      @FMBeginner  4 ปีที่แล้ว

      Thank you and you're welcome!

  • @trevorradebe
    @trevorradebe 5 ปีที่แล้ว +1

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

  • @isabelle78827
    @isabelle78827 ปีที่แล้ว

    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) ?

  • @toddgee6841
    @toddgee6841 3 ปีที่แล้ว

    Great stuff. Thanks!

  • @Rico5568
    @Rico5568 4 ปีที่แล้ว

    great lecture... thanks

  • @peterart88
    @peterart88 5 ปีที่แล้ว

    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.

  • @butterfliesandbugs4535
    @butterfliesandbugs4535 9 หลายเดือนก่อน

    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.

  • @Chrisdgallego
    @Chrisdgallego 5 ปีที่แล้ว

    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
    @davefryaustin 4 ปีที่แล้ว

    Great tutorial, very helpful and easy to understand.

  • @csauve2004
    @csauve2004 5 ปีที่แล้ว +1

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

    • @FMBeginner
      @FMBeginner  4 ปีที่แล้ว

      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!

    • @et1193
      @et1193 4 ปีที่แล้ว

      @@FMBeginner Could you please provide the details of how to do it (if it works). Thanks!

    • @nickandrews1985
      @nickandrews1985 ปีที่แล้ว +1

      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.

  • @vasurabaib3985
    @vasurabaib3985 3 ปีที่แล้ว

    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?

    • @twhiteford
      @twhiteford 3 ปีที่แล้ว

      I have the same question. Did you figure this out?

  • @pademo57
    @pademo57 5 ปีที่แล้ว

    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.

    • @pademo57
      @pademo57 5 ปีที่แล้ว

      Sorry I meant * color field in the color Portal *

  • @Gudidi
    @Gudidi 5 ปีที่แล้ว

    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.

    • @FMBeginner
      @FMBeginner  5 ปีที่แล้ว +2

      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.

  • @proteus1
    @proteus1 3 ปีที่แล้ว

    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?

  • @javisanchez4365
    @javisanchez4365 4 ปีที่แล้ว

    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!

    • @FMBeginner
      @FMBeginner  4 ปีที่แล้ว

      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

  • @alfredwitt7866
    @alfredwitt7866 5 ปีที่แล้ว

    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.

    • @FMBeginner
      @FMBeginner  5 ปีที่แล้ว

      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?

    • @alfredwitt7866
      @alfredwitt7866 5 ปีที่แล้ว

      @@FMBeginner Sorry, I saw that you used the same script for the button in the portal and the OnRecordLoad Trigger. Right?

  • @Jonathan-mk1ju
    @Jonathan-mk1ju 4 ปีที่แล้ว

    Can you use a filter in the colour portal ? by using the global field ?

    • @FMBeginner
      @FMBeginner  4 ปีที่แล้ว

      Yes you can.

    • @nickandrews1985
      @nickandrews1985 ปีที่แล้ว

      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.

  • @patriciafagan3632
    @patriciafagan3632 5 ปีที่แล้ว

    hi, thanks again,
    i learn so much.
    can you do this with more than 3 tables?

    • @FMBeginner
      @FMBeginner  5 ปีที่แล้ว

      Yes, same principle as the 2nd layer with more global field and more script. basically more "tricking"

    • @karanag21
      @karanag21 4 ปีที่แล้ว

      @@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?

    • @karanag21
      @karanag21 4 ปีที่แล้ว

      @@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

  • @Chrisdgallego
    @Chrisdgallego 5 ปีที่แล้ว

    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

    • @FMBeginner
      @FMBeginner  5 ปีที่แล้ว

      Probably best to check your set field script, I have a feeling you're targeting the wrong field

  • @Heldermc04
    @Heldermc04 4 ปีที่แล้ว

    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?

    • @FMBeginner
      @FMBeginner  4 ปีที่แล้ว

      You will need to learn how to use the Count calculation function in conjunction with relationship

  • @mialarmacomcsi
    @mialarmacomcsi 2 ปีที่แล้ว

    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 ?

  • @hr-yh1hz
    @hr-yh1hz 3 ปีที่แล้ว

    Hello Sunny. First thanks for your videos. Can you send your email? I want to contact you. Thanks