Related SelectWdg

[dankitchen]

I remember in the past there was a way to have 2 SelectWdg based columns in a table where the options in the second select would be filtered based on what was selected in the first select.  I can't recall if this was done with Python or if there was an element config that was possible to do this.  I do seem to recall having to have the select behaviour on first select trigger a regeneration of the labels/values for the second select.  

I will post anything I figure out but figured this was an interesting topic for discussion :-)

I am currently testing this on 4.7.0.b02 on FC30 os

-Dan

[listy]

Hi!
Selecte widget is getting updates dynamically. If your first select widget changes data, second will update it automtically (based on change_timestamp table)

[dankitchen]

Yes correct, that's what I am trying to setup, here is a example of what I am thinking

I have would have 2 tables like building and floor. so I have:

Building A
-floor 1
-floor 2
Building B
-floor 1
-floor 2

so if I have one select looking up buildings and one looking up floors, without the update, the floor select would show:

floor1
floor2
floor1
floor2

So I want it that if the user selects say building A, the floor select would only show:

floor1
floor2

I guess another note is that I don't necessarily have to do this in the table as I will have a custom edit form but...good if it could work in the table as well.

thanks!