Forum Discussion

AmberPolston's avatar
AmberPolston
Qrew Cadet
4 years ago

How to use a text field to populate the field names in a formula field

Is there a way to use the values from a text field ([Text Field) as the "field name" in a formula field. The text field is populated by a formula converting a [Multi-Select Lookup] field into a for...
Formulas and functions
MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
4 years ago
Can you do it like this?

var text MultiSelect = totext([Multi-Select Lookup]);

If(Contains($MultiSelect, "Section Name"), [Section Name]) &
If(Contains($MultiSelect, "Section No."), [Section No.]) &
.....
)

You could wrap the entire thing in a List(";", ......) if you want to separate them by a deliniator.

------------------------------
Mike Tamoush
------------------------------