Forums

Dropdown with db read autocompleter

giovannigenua13 14 Jun, 2023
Dear forum members,

I hope this message finds you well. I am seeking assistance regarding the implementation of an autocomplete dropdown list with ChronoForms 7. In the past, I successfully implemented this feature using ChronoForms 6, but I am facing difficulties understanding how it works in the latest version, ChronoForms 7.

Specifically, I would like to create a dropdown list that autocompletes data retrieved from a database table. I have reviewed the documentation and explored the functionalities of ChronoForms 7, but I haven't been able to grasp the exact steps required for achieving this.

If anyone has experience or knowledge regarding the implementation of an autocomplete dropdown list in ChronoForms 7, I would greatly appreciate your guidance and assistance. Here are some specific questions I have:

How can I create an autocomplete dropdown list using ChronoForms 7?
What are the steps involved in retrieving data from a database table and populating the dropdown list?
Are there any specific settings or configurations within ChronoForms 7 that need to be considered for implementing this feature?
Any advice, code snippets, or pointers to relevant documentation would be highly appreciated. I'm open to learning and exploring different approaches to achieve the desired functionality.

Thank you all in advance for your support. I look forward to your valuable insights and suggestions.

Best regards,
Max_admin 10 Jul, 2023
Hi Giovanni,

In the dropdown advanced settings choose "Auto complete", in the "Page" option choose the form page where you will provide the results, this is working in this way:
  • when you write 2 characters, the dropdown will make an ajax request to the "auto complete" page
  • the auto complete page should have a PHP action which will return a json list of options, the list can be provided by a "Read Data" action for example
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
You need to login to be able to post a reply.