Build column name in expression from a value in a column

I have some numeric values in a virtual column, [ImageSelect] stored as 1,2,3,4, etc.

I want to use these in an expression to select a column name containing an image in a template. The columns are called Image1, Image2, Image3 and so on.

The expression needs to be built up as something like <<"image" & [[ImageSelect]]>> but I'm not sure of the correct syntax. Is this even do-able?

thanks for any help

James

Solved Solved
0 8 164
1 ACCEPTED SOLUTION

Something like..
<<SWITCH([ImageSelect],
1,[Image1],
2,[Image2],
etc.
)>>

View solution in original post

8 REPLIES 8