Exporting selected fields from value list

[bea van ette]

I have a database with more then 600 fields.

For the users I have made some preselected exports they can select from (nodialogs, straight into a excel-file).

But I want them also the have the possibility to choose from a selected list of fields. I have made a custom valuelist with the fields they can select. I have found the method (patterncount, etc.) to see which fields the users want, but then?

If I make tmpfields and fill them with set field I have to do that for each record. Is there another way to solve this problem?

Thanks

Bea

[-Queue-]

You could use unstored calculations of GetField(globalFieldX), where globalFieldX is one of the fields which contains a member of the selected field list.

You could also use a repeating calculation field that retrieves one member of the selected field list per repetition, then use GetField(GetRepetition( calcRepeating; X )), and change X for each field definition.