Forums

Where conditions and Dropdown

Maxvl 22 Aug, 2017
Hello!

I have a Dropdown (name – DN1)
and have Dropdown (name – DN2) populated through a DB
I want the selection from this Dropdown of DB by value from Dropdown (DN1)

Where conditions
table.name/LINK:{data:DN1}
does not work

Any help out here?
Max_admin 23 Aug, 2017
Hi Maxvl,

You need to reload dropdown 2 based on dropdown 1, this is explained in the v6 manual, please download and check it.

Best regards,
Max
Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
Maxvl 23 Aug, 2017
Hi, admin

Thanks for the advice.

Data is dropdown 2 not confined to the name 😟


If interested, I can send the form
Max_admin 24 Aug, 2017
Hi Maxvl,

But did you check the "Element reloading" section in the manual ?

Best regards,
Max
Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
Maxvl 24 Aug, 2017
Hi admin

Did as indicated on pages 38-39 of the manual
Max_admin 31 Aug, 2017
Hi Maxvl,

The new update has a dynamic dropdown demo form which you can test quickly, it's supposed to be available later today or tomorrow.

Best regards,
Max
Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
Maxvl 08 Sep, 2017
Hi Max,

Thanks for dynamic dropdown demo.

In my case, dynamic data is taken from the database.

Please see my first message of the topic

Best regards,
Maxvl
Max_admin 08 Sep, 2017
Hi Maxvl,

Then you can use a "Read data" action to read the records and supply the value in the "Options" field of the target dropdown.

Is it possible for you to post screenshots of your settings ?

Best regards,
Max
Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
Maxvl 09 Sep, 2017
Hi Max,

Tried in different ways. Did not work

Any help out here?
Max_admin 20 Sep, 2017
Hi Maxvl,

If the "Read data" is before the "Display section" then you can use {var:read_data_name} in the "options" box of the dropdown, just make sure that you replace the "read_data_name" with your read data action name.

Best regards,
Max
Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
Maxvl 21 Sep, 2017
Hello

Help, what is not so able conditions?

2_snform.S0:Plumber/LIKE:%{data:Plumber}%

Data is not limited to the value - Plumber

Best regards,
Maxvl
Max_admin 24 Sep, 2017
Hi Maxvl,

Your conditions format is wrong, what is the field name and what condition are you trying to use exactly ?

Best regards,
Max
Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
Maxvl 27 Sep, 2017
Hello!

Objective
Limit values from the database to the value specified by the user in Dropdown

Сonditions
In the table 2_snform on the column S0 with the value of Plumber, limit the output of the data if in Dropdown the value of Plumber

Thanks for any help

Best regards,
Maxvl
Max_admin 29 Sep, 2017
Hi Maxvl,

Your field name is "s", so you will be using {data:s} to get its value.

Then the conditions should be:
2_snform.S0:{data:s}

Select records where S0 = dropdown value

Best regards,
Max
Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
Maxvl 29 Sep, 2017
Hi Max

It did not work out for some reason. Data is not displayed

Please, help

Best regards,
Maxvl
Max_admin 03 Oct, 2017
The field named "s" is passing "Plumber" ?

Best regards,
Max
Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
This topic is locked and no more replies can be posted.