I have created an order form with a collection that is showing in a Gallery. In the Collection, I would like to create some dependent Allowed Value functions in a couple of the input boxes. There is no control type list where I can choose the allowed values control, I assume it is since these text boxes are inside the gallery. An example of what I want to do: A user could select either (Top, Casework, Joinery, or Other) in the Top input, and depending on their selection, it will determine what the allowed values are in description. Example: if Top is selected in Type, then it will allow to select either (Square Top, Round Top, etc.) in Description, but if Joinery is selected in Type, then the user could choose from (Credenza, Waterfall, etc.). I have added screenshots below.
Another thing I was wanting to know, is there I could change the Total Item Cost input to where it could add the sum of the Base Cost, Wood Cost, Material Cost, Labor Cost, and Other Costs, without changing the default of the formula so the value would still transfer to the Collection?