Changing to Numeric data type before sending JSON to salesforce

Forum|Forum|2 years ago
February 15, 2023
2 replies
43 views

+1

JakeSosine

Hey all,
Have a question regarding datatypes in qualtrics. I have a field in qualtrics that has validation set to content type and number with a minimum value above zero and a maximum value below 10000000.
This data field eventually has a workflow that sends it to salesforce, but salesforce rejects any value that has a comma in it (e.g., 100,000). Is there a way to maintain the data validation in qualtrics, drop the comma, and just send the numeric value in the JSON?

+27

TomG
Level 8 ●●●●●●●●
Forum|Forum|2 years ago
February 15, 2023

You could add this JS to the question:
Qualtrics.SurveyEngine.addOnPageSubmit() {
var input = jQuery("#"+this.questionId+" .InputText");
input.val(input.val().replace(/,/g,"");
});