Edit table record in drawer frame

I have a query regarding Drawer Frames.
My requirement is to edit some table fields from the drawer frame. I open the drawer frame on table row double click and populate the editable text fields in drawer frame. See the screenshot

So i want to edit question1 and question2 from drawer frame and save the changes when i click the save button (below one).

quesiton1 is populated from the table {{aiPromptsTable.selectedSourceRow.question1}} likewise.

I have a save query in place as follows to update the table with changeset

{{ aiPromptsTable.changesetArray[0] }}

Screenshot from 2024-05-21 04-30-12

I cannot figure out the way to get the changeset values from the drawerFrame

Got it done using a custom sql query triggered on Save button click action without complicating with connecting with table changeset values

UPDATE
  "XXXX"
SET
  question1 = {{q2.value}},
  question2 = {{q3.value}}
WHERE
  xxxx = {{aiPromptsTable.selectedRow.xxxx}};

Hi @Mahendra_Dassanayaka This solution looks good! Yes, the changeset only gets updated when you edit directly in the table cells; it won't update if you edit in the drawer frame.

1 Like