Dear Support,

May I know how can I manipulate like add a character (%, cm, points) before output the field. Also, How do I convert date time when select datetime field.

Thanks

Hello,

If you want to modify some data, "Columns settings -> Columns settings" parameter can be used. For example if you want to add "cm" to field with ID equals to "Col1", set "Columns settings -> Columns settings -> ID" parameter to Col1 and "Columns settings -> Columns settings -> Format" to {$value} cm. About datetime field, could you explain what value do you want to convert and what do you want to see as result?

Regards,
ARI Soft

Thanks for the quick reply.

Please refer to the attached snap shot, I am using the ARI data table and Flick as theme, I cannot see any ID but all in class in FireBug. So where should I get the ID?

Regarding the datetime, database value is 340 but it suppose to be displayed as 05:40 minute.

Please assist.

Thank you.

Sorry attached the snap shot.

Under column "ID" we mean column in name in database (if you use SQL database as source) or in CSV file (if you use CSV file as source).

Regards,
ARI Soft