Autocomplete function on CB query field

Ive got a query for my column cb_rdapartnernr(lik user_id) thats it unique. My sql query works fine an tells the editor when the rdapartnernr is in used.
But now is it possible to show or insert automaticly a free number names rdapartnernr ? Can u give me an explain?

The autocomplete feature only applies to text fields. When the user begins typing it can suggest values for them to select which will insert into the text field. It will not limit them to only using those selections. So with that said simply edit your text field then under Integrations > CB Query Field > Auto Complete you can configure it as follows.

Query Auto Complete: Enable
Query: Value Column: id
Label Column: username
Minimum Length: 3

With the above example it would autocomplete a users username and store the users user id. The "Value Column" parameter determines what is inserted into the text field while "Label Column" is just for display purposes. So if you need it to insert some sort of new number based off the current numbers you'll need to generate that and return it in your SQL.

Aha ok. So it is possible to suggest a free number inside the column thats is not in use?

Yes, I assume you've a database table with those free numbers listed somewhere? If so you'd just make sure your query is querying that table and joining _comprofiler to check that it doesn't exist before suggesting it.

wegda wrote: Aha ok. So it is possible to suggest a free number inside the column thats is not in use?

This video should help