How to format handsontable data

Tags: #<Tag:0x00007efc72f44708>
#1

Hi, I have a field whose data is in the datetime format, I would like to format the data to show just the time. I am working with react and to do this normally, I would use moment(a react package).

Like this:
image
{updated_at}

this does the formatting for me, but using handsontable, how do I achieve this, because with handsontable, I just need to set the object inside the column array like this:

columns: [

        { data: "updated_at", readOnly: true, width: 90 },

        { data: "updated_at", readOnly: true, width: 90 },

        { data: "updated_by", readOnly: true, width: 120 },

        { data: "field_name", readOnly: true, width: 120 },

        { data: "new_value", readOnly: true, width: 100 },

        { data: "notes", readOnly: true, width: 150 },

    ],

How do I do the formatting here?

#2

Hi @magneticdigital1

Handsontable has a date and time cell type. We do not provide a built-in DateTime cell yet. However, if you do not need an editor like that just the display you can build a custom renderer https://handsontable.com/docs/8.3.2/demo-custom-renderers.html

#3

thank you. figured it out.

#4

Thank you for a prompt update.

I’m closing this topic as solved.

#5