Buy Now
Sign in

how to display a value in a table after selecting an option in a dropdown

indesweb , September 08 2017
indesweb
Good Morning
I wanted to do one thing and I do not know how it is done
I have a table made with factory, address, population ..
and in the form I want you to select a factory, automatically show the address, population ... of that factory.

I tried to do it as with two drop-downs, but in the field_text and put in value what in a drop-down we put in options but it does not work, and I do not know where to put {var: read_dataXX}

can someone tell me how I can do this, please

Thanks in advance
indesweb
I have not got anything yet and I have found a thread that will help me.

someone knows how to display fields that follow a field in another table.

in the drop-down I already have with the read data select a factory, what I need is that I load the data I have from that factory, address, zip code ...

does anyone know any way to do that?
indesweb
I select option in dropdown and load all the form

Good morning,
I'm putting some dynamic drop-downs to the same table since nobody gives me a solution to choose the drop-down option and it shows some values.
The problem is that I select option in dropdown 1 and it loads me into the whole web page. Why does that happen?

Any solution?
indesweb
Hello everyone. I've been trying to solve the problem all week and it has not been successful. nor did anyone suggest any possible solutions to prove.
Attached images of my configuration and the error that gives. I hope other eyes are able to find the error because I am not able. I see it the same all the time. and the result is always bad.

Hope someone can help me.
Attachments
chronofomrs_error_dynamic_dropbox_Pgina_01.png
chronofomrs_error_dynamic_dropbox_Pgina_01.png
(187.91 KiB)
699 Downloads/Views
chronofomrs_error_dynamic_dropbox_Pgina_02.png
chronofomrs_error_dynamic_dropbox_Pgina_02.png
(184.2 KiB)
681 Downloads/Views
chronofomrs_error_dynamic_dropbox_Pgina_03.png
chronofomrs_error_dynamic_dropbox_Pgina_03.png
(252.05 KiB)
675 Downloads/Views
chronofomrs_error_dynamic_dropbox_Pgina_04.png
chronofomrs_error_dynamic_dropbox_Pgina_04.png
(330.61 KiB)
676 Downloads/Views
chronofomrs_error_dynamic_dropbox_Pgina_05.png
chronofomrs_error_dynamic_dropbox_Pgina_05.png
(365.74 KiB)
682 Downloads/Views
chronofomrs_error_dynamic_dropbox_Pgina_06.png
chronofomrs_error_dynamic_dropbox_Pgina_06.png
(416.16 KiB)
673 Downloads/Views
chronofomrs_error_dynamic_dropbox_Pgina_07.png
chronofomrs_error_dynamic_dropbox_Pgina_07.png
(359.84 KiB)
671 Downloads/Views
chronofomrs_error_dynamic_dropbox_Pgina_08.png
chronofomrs_error_dynamic_dropbox_Pgina_08.png
(190.21 KiB)
663 Downloads/Views
chronofomrs_error_dynamic_dropbox_Pgina_09.png
chronofomrs_error_dynamic_dropbox_Pgina_09.png
(206.75 KiB)
650 Downloads/Views
chronofomrs_error_dynamic_dropbox_Pgina_10.png
chronofomrs_error_dynamic_dropbox_Pgina_10.png
(214.21 KiB)
638 Downloads/Views
chronofomrs_error_dynamic_dropbox_Pgina_11.png
chronofomrs_error_dynamic_dropbox_Pgina_11.png
(335.88 KiB)
643 Downloads/Views
indesweb
Hello everybody!!
finally after a week I found the error that you can see on page 8, I put the event in autocomplete not in reload event!
I looked at him so many times that I always looked good ..

That corrected error, only now shows me the field that I want strangely. I attached a photo to see if someone else has happened before and can tell me that I have bad.

My settings are in the photos I uploaded last week.

Thanks in advance to anyone who can help me
Attachments
chronofomrs_error_dynamic_dropbox_Pgina_12.png
chronofomrs_error_dynamic_dropbox_Pgina_12.png
(168.65 KiB)
641 Downloads/Views
indesweb
I have rescheduled all the sections where keys are to be placed {} and the problem has been solved.
V
vividal

did you ever get this working? I am having an issue where after I make a choice in the 1st field, the 2nd field becomes empty. How did you get it to populate the 2nd field?

indesweb

Hello!​
​Yes, I got it, and I've used it many times in the same form.​
​You first check that all the pullouts work independently, so we will rule out failure to extract the values in the drop-down when the database reads it.​
​After everything works independently, we will make sure that the second drop-down calls an event that has the following:​
​Setup: new event: Ex: "DESPLEGABLES"​
​​
​1: read data -> the one we used to check what we put here if you had not put it Ex: Read_data20​
​1.1: Where conditions: make sure that you get it right that you read the name of the first drop-down to compare it with the column of your database: Ex: 1_dropdown_columnadb: {[data: 1_dropdown_name}​
​2: couston code-> we'll say you have to show the second drop-down. Make sure to put well what number you have, that sometimes we put one wrong. Ex: {view: field_select12}​
​** Remember to put it BEFORE the "Display Section" otherwise it will not work.​
​Designer:​
​1_dropdown: you already have to have your database assigned​
​options {var: read_data15}​
​!!! Events​
​On "change" Actions "Reload" values "" "element" 2_dropdown_name "​
​2_dropdown: Options {var: read_data20}​
​!!! Advanced: reload event: UNFOLDABLE​
​​
​If you want to repeat the action, you just have to create new events and in the first drop-down, put the corresponding event.​
​The idea is the following: when you select a value in the drop-down1 that the value of the condition in the drop-down2 is loaded.​
​If you do not want to leave only 1 value, do not put conditions in the read data of the second drop-down.​
​Do not forget to put the '{' '}' well that by putting a bad one I went crazy.

I hope that my mini tutorial will help you.

Greetings, and good luck!