Resuelto
Using CONCAT to compile a field name which then pulls in that data
I'm trying to use CONCAT to pull together multiple drop down sections into a Field name in order to look up a price. Have any of you been able to use CONCAT to generate a calculated field that will then display a different Form Field?
Example
CONCAT("{DE:",{DE:Tier},"-",{DE:Level},"}")
Creates: {DE:Tier2-Level3}
Which would then pull data from that Form Field
Tier2-Level3 = $23
So far i haven't been able to make this to work.
I seem to be able to do this if i create a calculated field that is just the name and then another calculated field that uses the IF function. However I would have to create an IF calculation with 56 variants. I'm hoping there is a way to do this simply in a field using CONCAT or another expression that would then just generate the Field name and it then reflects that value.