27.08.2025
10:25
Hi,
data table /rows display the values as they are returned from the data source. In case of the MSSQL data source this is fine for text fields and for choose fields, integers/decimals we can work around it. Either by using the available functions or using format functions and the current user language. In case of date time there's no work around.
The issue is especially visible when users are located in different time zones because the date time is returned in the server time.
Of course we can return the time in an ISO format with time zone offset. There's no arguing here, that this is correct, but it's not user friendly. Especially if they have other date time fields on the form which users will compare against the time displayed in the data table.
We also cannot use the format functions on the server as we don't know the time zone of the user. This is only known by the browser.
Therefore it would be great, if the data table configuration dialog could be configured to:
- Define the type of a column: Text, integer/decimal, date time, choose field
- Provide a configuration dialog similar to the advanced configuration.
This would:
- Move the formatting from the server to the client
- Solve the issue with the date time
- Improve the user experience as the data table values would be displayed in the same format as other form fields
Best regards,
Daniel
