Forum Discussion

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

Qrew Cadet

3 years ago

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
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
------------------------------