Which entry point in UserEvent is advisable to cal...
# suitescriptt
Tyn Guardian
09/12/2022, 3:45 AMWhich entry point in UserEvent is advisable to call the record.attach?
b
battk
09/12/2022, 6:34 AMim guessing you mean on create, which means your only choices is after submit
battk
09/12/2022, 6:35 AMtheoretically you can use beforeLoad if you only need it to work in the ui, but thats really weird
t
Tyn Guardian
09/12/2022, 6:51 AMI see.. I am also attaching record on the aftersubmit. But I encounter some issue without error message
Tyn Guardian
09/12/2022, 6:51 AMApparently, I am trying to attach file to 2 records consecutively. It works in sandbox but when I deploy it in production, It doesnt work
b
battk
09/12/2022, 7:00 AMwhat does the code look like
t
Tyn Guardian
09/12/2022, 7:08 AMfunction attachFileToRecord(dealRecId, cserId, fileId, version) {log.audit({title: 'reportToAttachToRecord', details: record1: ${recordId1} record2: ${recordId2} fileId: ${fileId} version: ${version}});getGovernance();const fields = [];fields['aaa'] = fileId;fields['bbb'] = version;utility.submitFlds(customrecord_123, recordId1, fields);utility.attachFileToRecord(fileId, 'customrecord_first', recordId2);utility.attachFileToRecord(fileId, 'customrecord_second', recordId1);getGovernance();}///utility///function attachFileToRecord(fileId, recordType, recordId) {try {record.attach({record: {type: 'file',id: fileId},to: {type: recordType,id: recordId}});} catch (e) {log.debug({title: 'attachFileToRecord', details: e});}}b
battk
09/12/2022, 7:22 AMnot enough code, recordId2 and recordId1 are not defined
battk
09/12/2022, 7:23 AMcustomrecord_123 is not defined either, though i probably guess that
battk
09/12/2022, 7:24 AMI personally would toss the submitFields related code, if you think its not related to the problem
battk
09/12/2022, 7:25 AMexpect to share something that i can toss into my account
t
Tyn Guardian
09/12/2022, 7:26 AMah got it for a moment
Tyn Guardian
09/12/2022, 7:33 AMfunction attachFile(dealRecId, cserId, fileId) {const fields = [];fields['file_attachment_fld'] = fileId;attachFileToRecord(fileId, cfg.CSER.RECTYPE, cserId);attachFileToRecord(fileId, cfg.DEAL.RECTYPE, dealRecId);}function attachFileToRecord(fileId, recordType, recordId) {try {record.attach({record: {type: 'file',id: fileId},to: {type: recordType,id: recordId}});} catch (e) {log.debug({title: 'attachFileToRecord', details: e});}}function afterSubmit(context) {// dealRecordId is internal id of the other custom record// otherRecordId is internal id of the other custom recordattachFile(dealRecordId, otherRecordId, fileId);}Tyn Guardian
09/12/2022, 7:34 AMso from aftersubmit we will call another function
b
battk
09/12/2022, 8:50 AM Copy code
function attachFile(dealRecId, cserId, fileId) {
attachFileToRecord(fileId, "customrecord0", cserId);
attachFileToRecord(fileId, "customrecord1", dealRecId);
}
function attachFileToRecord(fileId, recordType, recordId) {
try {
record.attach({
record: {
type: "file",
id: fileId,
},
to: {
type: recordType,
id: recordId,
},
});
} catch (e) {
log.debug({ title: "attachFileToRecord", details: e });
}
}
function afterSubmit(context) {
// dealRecordId is internal id of the other custom record
// otherRecordId is internal id of the other custom record
attachFile("1", "6", "3143");
}battk
09/12/2022, 8:50 AMyour code is fine
battk
09/12/2022, 8:51 AMwhich suggests that either your custom records or file is different between sandbox and production
t
Tyn Guardian
09/12/2022, 9:03 AMWe are thinking maybe the folder permission is the cause.. I will try to update this convo so other will have reference.. Thank you @battk for checking this with me as well keanu thanks