Board 14.5 - Flex grid Code + Description concatenation

Emil Amante

Notice that in Dataview, and everywhere else, the concatenation of Code and Description is separated by just a blank space. But in the flexgrid, it uses a hyphen. Can this be fixed in a patch?

It makes things cumbersome when you're trying to compare things in an Excel export, you have to manipulate the data to do proper xlookups/vlookups.

Andrea Contaldo

Hello Emil,

This is not a behaviour we can currently change. However, you can add an entity block with the desired entity in the layout. This way you will have the same column twice and you can use the flex grid features to display code on one of the 2 columns and description on the other. This way you will have the easiest setup for lookups in excel because the code and descriptions are completely separated in 2 columns.