Buy Now
Sign in

How to order Fields in XLS Export

tonkom , August 02 2016
T
tonkom
Hi,

i would like to know how to order the fields in XLS Export different to the order in the Form.

Could not get it to work except in the order of the original Form.

Thank you,

Thomas
GreyHead
Hi Thomas,

There is a Fields list box in the XLS EXport action. If you put the list of fields in there does that set the order?

if you are using a DB Read to get the data there's also a Fields list box there.

Bob
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
T
tonkom
Hi Bob,

thanks for your reply.
I tried the field list boxes in the XLS export action already, but couldnt get the fields and field heads(column name in xls) into sync :-(.

Is there any other way to order fields and column names than the field list boxes?

Best regards

Thomas
GreyHead
Hi tonkom,

You could re-order the columns in the database table; or use a Custom Code action after the DB Read to re-sort the data after it has been loaded.

Bob
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much