update other field on update

Questions › update other field on update

0 Vote Up Vote Down

Cedric asked 5 years ago

Hello,

I have a field called weight, and when this one is updated with value 0 I would like to update the field called status

Is this possible in inline edit?

Thanks for you help

6 Answers

0 Vote Up Vote Down

Cedric answered 5 years ago

Ok I found a way with running a sql update, on the event on_update, but the value is then reset by the end of the grid script. I know I can use the last param to false, but this will prevent updating the status field.

How can I update the value of the field within the form?

0 Vote Up Vote Down

Abu Ghufran Staff answered 5 years ago

Refer this faq: Uses onblur event to update form fields.

http://www.phpgrid.org/faqs/#80

_________________________
Abu Ghufran - Dev Team
Grid 4 PHP Framework

0 Vote Up Vote Down

Cedric answered 5 years ago

ok , I am progressing.

What if the field to update is a select ?

how do I pickup the correct value Epuise ?

$col = array();
$col[“title”] = “Status”;
$col[“name”] = “Sa_Status”;
$col[“width”] = “40”;
$col[“editable”] = true;
$col[“edittype”] = “select”;
$col[“editoptions”] = array(“value” => “:;Dispo:Dispo;Emprunte:Emprunte;Epuise:Epuise”);
$col[“stype”] = “select”;
$col[“searchoptions”] = array(“value” => “:;Dispo:Dispo;Emprunte:Emprunte;Epuise:Epuise”);
$col[“formatter”] = “select”;
$cols[] = $col;