Splunk Apps » Lookup Editor

Using smalot/bootstrap-datetimepicker 2.3.5:
https://github.com/smalot/bootstrap-datetimepicker/releases

Could use this API for date editing: http://docs.handsontable.com/0.19.0/tutorial-cell-editor.html

Some examples of a custom cell editor:

• https://libraries.io/bower/Handsontable-select2-editor
• http://jsfiddle.net/6SgF4/

See http://momentjs.com/docs/#/parsing/string/

Need to figure out if the 'time' format is timestamp or date. See https://docs.mongodb.com/manual/reference/mongodb-extended-json/#bson-data-types-and-associated-representations

Time
We accept epoch time either as a string or as a number. If it fails to convert, we'll insert the string version.

It turns out that the dates need to be a number.

Might be able to convert this via afterChange()

http://docs.handsontable.com/0.15.0/Hooks.html#event:afterChange

Might need to do this in makeRowJSON()

This would make a good UI for selecting datetimes: https://chmln.github.io/flatpickr/

• Handsontable.editors.TextEditor.prepare() doesn't get called when rendering existing rows
• Could do the transformation in the normal lookup renderer but this would mean pulling out the moment.js time renderer (and its time format correction)

http://jsfiddle.net/p7KwM/

1. Use basic renderer
   1. Doesn't do time format correction
   2. Editing shows original value (the number)
2. Use custom time renderer
   1. Original values are rendered, prepare doesn't seem to get called on the initial load
3. Use time renderer and renderer override (http://jsfiddle.net/p7KwM/)

I have option two is working, but the format is still a number when editing.

Calling this.handsontable.validateCells(); does change the format. However, it also resaves the rows.