updating table from json state object

[pchanley]

I have created a json object from 3 tables combined in a specific way. I want to create a table from the json. ideally would update in javascript. any help would be greatly appreciated

[mikesealey]

Hey @pchanley

When you add a table to your screen you can select the Data Source - Typically these would be tables from your Data Section, Views (or View Calculations (v3.0!)) or queries. Near the bottom of the list you can select JSON/CSV. You may find that the table component automatically selected one of the available options on your behalf, but you can simply change it in the settings.

When you switch to JSON/CSV, you will see a little cog/gear/sprocket icon next to the setting. Clicking this will open the bindings drawer, where you can use the bindings to bring in your variables, write your JSON or CSV, or use a mixture of the two approaches to achieve your goal.

You can use the text input of the bindings drawer to simply write comma-separated values

Alternatively you can use the JavaScript input of the bindings drawer to return an array of objects, as such:

return [
  {name: "Mike", fav_colour: "Blue"},
  {name: "Conor", fav_colour: "Green"},
  {name: "Andy", fav_colour: "Red"},
 ]

If you're using the Internal BudibaseDB you can simply use a View to display related tables though, you don't need the above extra steps.

Go to the Data section, and view one of the tables in question.
Create a Table View, and name it.

Then click the Columns button, and where you have a relationship column you will be able to look into the other table. By default you'll see that all columns in the related table are hidden.

[pchanley]

Mike,

great info, much appreciated.

As i am creating the data for the table on the fly based a combination of data from 3 different files. i ampopulating the table on the fly. and that works fine. However, I would need to apply column attributes to the table. is that possible. Or if I define a table in the Buidbase and set up the appropriate attributes there, How would I update that table from my state array?

Thanks

Peter

[pchanley]

I am thinking that perhaps data table is not the right component for what I am trying to do. as I have to add the ability to update entries. and various buttons to update groups. So perhaps you would have another suggestions. perhaps multriple fors or field groups?

thanks

[pchanley]

can you update a budibase table from a state array.