Hello everyone!
In our software we have a double column for certain columns, one column for database purposes only, and a column that uses that database column to display the value in the correct manner. For instance with length, it could be so that one of our customers displays the column in millimeters, and the other in inches.
We support the export functionality as well, if a customer wants to export their data to an Excel sheet, the following screen pops up:
The length column, and the width column under it (which was just outside of the screenshot) are double. But the checked out columns are hidden in the data model. Why aren't they hidden here, but just checked out? I've posted a question about this before, but then the checkboxes were checked by default. This is not convenient either, this could cause confusion for the eventual user.
Wouldn't it be better if the columns, that are hidden in the data model, are not displayed in this screen at all? What is the use of hidden columns if they pop up here for everyone to see? There might be columns purely for the database purposes in here (in this case a single truth for the length value, the database specific field is used as the 'truthful’ data and is converted for display in the display field the customer sees).