Dynamic List Box

[albe]

Hello,

I would like to create list boxes by reading an external parameter file containing the name of the fields and a flag to choose if they should be displayed in a list box.

Do you have an idea to do this ?

I tried creating a table that has the name of the fields to be displayed in list boxes, but I don't know how to choose the list box field using an expression.

Thank you for your help.

[MarcoWedel]

Hi,

one possible solution to this might be:

=$(=Only({$<ShowFieldID={1}>} NameOfField))

=$(=Only({$<ShowFieldID={1}>} ShowField))

Using a table containing the field names and show flags:

tabShowFields:
LOAD RecNo() as ShowFieldID, *
INLINE [
    NameOfField, ShowField
    Field1, 1
    Field2, 0
    Field3, 1
    Field4, 1
    Field5, 0
    Field6, 1
    Field7, 0
    Field8, 1
];


tabData:
LOAD Ceil(Rand()*20) as Field1,
     Ceil(Rand()*20) as Field2,
     Ceil(Rand()*20) as Field3,
     Ceil(Rand()*20) as Field4,
     Ceil(Rand()*20) as Field5,
     Ceil(Rand()*20) as Field6,
     Ceil(Rand()*20) as Field7,
     Ceil(Rand()*20) as Field8
AutoGenerate 30;

hope this helps

Marco