1 ACCEPTED SOLUTION
Small change in my Script & it worked fine for me
-> I added size bytes for the current file also, I forgot it earlier
(function executeRule(current, previous /*null when async*/ ) {
// Define your limit in bytes (e.g., 10MB)
var maxSize = 18 * 1024 * 1024; // 18 MB
var totalSize = 0;
var gr = new GlideRecord("sys_attachment");
gr.addQuery("table_sys_id", current.table_sys_id);
gr.query();
while (gr.next()) {
totalSize = totalSize + parseInt(gr.size_bytes);
}
totalSize = totalSize + parseInt(current.size_bytes);
if (totalSize > maxSize) {
gs.addErrorMessage('Total Attachment size exceeds the limit of 18 MB.'); // User-friendly message
current.setAbortAction(true); // Prevents the attachment from being saved
}
})(current, previous);
Output: I tried to add 3rd file and it exceeded 18MB and error message thrown and file not added
💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏
Hello @Raze00 ,
Yes this can be achieved using Before business rule . I Implemented this on incident table .
you can refer following code :
(function executeRule(current, previous /*null when async*/ ) {
var gr = new GlideRecord('sys_attachment');
gr.addQuery('table_sys_id', current.sys_id);
gr.addQuery('table_name', current.getTableName());
gr.query();
var size = 0;
while (gr.next()) {
size += gr.size_bytes;
}
if (size > 18* 1024 * 1024) {
// greater than 18 MB
gs.addErrorMessage('File size is greater than 18 MB');
current.setAbortAction(true);
} else {
gs.addErrorMessage('File size is within limit');
current.setAbortAction(false);
}
// Add your code here
})(current, previous);
If this helps you then mark it as helpful and accept as solution.
Regards,
Aditya,
Technical Consultant
