Editing JSON data with a nested list

[Agustin_Carozo]

Hi Debugz and welcome to the community

The only way to work directly with json would be to edit the entire object and send it back, so it’s not really efficient but can be done.

The best way to handle this would be to have an external database and link each item to a column.

We’ve had a couple of users mentioning something similar:

Updating a json object

Hey everyone I have a Weweb project that I am working on. I am using Supabase for my backend. I have a table “fuel tanks” that has two columns, the ID column and tanks, which is a json object that holds the location, fuel type (diesel or petrol), capacity and current level [Screenshot 2024-12-17 at 22.42.26] I would like to know how do i just update an element in the json object, for example, if i wanted to update the current_level for petrol? When I change a value, the new value replaces t…

How to push edited format of JSON?

Hello. In Supabase, I’m working with a JSON column that contains data structured as follows: [ { "name": "CEO", "value": 100 }, { "name": "CTO", "value": 95 } ] I need to develop a form that allows users to send data in this format to the Supabase database. Is it feasible to create a JSON object like this and add multiple objects to it? The number of objects might vary – sometimes there could be just one, other times as many as ten. Users should…

Hope this helps!