We are interested in renewing our subscription for RSForm and RSMail but one thing is still puzzling and preventing us from doing so. We want to create dropdown and cascading dropdowns using values from a lookup database. Can this be done and how?

Hi

There is guidance here:
www.rsjoomla.com/support/documentation/r...external-tables.html

I was able to create a table using PHPmyadmin and import CSV into table. This table can be displayed in Joomla 4 using droptable to confirm table content and layout.

However, I have not been able to get script to work yet and have raised a ticket.

Will provide update when I get this working.

I will also be raising a topic in this forum to see if anyone has successful adapted guidance to import data in dropdown field using a CSV file.

Kind regards

UPDATE::

I got a response from my ticket:
"What you're looking for would be RSForm!Pro instead, and an example to populate data from a table can be found here:
www.rsjoomla.com/support/documentation/r...st-from-a-table.html
Please however note that you'll need to ensure the query is correctly specified (basic MySQL/PHP knowledge is eventually required)."

I finally got instructions to work by changing this line:

$db->setQuery("SELECT your_value, your_label FROM #__your_table");

to

$db->setQuery("SELECT your_value, your_label FROM your_table");

Hope this helps.