Hi all
I am hoping someone can help me.
I have a custom record on my account that logs scores from a web form. These are all held in individual Integer Number fields and I want to create an average score with my script based on the number of answers given.
Being SuiteScript2.0 I was under the impression that the data type should be consistent with the field type so that the getValue for these integer fields will already be a number type, however this does not seem to be the case. I have logged various parts of this script and the getValue is working (for example I set the field value of 'custrecord_cs15_inc_everything' to 8, and it logs 8 for quoteIncludeAll), bit when I get to the if(xxxxxxxx > 0) bit it doesnt recognise this as a number so the 'if' is always false.
I have tried Number() to force the values to be numbers, but it throws an error when I try to set the value at the end of the code.
Here is a sample of my script:
var quoteDenom = 0; var quoteIncludeAll = surveyRecord.getValue('custrecord_cs15_inc_everything'); if (quoteIncludeAll > 0){ quoteDenom++; } var quotedQuick = surveyRecord.getValue('custrecord_cs15_quote_quick'); if (quotedQuick > 0){ quoteDenom++; } var easyToUnderstand = surveyRecord.getValue('custrecord_cs15_easy_understand'); if (easyToUnderstand > 0){ quoteDenom++; } if (quoteDenom >= 1){ var quoteAverage = twoDP((quoteIncludeAll + quotedQuick + easyToUnderstand)/quoteDenom); surveyRecord.setValue('custrecord_cs15_quote_average',quoteAverage); }Any help would be appreciatedPeter