Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Incrementing a var field
Hi,
I have a script which is taking a value from a integer field into var QACurrentCounter and then creating a new var QANewCount by incrementing the result of the original field by 1.
Seems to work ok when the original value is 0 but when the original value is 1 the result comes out as 11. I am assuming that the var is holding the value as a string but can't find any help as to what I need to do to keep it as a integer value.
function ChangeAssField(type, fld) { var CurrentRec = nlapiGetRecordId(); if (fld=='custrecord_bsb_assessor') { var AssRecord_id = nlapiGetFieldValue('custrecord_bsb_assessor'); var OrigRec = nlapiLoadRecord('customrecord_bens_sandbox', CurrentRec); //Capture Original Record var AssRec = nlapiLoadRecord('customrecord_assessor_record', AssRecord_id); //Capture Assessor Record var QACurrentCount = AssRec.getFieldValue('custrecord_ass_qa_counter'); //Get Value of QA Count var QAMax = AssRec.getFieldValue('custrecord_ass_rep_to_qa'); //Get Value of QA Max var QANewCount = QACurrentCount+1; var QAPercentage = (QANewCount/QAMax)*100; alert(QACurrentCount); alert(QANewCount); alert(QAPercentage); if (QAPercentage>0 && QAPercentage<=100) { AssRec.setFieldValue('custrecord_ass_qa_counter', QANewCount); //Set Counter on Assessor Record to 2 nlapiSetFieldValue('custrecord_bsb_qa_required', 'T'); //Set QA required on original record to True } else if (QAPercentage=100) AssRec.setFieldValue('custrecord_ass_qa_counter', 0); var idorig = nlapiSubmitRecord(OrigRec,true); var idass = nlapiSubmitRecord(AssRec,true); 0