Where conditions and Dropdown

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?

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

Hi, admin

Thanks for the advice.

Data is dropdown 2 not confined to the name 😟


If interested, I can send the form

Hi Maxvl,

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

Best regards,
Max

Hi admin

Did as indicated on pages 38-39 of the manual

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

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

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

Hi Max,

Tried in different ways. Did not work

Any help out here?

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

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

Hi Maxvl,

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

Best regards,
Max

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

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

Hi Max

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

Please, help

Best regards,
Maxvl

The field named "s" is passing "Plumber" ?

Best regards,
Max