Hello guys, I'm using a table component for show and edit data coming from the database, and the data input is numeric type, so I make columns be numbers, that force the users write only numbers. But I found a problem, if I write a data in wrong cell/row, I cannot remove it from the changeSetArray,
In this case, if I want to remove the data 2, the only way I found is refresh the table and remove all other data input whiches are correct datas.
So, How can I remove a wrong data keeping the rest of input data? (with number column because I dont want users insert text into the table)
Hi Zheng,
What version of Retool are you on? Are you on cloud or self-hosted?
If you are on cloud, go back into the cell where you entered the incorrect data and change it back to what it was originally, it'll remove it from the changeSetArray.
If this does not work for you, can you send me a video of what is happening in your changeSetArray as you change your values?
@Zheng,
I'm not able to reproduce your issue on my end yet.
Can you tell me how your columns are configured in your database? It looks like none of them have any values at the moment. Are they set to null in the database? Can you send me a screenshot of the 'Result" field configuration of your database please?
It might also be helpful if you could send me the export of your json file for your app.
Also, is there anything showing up in your Debug console? (You can open up your Debug console by clicking on the "Debug" link in the bottom right corner of your screen)
I will keep trying to reproduce your issue, but if you could get me those resources, I would appreciate it.
how the data is saved in database I think it doesn't affect to the display, because after retrieve the data I use a js to transform the data to show it correctly in the table. correctly the data source of the table is like this:
I have already sent you the json, please let me know if you received it.
About the issue, enter a data into the table, and you will see it not able to remove the value or change it back to empty