Remove or Insert empty data in number column

💬 App Building
, ,
1

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,
image
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)

Thanks and regard

2

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?

Thanks!

3

Hello, thanks for the reply,

I have self-hosted with version v3.75.10
The video about my problem, I want to remove the entered data.

the possibility to leave the cell empty, or the same remove it form the changesetArray

thanks and regard

4

@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.
CleanShot 2025-03-07 at 08.40.41

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.

5

Hello,

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:

image
image753×132 6.83 KB

so as the result field are null, the number column doesn't display any value(empty), but after I edit any field, the entered value cannot be removed.

will send you a json of a sample proyect

6

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

thanks a lot for you patient

7

Hi @Zheng ,
I don't see an attached json file. Can you please try to upload it again? Thanks!

8

Hi sry for the delay,

Done!

9

Hi @Zheng ,
I have indeed been able to reproduce this bug and have filed a ticket with our engineering team. In the meantime, just so you know, this bug only occurs for cells in the database that are initially null. If they are already populated, then you can change them and delete them. Therefore, as a workaround, what I suggest you do is to save your change, even if it is a mistake. Then after you re-fetch the data, you should be able to delete it.

I hope this helps! :grinning:

10

Okay, Thanks