Log in to AnswerLog in to Follow
UserImage.jpg
Gerantina Hoxha
52Views
4Comments
Solved
Dropdown choice to multiple variables
Question
Beginner
Best Practices

Hello everybody,

I have a dropdown which is a table from database. After the user selects a row I'm able to assign one variable = 1 column of the row selected. How can I assign the rest of the columns which belong to this row to other variables?

I thank you in advance.


0
0
01 Jun 2021
2020-07-02 13-32-59
Max de Groot
Solution

Hi Gerantina,

If you want to assign the other values to local variables create an OnChange (for dropdown) event for the product that you are clicking on. Behind this action simply use an assign to assign the values from the table to var1, var2 and var3 etc. You would know the Id for the selected product from the value in the dropdown. Filter the table and assign the values.


Max

See solution in context
0
0
01 Jun 2021

Hi Gerantina,

Can you elaborate your question, 

What I understood from your question is you want to assign the selected record from drop down to local variable?

Is that correct?

Kind Regards, 

0
0
01 Jun 2021

Hi Komal,

Thanks for your reply. I have a dropdown of a similar table. And a user chooses lets say Product 1 and that I have already assigned to a variable ProcutVar. What I would like to do is then assign to other variables the other columns of this table. For this example I would assign Var1= Charateric 1, Var2 =Charateric 2, Var3= Charateric 3. 

Would look like this: for user choosing Product 1,  ProductVar= Product1, Var1= P1_C1, Var2= P1_C2, Var3= P1_C3. 

0
0
01 Jun 2021
2020-07-02 13-32-59
Max de Groot
Solution

Hi Gerantina,

If you want to assign the other values to local variables create an OnChange (for dropdown) event for the product that you are clicking on. Behind this action simply use an assign to assign the values from the table to var1, var2 and var3 etc. You would know the Id for the selected product from the value in the dropdown. Filter the table and assign the values.


Max

0
0
01 Jun 2021

Sorry to open this question again.  So I have the same question. I have tried to do what was recommended. But I am struggling.

Is there no example of exactly what to do. I understand perfectly what is being recommended, but I don't know how to do it.

Is there an example or video that can be posted. 


Many thanks

0
0
05 May
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.