Hi,
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?
Regards.
2 Answers
Hello,
Just apply these settings with columns where you want autocomplete.
$col["formatter"] = "autocomplete"; // autocomplete
$col["formatoptions"] = array( "sql"=>"SELECT client_id, name FROM clients",
"search_on"=>"name",
"update_field" => "client_id"); // make sure this ID column exist with each autocomplete.
Let me know in case of further issue.
Your Answer