Discussions

 View Only
  • 1.  Creating Dynamic fields in the child table

    Posted 12-23-2020 10:53

    I have 2 tables. Table A is the parent and Table B is the child table, Table A have fields Name(txt), Dimensions(num), Description(txt). Table B should  have field Name but other fields like Length, Width1 and WIdth2 should appear based on the entry in the Dimensions field of parent table. 

    i.e, if Dimension =1 then fields of child table B must be Name and Length only. 

    If Dimensions= 2 then fields of child table B must be  Name, Length, width1 only

    if Dimensions= 3 then fields of child table B must be Name, Length, width1 and width2.

    Is this possible?



    ------------------------------
    Aswin Babu
    ------------------------------


  • 2.  RE: Creating Dynamic fields in the child table

    Posted 12-23-2020 12:01
    Edited by Mark Shnier (Your Quickbase Coach) 12-23-2020 12:38

    No Problem.

    Of course, those look up fields will exist on every child record so your real question is how can you control the display of the form to only give meaningful fields for the Dimensions.

     The name and length field will appear on all forms so there is nothing special required there. 

    To control when the field for width 1 shows set up a Dynamic Form Rule to show Width 1 when 

    any of the following

    dimensions is equal 1

    dimensions is equal 2 

     Then set up an additional dynamic form rule to control when Width 2 should show. 



    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------