Hi all,
I have a script, which basically dependant on a field value loads a related record captures some data and then populates it into a store field for displaying in a HTML field.
The script works fine in Debugger and does what I want it to but I just can;t figure out how to set it to run, I have tried FieldChanged and Pageinit but it just keeps saying that function is not referenced.
Any ideas advice please?
var NewRec = nlapiLoadRecord('customrecord_report_writing',1); nlapiLogExecution('DEBUG', 'Execution Context', nlapiGetContext().getExecutionContext() ); var getType = NewRec.getFieldValue('custrecord_rw_wpa_type'); //1=CGI,2=BT,3=LBG,4=CSC-HMPO,5=Individual@work,6=Test Record nlapiLogExecution('DEBUG', 'Type', getType); var WPAID = NewRec.getFieldValue('custrecord_rw_wpa_link'); nlapiLogExecution('DEBUG', 'WPA ID', WPAID); var WPARec = nlapiLoadRecord('customrecord_wpa_20',WPAID); if (getType == 6) { var LBGPrimaryCondition1 = WPARec.getFieldValue('custrecord_wpa_lbg_primary_condition'); var LBGSecondaryCondition = WPARec.getFieldValue('custrecord_wpa_lbg_secondary_condition'); var Workingenviroment = WPARec.getFieldTexts('custrecord_wpa_wrkstat_environment'); var Workingenviroment = Workingenviroment.join('<br>'); var LBGJobRoleInvoles = WPARec.getFieldValue('custrecord_wpa_lbg_job_roe_involves'); var LBGDSECoducted = WPARec.getFieldText('custrecord_wpa_lbg_dse_conducted'); var LBGDSEDate = WPARec.getFieldValue('custrecord_wpa_lbg_dse_date'); var LBGDSEOutcome = WPARec.getFieldValue('custrecord_wpa_lbg_dse_outcome'); var LBGbackground = WPARec.getFieldValue('custrecord_wpa_lbg_background'); var LBGrepeatReferral = WPARec.getFieldText('custrecord_wpa_lbg_repeat_referral'); var LBGPreviousAdjustment = WPARec.getFieldValue('custrecord_wpa_lbg_previous_adjustment'); var StoreFieldCode = ('<STYLE TYPE="text/css"> <!-- TD{font-family: Tahoma,Geneva,sans-serif; font-size: 8pt;} ' + 'TH{font-family: Tahoma,Geneva,sans-serif; font-size: 8pt;font-weight:bold;} ' + 'table.padded-table td { padding:10px; } table.padded-table th { padding:5px; }--->' +'</STYLE>' +'<table border="0" class="padded-table">' +'<tr>' +'</tr>' +'<tr>' +'<td><b>Primary Condition</b></td>' +'<td>'+ LBGPrimaryCondition1 + '</td>' +'</tr>' +'<td><b>Secondary Condition</b></td>' +'<td>'+ LBGSecondaryCondition + '</td>' +'</tr>' +'<td><b>Working Environment</b></td>' +'<td>'+ Workingenviroment + '</td>' +'</tr>' +'<td><b>Job Roles Involves</b></td>' +'<td>'+ LBGJobRoleInvoles + '</td>' +'</tr>' +'<td><b>DSE Conducted</b></td>' +'<td>'+ LBGDSECoducted + '</td>' +'</tr>' +'<td><b>DSE Date</b></td>' +'<td>'+ LBGDSEDate + '</td>' +'</tr>' +'<td><b>DSE Outcome</b></td>' +'<td>'+ LBGDSEOutcome + '</td>' +'</tr>' +'<td><b>Background</b></td>' +'<td>'+ LBGbackground + '</td>' +'</tr>' +'<td><b>Repeat Referral</b></td>' +'<td>'+ LBGrepeatReferral + '</td>' +'</tr>' +'<td><b>Previous Adjustments</b></td>' +'<td>'+ LBGPreviousAdjustment + '</td>' +'</tr>' +'</table> '); NewRec.setFieldValue('custrecord_rw_html_store_field',StoreFieldCode); } else { var Condition = WPARec.getFieldValue('custrecord_wpa_condition'); var Workingenviroment = WPARec.getFieldTexts('custrecord_wpa_wrkstat_environment'); var Workingenviroment = Workingenviroment.join('<br>'); var JobRoleInvolves = WPARec.getFieldTexts('custrecord_wpa_client_job_role_involve'); var JobRoleInvolves = JobRoleInvolves.join('<br>'); var ImpactOnWork = WPARec.getFieldValue('custrecord_wpa_condition_imp_job'); var WorkStatsetup = WPARec.getFieldTexts('custrecord_wpa_client_workstation_setu'); var WorkStatsetup = WorkStatsetup.join('<br>'); var NonPhysadjustment = WPARec.getFieldValue('custrecord_wpa_client_workstation_setu'); var StoreFieldCode = ('<STYLE TYPE="text/css"> <!-- TD{font-family: Tahoma,Geneva,sans-serif; font-size: 8pt;} ' + 'TH{font-family: Tahoma,Geneva,sans-serif; font-size: 8pt;font-weight:bold;} ' + 'table.padded-table td { padding:10px; } table.padded-table th { padding:5px; }--->' +'</STYLE>' +'<table border="0" class="padded-table">' +'<tr>' +'</tr>' +'<tr>' +'<td><b>Primary Condition</b></td>' +'<td>'+ Condition + '</td>' +'</tr>' +'<td><b>Working Environment</b></td>' +'<td>'+ Workingenviroment + '</td>' +'</tr>' +'<td><b>Job Roles Involves</b></td>' +'<td>'+ JobRoleInvolves + '</td>' +'</tr>' +'<td><b>How Does Condition Impact Job</b></td>' +'<td>'+ ImpactOnWork + '</td>' +'</tr>' +'<td><bWork Station Setup</b></td>' +'<td>'+ WorkStatsetup + '</td>' +'</tr>' +'<td><b>Non-physical Adjustments In Place</b></td>' +'<td>'+ NonPhysadjustment + '</td>' +'</tr>' +'</table> '); NewRec.setFieldValue('custrecord_rw_html_store_field',StoreFieldCode); } nlapiSubmitRecord(NewRec,true); }