Pipe in highest value from a side-by-side question

TomG PeeyushBansal Could you please have a look

Try this:
Qualtrics.SurveyEngine.addOnPageSubmit(function() {
var val, highest = 0;
jQuery("#"+this.questionId+" select").each(function() {
if((val=parseInt(this.value)) > highest) highest = val;
});
Qualtrics.SurveyEngine.setEmbeddedData('highest',highest);
});

Hi TomG . Thank you for the reply. Somehow the embedded value I am getting is the actual value + 1. For example, If the highest value among 4 scales is 5, the embedded field is populating highest as 6. How to fix this.

https://community.qualtrics.com/XMcommunity/discussion/comment/47944#Comment_47944I was afraid of that. It is because you somehow edited the options so that the value (choice id) doesn't match the option text. Replace

this.value

this.options[this.selectedIndex].text

Awesome. It is working fine now TomG. thank you so much.
I have a few doubts:

1. Would this embedded field 'highest' be available in the excel file when exported?


2. Would this field 'highest' can be used in a math operation where it would be like

1. Also, right now it is pulling the highest from the entire statements, right? There are like 18 statements in the side-by-side question. For getting the highest value for each statement, would I have to split the question into 18 questions or Is there another way to find the highest value for each statement that can be a new embedded value (so total of 18 embedded values).

Would this embedded field 'highest' be available in the excel file when exported?

Would this field 'highest' can be used in a math operation where it would be like

Also, right now it is pulling the highest from the entire statements, right? 

... or Is there another way to find the highest value for each statement that can be a new embedded value (so total of 18 embedded values).

Thank you TomG for explaining everything

@TomG Hi Tom. Could you please help on this? For a matrix type question how to create embedded data based on the Max score selected from the responses in A, B, C and D.

And if this is a loop and merge question where this question there would be shown 10 times would 10 embedded data be created?

@TomG Hi Tom. Could you please help on this? For a matrix type question how to create embedded data based on the Max score selected from the responses in A, B, C and D.

And if this is a loop and merge question where this question there would be shown 10 times would 10 embedded data be created?

I have a function, matrixHiLo, that does this. For a loop, you could pipe a loop field into the function prefix option to record embedded data for each loop.

Thank you so much Tom