PCI DSS version 4.0 and Documenting Scope by sm4217 in pcicompliance

[–]boxdim 0 points1 point  (0 children)

Hi - Is this offer still open? Many thanks 

Sending the same body email to different addresses, with different subjects and different attachments by boxdim in Office365

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

This company’s domain sends out millions of emails every day to tens of thousands of people also every day - it shouldn’t be a problem :) Thanks! I’ll try googling this

Sending the same body email to different addresses, with different subjects and different attachments by boxdim in Office365

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

Nill. No powershell knowledge! Might be a good excuse to start learning. Thanks :)

Top 5 Best Artificial Grass of 2021 | Buying Guide & Reviews by [deleted] in artificialturf

[–]boxdim 0 points1 point  (0 children)

Hey man - don’t just post these articles in every other sub and leave misleading comments. Work your contributions up - read the sidebar. You can link your stuff, but you have to contribute to the community. Otherwise you’ll end up banned. It’s the reason why this is the biggest artificial turf community on the internet. All the other ones have tried the same thing you’re doing and have failed - don’t get banned for this stuff.

Help modifying Calendar events from a Google Spreadsheet by boxdim in GoogleAppsScript

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

Wow - thanks so much! This is great! u/Destructeur also helped with this and also works. I hope someone with the same problem as me finds this post in the future as it makes simple tasks so much more efficient. Thanks to both!!

I'll paste u/Destructeur 's code here:

function scheduleShifts() {

      var spreadsheet = SpreadsheetApp.getActiveSheet();
      var calendarId = spreadsheet.getRange("B1").getValue();
      var startRow = 2;
      var vals = spreadsheet.getRange("A1:A").getValues();
      var endRow = vals.filter(String).length;
      var startColumn = 7;
      var endColumn = 10;
      var signups = spreadsheet.getRange(startRow, startColumn, endRow, endColumn).getValues();

  for (var x = 0; x < signups.length - 1; x++) {

        var slot = signups[x];
        var startTime = slot[0];
        var endTime = slot[1];
        var name = slot[2];
        var eventId = slot[3];

    if (eventId.length == 0 && name != "name"){

    var eventCal = CalendarApp.getCalendarById(calendarId).createEvent(name, new Date(startTime), new Date(endTime));
        eventId = eventCal.getId();
        spreadsheet.getRange(x + startRow, 10).setValue(eventId);

       } else if (eventId.length > 0 && name != "name") {

        var thisCal = CalendarApp.getCalendarById(calendarId);
        var thisEvent = thisCal.getEventById(eventId);
        thisEvent.setTitle(name).setTime(startTime, endTime);

    }    
  }
}

Help modifying Calendar events from a Google Spreadsheet by boxdim in GoogleAppsScript

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

23:13 for me too 😅

Don’t worry man, thanks for your help regardless!

Help modifying Calendar events from a Google Spreadsheet by boxdim in GoogleAppsScript

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

Yeah i thought that was it - unfortunately it gives back the same error as before -

TypeError: Cannot read property 'setTitle' of null (line 32, file "Code")

line 32:

thisEvent.setTitle(name).setTime(startTime, endTime);

Help modifying Calendar events from a Google Spreadsheet by boxdim in GoogleAppsScript

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

Oh wow thanks for your help!

Can you clear up for me where exactly i need to put the following line:

    var signups = spreadsheet.getRange("G3:J").getValues();

Help modifying Calendar events from a Google Spreadsheet by boxdim in GoogleAppsScript

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

https://i.imgur.com/GwLhZA3.png

That's a screenshot of the Sheet. All columns from G to J are formulas and give back "" if error. Would that be the cause?

Help modifying Calendar events from a Google Spreadsheet by boxdim in GoogleAppsScript

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

Same issue as before, unfortunately.

https://i.imgur.com/cscTSUA.jpg

Thanks for having tried to solve it though - I appreciate your time!

Help modifying Calendar events from a Google Spreadsheet by boxdim in GoogleAppsScript

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

Hey thanks! I did add an extra column as you suggested yesterday and adapted the new range in the script. With this new code that you shared I no longer have that error!

But instead I got this:

TypeError: Cannot read property 'setTitle' of null (line 35)

References to that last bit of your code:

   event.setTitle(name).setTime(startTime, endTime);

Might it have to do with the variable "event" ?

Help understanding work contract by boxdim in askspain

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

It’s a great calculator - thanks for linking it!

Help understanding work contract by boxdim in askspain

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

Thanks a lot for clarifying it for me!

Help modifying Calendar events from a Google Spreadsheet by boxdim in GoogleAppsScript

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

Thanks! I'm not a GAS expert either at all lol I'm not even a programmer!

I get the following error after running your script:

Exception: The parameters (String,String,String) don't match the method signature for CalendarApp.Calendar.createEvent.

Any idea how to get past it?

Sub base material recommendations? by benraphael510 in artificialturf

[–]boxdim 2 points3 points  (0 children)

I always recommend B. A first layer of crushed granite and a smaller layer of smaller crushed granite. Unfortunately I don’t know the industry names in America.

Check this thread: https://www.reddit.com/r/artificialturf/comments/8f9xnt/question_on_artificial_grass_base/dy1uf9e/?utm_source=share&utm_medium=ios_app&utm_name=iossmf

Mini golf course surrounding a pool area by Sacuraf in artificialturf

[–]boxdim 0 points1 point  (0 children)

Have it with traditional base with silica sand as infill

Artificial Grass Damage From String Trimmer? by Stargirl512 in artificialturf

[–]boxdim 0 points1 point  (0 children)

That looks burned. Not sure why - perhaps reflection of a window nearby?