Update Bindings From A Budibase Table

[Joe-Florio]

Let me start by stating I'm a newbie to Budibase and have searched the help forum for a solution. I've spent significant time attempting to load some bindings from a Budibase table, and have failed miserably. My goal is to; be able to update some state variables (boolean) and their table values, from a screen form. I'm looking to get away from my current method which utilizes "On screen load" with "Update State" Action to assign bindings. The current method is too archaic (modify value in Builder and re-publish), whereas the live app should be able to update the table value and toggle the state.

My table named (Bindings) has 2 fields; "Binding_Name" (Text) and "Binding_Value" (Boolean). For this example, I'm looking to return 3 individual state variables; StatusBar (Row.0), Logging (Row.1) & Notifications (Row.2), every time the screen loads. The state variables are intended for global use and will need to be occasionally toggled. I've constructed the screen form with a data provider but am only able to return a binding array, instead of individual state variables. The array makes it overly complex with more work to maintain and grow the app, with no significant benefit. I'm using BudiBase Premium Cloud Hosted solution.

If anyone has a sample template or can provide direction, it would be much appreciated. Thanks in advance...

[mikesealey]

Hey @Joe-Florio

but am only able to return a binding array, instead of individual state variables.

I think you might just need to prop-drill a little more... Here's what I get when I return all rows from a data provider with a limit of 1

But if I dig into it a little more, I can get a specific column by using .0 to get the first row, and binding_name to get the specific value.

Just one extra little bit of information: you can have a column name with spaces, that's allowed, but if you want to reference it with the handlebars bindings, you're best off wrapping it in square brackets [like these].