Hello and Thanks in advance.
I am building a sample app of a manufacturing use case and I’d like to get some suggestions of what is the best way(s) to store, traverse and display a tree structure in Bubble.
Scenario:
A item can be product made of many other items or products (sub assemblies). So in essence a sub-assembly is also a product made with additional items. There are many attributes at the parent-child relationship level
The Application will allow user to view the entire hierarcy but typically level by level (that is the top down tree). There are some cases in which for e.g. find all sub-assemblies where a part is used & effective today. In which case it would be a reverse look-up (down-up tree)
An Item could have many products for eg. an As Sold, an As Designed, an As Maintained, etc.
I am giving here a very simplistic visual for purposes of illustration:
and example data:
Question:
- What is the recommended database structure in Bubble?
- Is there a Tree component in Bubble to represent this kind of hierarchical data
- What are the limitations or performance considerations I should keep in mind when implementing something like this within Bubble?
- In the above data set, if a user is not permitted to view some level of the hierarchy or certain pieces of the information at a level, what is the good option to apply Role Based Access within Bubble
Thanks again.