Javascript for adding symbols before and after fields in just one column of a 3D Matrix | Experience Community
Skip to main content
Solved

Javascript for adding symbols before and after fields in just one column of a 3D Matrix

  • August 20, 2020
  • 7 replies
  • 306 views
MatthewM
Level 6 ●●●●●●
Forum|alt.badge.img+30

I've previously used the following code in a survey to insert $ and .00 around all text fields in a 3D Matrix.
Qualtrics.SurveyEngine.addOnload(function()
{
var inputs = $(this.getQuestionContainer()).select('input[type="text"]');

for (var i = 0; i < inputs.length; i++) {
 var input = inputs[i];
 $(input).insert({before: '$ '});
 $(input).insert({after: ' .00'});
}

});

My problem now is that I have a 3D Matrix question with two columns, but I would only like the symbols to be applied to the second column. What do I need to change in my Javascript to make it happen? (Thank you in advanced if you can help.)

Best answer by SurajK

https://www.qualtrics.com/community/discussion/comment/29369#Comment_29369Ok, so in this case we can add 2 extra lines for the total box and using index we can add the symbols like below, as per your screenshot, the total box has index 6.
Qualtrics.SurveyEngine.addOnload(function()
{
var inputs = $(this.getQuestionContainer()).select('input[type="text"]')
for (var i = 1; i < inputs.length; i+=2) {
 var input = inputs[i];
 $(input).insert({before: '$ '});
 $(input).insert({after: ' .00'});
}
jQuery('input[type="text"]').eq(6).before('$')
jQuery('input[type="text"]').eq(6).after(' .00')
});

7 replies

SurajK
QPN Level 3 ●●●
Forum|alt.badge.img+4
  • SurajK
  • QPN Level 3 ●●●
  • August 20, 2020

Hi MatthewM ,
Just change the for loop, you will see the symbols added in 2nd column only.
Qualtrics.SurveyEngine.addOnload(function()
{
var inputs = $(this.getQuestionContainer()).select('input[type="text"]');
for (var i = 1; i < inputs.length; i+=2) {
 var input = inputs[i];
 $(input).insert({before: '$ '});
 $(input).insert({after: ' .00'});
}
});

MatthewM
Level 6 ●●●●●●
Forum|alt.badge.img+30
  • MatthewM
  • Author
  • Level 6 ●●●●●●
  • August 20, 2020

Thank you SurajK!
I used the code and it adds $ and .00 on the text input fields, but took it away from the Total line. Is there a way to insert these on the Total line too?
image.png

SurajK
QPN Level 3 ●●●
Forum|alt.badge.img+4
  • SurajK
  • QPN Level 3 ●●●
  • Answer
  • August 20, 2020

https://www.qualtrics.com/community/discussion/comment/29369#Comment_29369Ok, so in this case we can add 2 extra lines for the total box and using index we can add the symbols like below, as per your screenshot, the total box has index 6.
Qualtrics.SurveyEngine.addOnload(function()
{
var inputs = $(this.getQuestionContainer()).select('input[type="text"]')
for (var i = 1; i < inputs.length; i+=2) {
 var input = inputs[i];
 $(input).insert({before: '$ '});
 $(input).insert({after: ' .00'});
}
jQuery('input[type="text"]').eq(6).before('$')
jQuery('input[type="text"]').eq(6).after(' .00')
});

    MatthewM
    Level 6 ●●●●●●
    Forum|alt.badge.img+30
    • MatthewM
    • Author
    • Level 6 ●●●●●●
    • August 21, 2020

    That did it! Thank you so much!

    A
    Forum|alt.badge.img
    • Abi
    • August 25, 2020

    SurajK How are you buddy?
    I wanted to check how to program the distinct signs/text per column. Please see screenshot to give you the graphic:
    image.pngAppreciate your kind help in advance! :)
    Best,
    Abhi

    SurajK
    QPN Level 3 ●●●
    Forum|alt.badge.img+4
    • SurajK
    • QPN Level 3 ●●●
    • August 26, 2020

    Abi - I'm good, hope you are doing well too!
    You can use the below code to insert the text before and after the open end, as per your screenshot.
    Qualtrics.SurveyEngine.addOnReady(function()
    {
    //First Column
    jQuery('#'+this.questionId+' tbody tr .c4 input[type="text"]').after('% increase in ORR')
    jQuery('#'+this.questionId+' tbody tr .c4 input[type="text"]').before('Absolute')
    //Second Column
    jQuery('#'+this.questionId+' tbody tr .c5 input[type="text"]').after('months over SoC')
    jQuery('#'+this.questionId+' tbody tr .c5 input[type="text"]').before('+')
    //Third Column
    jQuery('#'+this.questionId+' tbody tr .c6 input[type="text"]').after('months over SoC')
    jQuery('#'+this.questionId+' tbody tr .c6 input[type="text"]').before('+')
    //Fourth Column
    jQuery('#'+this.questionId+' tbody tr .c7 input[type="text"]').after('% decrease in grade 3-4 TRAE')
    jQuery('#'+this.questionId+' tbody tr .c7 input[type="text"]').before('Absolute')

    });

      LouRisc
      Level 1 ●
      Forum|alt.badge.img+1
      • LouRisc
      • Level 1 ●
      • March 15, 2022

      https://community.qualtrics.com/XMcommunity/discussion/comment/29368#Comment_29368Hello SurajK,
      I just applied your code (quoted here) to a side by side question in my survey that has several columns. I wanted to see if it would work on my second column only (the first has essay open-ended text fields, the second has medium open-ended text with numerical validation, and the third consists of a drop down list). Much to my delight, the "$ " and the " .00" applied only to the appropriate column (#2). However, it only applied itself to alternating rows. In my experimenting, I changed the last number in this line from 2 to 1:
      for (var i = 1; i < inputs.length; i+=1) {
      To my surprise, that worked, with one remaining issue. The "$ " and the " .00" are now applied to every row except the very first row. My tinkering has not solved this problem. Do you have any advice?
      Thank you!

      Terms & ConditionsAccessibility statement