Dynamic combobox/dropdown list
Sorry in advance if this has been solved before.
I'm trying to create a table with a couple dynamic comboboxes. If option 1 is selected for combobox 1, then only options 1 to 6 will be available in combobox 2. If option 2 is selected for combobox 1, then only options 7 to 12 will be available in combobox 2.
So far I've been trying to use tables with the options that populate each combobox. The comboboxes themselves are just relationships to those tables. I was hoping that using constrains would work to filter out the unwanted options, but that's where I'm stuck.
Am I going in the right direction, or is there a better way to do this?
18 replies
-
You use dynamic comboboxes and constraints. In Ninox contraints usually refers to reference fields. Dynamic choice fields do not use constraints per se. So this solution is using dynamic choice fields.
I've included two ways of doing the selection. The first one (selection2) uses the relationship between the two tables. The second one (selection2a) is probably what most people will do.
-
Thanks Fred! That's exactly what I was looking for.
-
said:
what would be the solution, if I use multiple dynamic choice field?Ask and you shall receive.
-
said:
Is there a way to get the choices sort by 1.group and then by 2.abc?Ninox can not do a multilevel sort with code commands. You have to create another field that combines the two fields you want to sort by and then sort by that field.
In the Subcategory table, create a new formula field, I called it Sortfield. Then add this to the formula:
Category.Category + "," + Subcategory
You can test it out and add it to the table view of Subcategory and you can see how it works.
Now you can go the Category tab of the Dashboard table and modify the Subcategory dynamic multi choice field to:
let t := this; (select Subcategory)[contains(numbers(t.Category), number(Category))] order by Sortfield
I hope it now shows how you want it.
-
I'm doing a WBS (Work Breakdown Structure) on Multiple Choice Dynamic for each Level
Content aside
- 1 yr agoLast active
- 18Replies
- 485Views
-
6
Following