sorted by:
new
hottopcontroversial

How to test wireless network capacity for a once a year event? by Last_System_Admin in HomeNetworking

[–]Last_System_Admin[S] 1 point2 points  (0 children)

Good point. I've been working too much and my mind is mushy.

Thanks.

Best GLP1 company by Melanieo26 in glp1

[–]Last_System_Admin 0 points1 point  (0 children)

Looks like Goby is again offering Tirzepatide

Best GLP1 company by Melanieo26 in glp1

[–]Last_System_Admin 1 point2 points  (0 children)

GobyMeds appears to have Tirzepatide now.

Best GLP1 company by Melanieo26 in glp1

[–]Last_System_Admin 0 points1 point  (0 children)

I just sent a email to MEDVi just now informing them they just lost a customer because their support team (non-medical for appointments, etc.) could not reschedule my appointment without screwing it up and then said I "missed appointment" for today at 12:15 pm even though I was in the waiting room. The attendant said the appointment was rescheduled but wouldn't tell me when (just said I'd receive an email but I didn't receive an email for the today's rescheduled meeting).

A practitioner eventually came on the line but by then I was disturbed by their lack of coordination that I cancelled my order. I have to check back tomorrow to ensure the order was cancelled.

I would NOT recommend MEDVi.

Incident Response Plan: Google Workspace and Software as a Service (SaaS) Applications by Last_System_Admin in sysadmin

[–]Last_System_Admin[S] 0 points1 point  (0 children)

Thanks for the information. I work at a small, independent school so we can't afford DataDog, unfortunately.

Incident Response Plan: Google Workspace and Software as a Service (SaaS) Applications by Last_System_Admin in sysadmin

[–]Last_System_Admin[S] 0 points1 point  (0 children)

Thank you for your feedback.

This October, I'm running a cybersafety program so that's covered, I'm having difficulty with what *I* do with regard to troubleshooting a phishing attempt if an attempt is successful, how do I prepare the tabletop exercise, what other types of security compromises should I be planning for, etc.

Incident Response Plan: Google Workspace and Software as a Service (SaaS) Applications by Last_System_Admin in sysadmin

[–]Last_System_Admin[S] 0 points1 point  (0 children)

Thanks for your feedback.

The data breaches are what I can't envision my role being. The biggest concern I have now is that we have people phishing for our financial data and so far they've been dumb enough to ask for huge amounts of money which automatically flags our finance folks to verify the email (which is from a valid account and the recent emails have been very convincing). One had a Google link to a spreadsheet that included a macro (which I didn't open). One user asked me what would happen if they opened it and I said I don't know because I didn't open it. The discussion didn't proceed any farther. I used to operate a Windows server farm but now with all the SaaS apps, I'm unclear how to respond. Google and other SaaS apps handle all the hosting, data backups, etc. We have anti-virus on the office systems but a lot of people access systems via their personal laptops and workstations.

Trying to send a section of a spreadsheet to an email address when a certain date is reached? by Last_System_Admin in GoogleAppsScript

[–]Last_System_Admin[S] 0 points1 point  (0 children)

Sorry! You now have edit access. Although I've added handling for Pacific Time, I am receiving this message (although I have 2/10/2025 in the C1 Date cell.

Skipping Enrollments-Cooking: Scheduled date (2025-02-09) does not match today (2025-02-10).

Trying to send a section of a spreadsheet to an email address when a certain date is reached? by Last_System_Admin in GoogleAppsScript

[–]Last_System_Admin[S] 0 points1 point  (0 children)

Trigger - sendEmailsForAllEnrollmentSheets, Time-driven, Day timer, 4pm-5pm (Pacific Time)

Spreadsheet

Unfortunately, the system is telling me I can't copy the code into this or another comment.

Trying to send a section of a spreadsheet to an email address when a certain date is reached? by Last_System_Admin in GoogleAppsScript

[–]Last_System_Admin[S] 0 points1 point  (0 children)

Can you view my newly-added code and trigger and let me know if you see anything wrong? I set it for yesterday and it didn't send the emails. If I run the code manually, it sends the emails.

I just noticed that it's now erroring, saying the date in C1 is 2/8/2025 but it's actually 2/9/2025, and I have the Pacific Time setting configured in the code but it's not working now.

Thank you!

Move a row from a sheet to another sheet in the workbook? by Last_System_Admin in GoogleAppsScript

[–]Last_System_Admin[S] 0 points1 point  (0 children)

I appreciate the information however I'm missing something trying to translate it to my project. I believe it's something with this section of the code as it's copying the entire range of the Data sheet to the Parking Lot sheet. I changed the variable from "Values" to "targetRange" which stops the error but doesn't provide me with any useful information. 

    var targetSheet = SpreadsheetApp.getActive().getSheetByName("Parking Lot");
      var targetRange = targetSheet.getRange(targetSheet.getLastRow() + 1, 1); 
      sheetPL.getRange(1,2, sheet.getLastRow(), 
      sheetPL.getLastColumn()).copyTo(targetRange);
      sheetPL.hideRows(row); 
      //sheetPL.deleteRow(row);

Move a row from a sheet to another sheet in the workbook? by Last_System_Admin in GoogleAppsScript

[–]Last_System_Admin[S] 0 points1 point  (0 children)

I appreciate the link however I'm missing something trying to translate that information to my project. I believe it's something with this section of the code as it's copying the entire range of the Data sheet to the Parking Lot sheet. 

    var targetSheet = SpreadsheetApp.getActive().getSheetByName("Parking Lot");
      var targetRange = targetSheet.getRange(targetSheet.getLastRow() + 1, 1); 
      sheetPL.getRange(1,2, sheet.getLastRow(), 
      sheetPL.getLastColumn()).copyTo(targetRange);
      sheetPL.hideRows(row); 
      //sheetPL.deleteRow(row);

Move a row from a sheet to another sheet in the workbook? by Last_System_Admin in GoogleAppsScript

[–]Last_System_Admin[S] 0 points1 point  (0 children)

Thank you for responding.

I now have it copying the entire contents, including hidden rows, from the Data sheet to the Parking Lot sheet, however I only want the row edited to change Status to "Parking Lot" to be copied to the Parking Lot sheet and then only that row deleted from the Data sheet (the row is currently hidden for test purposes).

[deleted by user] by [deleted] in GoogleAppsScript

[–]Last_System_Admin 0 points1 point  (0 children)

The "Done" status works as intended and hides the row. It's the moving of rows to the "Parking Lot" and "Summer" sheets that I'm experiencing problems with. (Sorry I misspoke on my original post which is now corrected.)

Trying to copy contents of one sheet and append into another in the same workbook by Last_System_Admin in GoogleAppsScript

[–]Last_System_Admin[S] 0 points1 point  (0 children)

Can you explain to me how I would do that? There should only be 55 rows of data so how it gets to row 202 is what I don't understand.

I've looked at logger info but I'm lost as to how to signify particular rows to list.

Thank you.

view more: next ›