Cannot edit more than one cell in the whole table!

Getting help Questions
1

Hi, I am building an app with python using Flask and am trying to follow along with this tutorial: https://docs.handsontable.com/pro/1.13.0/tutorial-load-and-save.html. When I put the javascript script code directly in my templates (view) file, it loads the table but for some reason it won’t let me edit more than one cell. For example I can edit A1 but when I try to put a value into A2 or B1 I get blanks. I did mange to get it working in a barebones version of my app but I really need to integrate it with the full version of my app. Any help will be appreciated.

2

Hi @amazoneden21

unfortunately, I am not familiar with Flask and haven’t tried programming in Phyton as well. Do you get any console.logs? Have you tried to build and test simpler examples like this one http://jsfiddle.net/handsoncode/8m3bcs17/?

3

Thanks for the speedy reply @aleksandra_budnik
This works fine but not the load & save one. See the image below.

I mean as long as can get this to save to MYSQL database, be able to clear it and re-add data. I won’t miss the load & save tutorial. Do you know the easiest way to go about doing what I mentioned?

4

Let me part it to steps and correct me if I’m wrong

  1. You load a table that looks like this

image.png220×104 1.62 KB

  1. and after user changes some field like here

image.png220×104 1.83 KB

  1. you want to send the changes to the database and save it

Am I right?

5

Yes you are right. And also Once I’m done saving it, I want the ability to clear the table too if I need to.

6

Thank you for confirmation @amazoneden21

If a user changes anything in the table the afterChange hook get called. You can use it to push the data into your database. If you would like to change the value of a cell or erase it you can pick the setDataAtCell method or loadData if you want to erase the whole table or load more data.

Unfortunately, as a front-end library provider, we do not have any examples that contain connecting table to a database.

7

That’s a shame, you guys should really make some examples using popular databases for different programming languages. That’s what stopping me from purchasing HandsOnTable.

8

I am sure that we will create such an example for a blog post in the future.