Upvote 1

Values on multiple Drop downs/Radio buttons give single value

Need Answer Lfo 2 years ago

Hi,

I am trying to grab the values on multiple Select/Radio buttons, which then on validation translates to a specific single value in a text box. See attached file.

  1. DROP-DOWN1: 35 cm
  2. DROP-DOWN2: 48 cm
  3. RADIO BUTTON1: UDEN AFLØBSUDSKÆRING
  4. RADIO BUTTON2: GLAT

1+2+3+4 = M02

Many thanks.

Replies (5)
photo
1

Hello, could you tell us if the values you are trying to sum have a fixed result?

could you attach your vp?

Thanks.

photo
1

Hi Ria

Many thanks for your help.

Attached is my VP.

In the drop dows, there are fixed values, as well as in the buttons of course. The combinations I am looking for are like the below (just 3 exmaples):


35cm + 48cm + "Med afløbsudskæring" = M02

35cm + 64cm + "Med afløbsudskæring" = M05

44cm + 48cm + "Med afløbsudskæring" = M08


I am basicially trying to do the following:

IF "Dybde" is 35cm AND "Højde" is 48cm AND "Med afløbsudkræring" is cheched THEN show "M02-" in the text field by "Artikelnummer". Then do the same for the other combinations. (I am not using the last radio buttons ("Front") in the query for now)


Hope it makes sense :-)

photo
2

Hello, I leave you an example, you can see attached to the select list and the radio list an event that creates a variable that concatenates all the selected options, and in the text, the event that gives a fixed value to the result depending on the variable.

Let me know if this information is useful.

Greetings.

photo
1

Hi Ria

Perfect, many thanks for this. I actually did something similar but somehow it didn't show the intended result. This works great and I really appreciate you finding the time to solve this.

photo
2

Hi, you're welcome!

Let us know if we can help you with anything else.

Greetings.

Leave a Comment
 
Attach a file