Struggling to get modal form to use data from clicked row

[lburmz]

I'm sure this is simple, but I'm new to budibase and have been going round and round in circles (with the help of Copilot). I'm trying to go from clicking on a row in a table to opening that record in a modal form to edit. The complication is that in my form I want to group the fields under headings and have some fields over 1, 2 or 3 columns. As I understand it that is not possible with a form block, but can be achieved with a form and field groupings. The problem I am having is that I cannot get the form to open on the clicked record, I see this instead:

I have a data table "enquiries" in BudibaseDB, with a alternate view called new-enquiries (which is enquiries with a filer based on one of the field values).

In my app I have a screen with the following:

In Enquiries Table the settings are:

and Actions:

New Data Provider has the following settings:

with filtering:

New Form has the following settings:

At one point it was working when I had Data Provider --> Repeater --> Form, but then I couldn't get the Save button to save any changes to the record, so removed the repeater. The Save button is in a Button Group after the last field group, within the form.

I appreciate any assistance, thank you in advance.

[04nd01]

This interaction has two steps. You're writing something to state and then you read it and do something with it. So there's two places where it could go wrong. Have you tried using the bindings tab to see if the value written into the state variable is actually what you would expect?

[lburmz]

When I check the bindings tab in the On row click action from the table, I can see all the information for the Clicked Row.

The data is not being passed passed to the Data Provider for the form though.