There is an embedded data that I am outputting in a Text/Graphic box and in the question. For ease of reading, I would like to format this as a currency - or at the very least with thousand comma separators.
What would be the best way of handling this? I've looked around and couldn't find any code samples on this (most of the code samples involved formatting input fields, not embedded data).
I think the "toFixed(2)" in the code was making it do decimals instead of commas. I tweaked to this and it worked:
Qualtrics.SurveyEngine.addOnload(function() {
jQuery("#number").text("$"+parseFloat("${e://Field/NameofField}")
.toLocaleString("en-US"));
});
TomG Sorry, I went to the article, but I'm still perplexed. I couldn't decipher why I didn't get a comma? I'm in the US, using English as my browser language.
https://community.qualtrics.com/XMcommunity/discussion/comment/38803#Comment_38803It depends on the browser and the default locale. See: https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Number/toLocaleString
TomG
Found this and loved your coding...BUT, I get the $ and the Decimal point, but not the comma? What am I missing?
bansalpeeyush29: That's a good point - I had issues at first since this suggestion wouldn't work at all with a CSV - but then I realized Qualtrics uses TSV for importing as well.
```
<span id="mynumber">mynumber</span>
```
Use JS to format the number and replace the span contents:
```
Qualtrics.SurveyEngine.addOnload(function() {
jQuery("#mynumber").text("$"+parseFloat("${e://Field/mynumber}").toFixed(2).toLocaleString());
});
```
Leave a Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.