Autocompleter [CF5 or CF6]

Hi to all,
is a bit of time that I had no need to use Autocompleter.
A few years ago I also made a tutorial that you can find here:
https://www.chronoengine.com/forums/posts/f9/t88300.html?page=1

Now I can not find how to implement it with versions of CF5 and CF6.
Can you give me a tip?

Best Regards.
Gioacchino

Hi Gioacchino,

The completer data is static or will be loaded from a database table ?

Best regards,
Max

Hi Max,

will be loaded from a database table.

Rgds
Gioacchino

Hi Gioacchino,

In v6, please drag a dropdown element, open the "Advanced" area, set the "Auto completer" event to say "auto" and the minimum characters to "1" or leave it at 0.

Now under the "Events" section of the FORM, create a new event named "auto", then drag a "read data" action inside it, set the "model name", select the table and any conditions you need, set the "select type" to "Key/val array" and in the "Fields to retrieve", write two fields in two lines, say:

Model.id
Model.title

Then drag a "custom code" action and write this:

{var/jsonen:read_data_action_name}

That should do it, where "read_data_action_name" is the name of the read data action, which is shown with a black label.

Best regards,
Max

:cry:
Hi Max.
Don't work.
See video[youtube]39NsRzVG32c[/youtube]
:? 😢
Best Regards
Gioacchino

Hi Jack,

Your config is correct after the Model name fix at the end of the video, but I found a bug in the code, this is why it didn't work for you, I have fixed this here and have created a demo form too, would you like to have them now or wait for the next official update ? if now then please send me a message using the contact us page.

Which software do you use to create the video ?🙂

Best regards,
Max

Hi Max,
if the update is not too far I can wait

for recording video on the fly using this online software:
https://www.apowersoft.it/registratore-gratuito-online-dello-schermo

Otherwise use Camtasia + Premiere

Can you let me know when you expect the new update?

Tank You
Best Regards
Gioacchino

Hi Gioacchino,

The new update is supposed to be ready by the next week, if not then please send me a message and I will send you the latest files.

And thank you very much for the software tips.

Best regards,
Max