How to get database ID?

Tags: #<Tag:0x00007fa98da6ba38>

Hello support,

I am using angular wrapper.

My starting point of development is this example

I am enable to bind with my mongoDB.

In above example, for hotInstance, I get only changes but not the value of my mongoDB _id. Would you please suggest how to get _id value in hotInstance?

And which is better to start project wrapper or pure javascript?

Best Regards,

Hi Damanjeet,

If you work with Angular the use of the wrapper is a good choice. If you want to learn Handsontable and do not have a project yet, then I recommend trying the vanilla version (skip the wrappers).

Handsontable to understand and convert data to a table needs to get data is certain structure. We support arrays of objects and arrays of arrays. You can both pass as a JSON.parse(you_file).
If you need to update it once it is loaded you have two possible ways

  • All data
    loadData() method
    updateSettings > data

  • Data per cell
    setDataAtCell() - for arrays
    setDataAtRowProp - for objects

When you get to the point where everything is set and users are changing data then you can use this tutorial to update your database with changes.

Thank you very much for explanation.

In wrapper Hot-table, what is an alternative or method of getDataAtRow(rowThatHasBeenChanged)?

Javascript example
I am looking for similar method for hot-table wrapper.

API stays the same for vanilla and wrappers so all the methods that can be used are in the documentation
Once you get access to the instance of Handsontable you can call all core methods, like

your_instance.countRows() (- returns number of rows)
your_instance.getDataAtCell(row_index, column_index)

and the methods that are available from plugins, like

your_instance.getPlugin(‘columnSorting’).sort() (- sorts the table, uses columnSorting plugin access)
your_instance.getPlugin(‘manualRowMove’).moveRow(row_index, target_index) (- uses the manualRowMove plugin to move a row to a certain index)

Here is an example that shows how to get the access to instance using Angular wrapper

Thank you. Its solves my problem.

Great. Thank you for confirmation.

Feel free to open a new ticket when needed.