On the example given by the original content, i can see how i can do it for only one column.
But how can i perform a autocomplete feature on multiple fields?
Just apply these settings with columns where you want autocomplete.
$col["formatter"] = "autocomplete"; // autocomplete
$col["formatoptions"] = array( "sql"=>"SELECT client_id, name FROM clients",
"update_field" => "client_id"); // make sure this ID column exist with each autocomplete.
Let me know in case of further issue.
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?