Hi ,
I am trying to identify the line of code in the start script to move the initial purge line about 3-5mm further into the Y direct of the plate.
I bought the 3d Effect Sheet and the purge line is exactly in between the metal sheet and the 3d sheet causing it not to stick rpoperly and pulling debris into the print.
/**
function sendEmailAlerts() {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var lastRow = sheet.getLastRow(); // Get the last row with data
var email = sheet.getRange(“M2”).getValue(); // Get email from cell M2
var today = new Date(); // Current date
for (var i = 2; i <= lastRow; i++) {
var dueDate = sheet.getRange(i, 6).getValue(); // Get due date from Column F
var companyName = sheet.getRange(i, 3).getValue(); // Get company name from Column C
var emailCount = sheet.getRange(i, 14).getValue(); // Get email count from Column N (adjust as needed)
// Initialize the email count if it's empty
if (!emailCount || isNaN(emailCount)) {
emailCount = 0;
}
if (dueDate instanceof Date) {
var diffDays = Math.floor((dueDate - today) / (1000 * 60 * 60 * 24)); // Calculate difference in days
// Only send the email if the due date is within 30 days and the email hasn't been sent 3 times yet
if (diffDays <= 30 && diffDays >= 0 && emailCount < 3) {
var subject = "Reminder " + (emailCount + 1) + ": The agreement is due for " + companyName + " in " + diffDays + " days.";
var message = "The agreement with the due date of " + dueDate.toDateString() + " for " + companyName + " is approaching in " + diffDays + " days.";
MailApp.sendEmail(email, subject, message);
// Increment the email count and update Column N
sheet.getRange(i, 14).setValue(emailCount + 1);
}
}
}
}
*/
/** function sendEmailReminders() {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(“Rental & Services Agreement”);
if (!sheet) {
Logger.log(“Sheet not found”);
return;
}
var data = sheet.getDataRange().getValues();
var today = new Date();
var emailAddress = sheet.getRange(“M2”).getValue();
var emailBody = “The following agreements are due for renewal:\n\n”;
var finalReminderBody = “The following agreements are due for renewal tomorrow:\n\n”;
var emailCountUpdated = false;
var finalReminderSent = false;
for (var i = 1; i < data.length; i++) {
var companyName = data[i][2]; // Column C
var dueDate = new Date(data[i][5]); // Column F
var emailCount = data[i][13]; // Column N
var daysToDueDate = Math.ceil((dueDate - today) / (1000 * 60 * 60 * 24));
if (daysToDueDate <= 30 && emailCount < 3) {
var reminderText = emailCount === 2 ? "<span style='background-color: red; color: white;'>FINAL REMINDER: " + companyName + " - " + daysToDueDate + " days to due date</span>" : "Reminder #" + (emailCount + 1) + ": " + companyName + " - " + daysToDueDate + " days to due date";
emailBody += reminderText + "\n";
sheet.getRange(i + 1, 14).setValue(emailCount + 1); // Update Column N
emailCountUpdated = true;
} else if (daysToDueDate === 1 && emailCount === 3) {
finalReminderBody += "<span style='background-color: red; color: white;'>FINAL REMINDER: " + companyName + " - " + daysToDueDate + " day to due date</span>\n";
sheet.getRange(i + 1, 14).setValue(emailCount + 1); // Update Column N to 4 to indicate final reminder sent
finalReminderSent = true;
}
}
if (emailCountUpdated) {
var subject = “Agreement Renewal Reminders”;
MailApp.sendEmail({
to: emailAddress,
subject: subject,
htmlBody: emailBody.replace(/\n/g, ‘
’)
});
}
if (finalReminderSent) {
var finalSubject = “Final Agreement Renewal Reminder”;
MailApp.sendEmail({
to: emailAddress,
subject: finalSubject,
htmlBody: finalReminderBody.replace(/\n/g, ‘
’)
});
}
}
*/
/**
function createTrigger() {
ScriptApp.newTrigger(‘sendEmailReminders’)
.timeBased()
.everyDays(1)
.create();
}
*/
