Forum Discussion

MattHolmen's avatar
MattHolmen
Qrew Member
3 years ago

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 ...
Relationships
Tables and fields
AhuvaBrown's avatar
AhuvaBrown
Qrew Trainee
I would create a formula-text field for each checkbox type that would display the name only if the correct checkbox is checked and use the formula field as the multi-select input type.

------------------------------
Ahuva Brown
------------------------------
MattHolmen's avatar
MattHolmen
Qrew Member
3 years ago
I will have to give that a try. I think I made it more complicated by creating a new table for each type and using pipelines to populate it.

This way sounds much simpler and less processing intensive.

------------------------------
Matt Holmen
------------------------------