Newbee here...
What is the best way to organize multiple dependant drop downs in appsheet that facilitates management of the options?
Say we have a list of options with multiple dependant levels like the one shown below. The options may change over time as materials and conditions are observed in the field.
Is there a recommended way to organize this information that can be called from an Appsheet form that:
1-is not hard coded in the application
2-can be updated and expanded (or reduced) as conditions change?
PS: I found I can manage and update a two level dependant drop down using a "Reference Table", where one column holds the initial value, and the second column holds the dependant option. However, I found that when more than two options are required, the administration and updating the "Reference Table" becomes an issue due to complexity.
Any ideas would be appreciated.
Repair:
-Masonry:
-Lintel
- Door / Window
-Interior/ Exterior
-Reinforcement
-Concrete
-Mix Design
- Strength
- Water Cement Ratio
- Admixture
-Silicate
-Qty
-Hydroxy
-Qty
-Tie COlumn
- Interior / Exterior / corner
-Basement wall
One possible way is to create a BoM (Bill of Materials) table.
In the Dropdown's Suggested Values I have
SELECT(BOM[id],
AND(
[parent_id]= IF(ISBLANK([_THIS]),[_THISROW].[type],[_THIS]),
[level] <> 0
)
)
I have the Type field to select the top level item, but of course this can be changed.
The key is to have parent-children relations within the same table.
(For this use case, I did not have to use the level col.)
Hope this will help you explore further ideas.
TeeSee1,
Thank you for your prompt response to my inquiry.
I review your response and have a couple of questions/comments:
Thank you in advance for your help....
PS: how do you create the dynamic images showing the screen you include in your responses... It would be great to include as part of the questions in the future... (a picture equals a thousand words... you are including a movie... that is almost a book chapter!!! LOL... - Hope is not too complicated... )
Hope this clarifies this a bit more.
User | Count |
---|---|
16 | |
12 | |
9 | |
4 | |
2 |