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! Go to Solution.
Something like..
<<SWITCH([ImageSelect],
1,[Image1],
2,[Image2],
etc.
)>>
User | Count |
---|---|
16 | |
14 | |
8 | |
7 | |
4 |