Hello Abu, I trust you are well as it is the case with me, please help me on this I have tried severally

My aim is to have a Toolbar Button or Custom Button, When user clicks on it and there is no selected row or rows, it displays a message you need to select a row/rows, if the user has selected row/rows, it displays add record dialog form, where the user must enter some values, in this case (Offer Status, Effective Date, Closing Date), on Submit button, the values of the form are passed to the INSERT SELECT query. This is part of what I have in code

***************************************************************************************************************************

// virtual column to enter user data (Required*)
$col = array();
$col[“title”] = “Offer Status”;
$col[“name”] = “offer_status”;
$col[“width”] = “50”;
$col[“editable”] = true;
$col[“editoptions”] = array(“value”=>”1:0”); // with these values “checked_value:unchecked_value”
$cols[] = $col;

$col = array();
$col[“title”] = “Effective Date”;
$col[“name”] = “effective_date”;
$col[“formatter”] = “date”;
$col[“editrules”] = array(“required”=>true);
$col[“width”] = “50”;
$col[“editable”] = true;
$cols[] = $col;

$col = array();
$col[“title”] = “Closing Date”;
$col[“name”] = “closing_date”;
$col[“formatter”] = “date”;
$col[“editrules”] = array(“required”=>true);
$col[“width”] = “50”;
$col[“editable”] = true;
$cols[] = $col;

**************************************************************************************************************************

$e[“on_update”] = array(“update_data”,””,false);

function update_data($data)
{
// temp grid object to execute sql
$g = new jqgrid();

else if ($data[“params”][“bulk”] == “add-courses-on-offer”)
{

$selected_ids = $data[“id”]; // e.g. the selected values from grid 5,7,14 (where “id” is field name of first col)
$offer_status = $data[“params”][“offer_status”];
$effective_date = $data[“params”][“effective_date”];
$closing_date = $data[“params”][“effective_date”];

$g->execute_query(“INSERT INTO courses_on_offer (session_id,course_code,offer_status,effective_date,closing_date) SELECT s.session_id, c.course_code, ‘$offer_status’, ‘$effective_date’, ‘$closing_date’ FROM sessions s CROSS JOIN programme_courses c WHERE c.id IN ($selected_ids)”);

die;
}

}

**********************************************************************************************************************

jQuery(‘#list1’).jqGrid(‘navButtonAdd’, ‘#list1_pager’,
{
‘caption’ : ‘Add courses’,
‘buttonicon’ : ‘ui-icon-plus’,
‘onClickButton’: function()
{
var opts = jQuery(‘#add_list1’).click();
if (opts)
fx_bulk_update(“add-courses-on-offer”);
},
‘position’: ‘last’
});

**************************************************************************************************************************

The above adds the selected values first, then displays add record dialog form, on submit it adds a record with values on the form, I want to combine selected values on the grid with the values on the add record form when you click on submit button

Kindest Regards