MattHolmen
4 years agoQrew Member
Populating Multi-Select from a different table with filtering.
I have a table called trades:
That table contains a name field and 2 checkbox fields:
I have a from on another table that has 2 multi-select boxes. Currently each of those multiselects is populated using the input type:
However, what I need to do is to only populate those fields based on if the correct checkbox is checked on the Trades table.
For example:
Dropdown 1 on Table 2: This only pulls in that Trade Names when the Site Development checkbox is checked.
The only way I can think of at this point is via a pipeline, but I am not even sure that would work the way I want it to since I believe that would a 20 field line limit. Doing it this way now does not have that limit.
Thanks
------------------------------
Matt Holmen
------------------------------
That table contains a name field and 2 checkbox fields:
I have a from on another table that has 2 multi-select boxes. Currently each of those multiselects is populated using the input type:
However, what I need to do is to only populate those fields based on if the correct checkbox is checked on the Trades table.
For example:
Dropdown 1 on Table 2: This only pulls in that Trade Names when the Site Development checkbox is checked.
The only way I can think of at this point is via a pipeline, but I am not even sure that would work the way I want it to since I believe that would a 20 field line limit. Doing it this way now does not have that limit.
Thanks
------------------------------
Matt Holmen
------------------------------