Add event to Google/Outlook.com/Office365 Calendar

PHPMaker User Submitted Tips (PHPMaker)
1

Here’s how to add events to Google Calendar directly from your phpmaker site.
Make sure you already have a DATETIME field named “Appointment”, and you have a text field named “EventName”
My code assumes an appointment duration of 1hr, but you can edit that.
in case you have a DATETIME field for both start and end of the event, you can use that too

  1. To the table (mine is called Appointments) containing tha DATETIME field, add a custom field named “AddToCalendar”
  2. Custom field expression should be: cast(‘’ as SIGNED) - this is effectively a dummy expression as we’ll be using Row_Rendered to add the actual code.
  3. Go to function Row_Rendered for your table, and insert this code:
$eventName=$this->EventName->CurrentValue; //customise this to suit the field name in your table

$studentid = ExecuteScalar("SELECT fk_StudentID FROM Students_Further_Study WHERE Students_Further_Study.id='".$this->fk_StudyID->CurrentValue."'");
$studentname = ExecuteScalar("SELECT V_Fullname FROM Students_Directory WHERE Students_Directory.id='".$studentid."'");

$caltype="1"; // 1 = Google, 2 = Outlook.com, 3 = Office365

	switch($caltype){
		case "1"; //Google
		$calprefix = "https://www.google.com/calendar/render?action=TEMPLATE&dates=";
		$calapptstart = $this->Appointment->CurrentValue;
		$calapptend = strtotime($calapptstart) + 60*60;
		$calstartend = date('Ymd\THis', strtotime($calapptstart))."/".date('Ymd\THis', $calapptend);
		$studentname1 = preg_replace('/\s+/', '+', $studentname);
		$calsuffix = "&text=Appointment+".$studentname1;
		break;
		case "2"; //Outlook
		$calprefix = "https://outlook.live.com/calendar/0/deeplink/compose?enddt=";
		$calapptstart = $this->Appointment->CurrentValue;
		$calapptend = strtotime($calapptstart) + 60*60;
		$calstartend = date('Y-m-d\TH:i', $calapptend)."&path=/calendar/action/compose&rru=addevent&startdt=".date('Y-m-d\TH:i', strtotime($calapptstart));
		$studentname1 = preg_replace('/\s+/', '%20', $studentname);
		$calsuffix = "&subject=Appointment%3A%20".$studentname1;
		break;
		case "3"; //Office365
		$calprefix = "https://outlook.office.com/calendar/0/deeplink/compose?enddt=";
		$calapptstart = $this->Appointment->CurrentValue;
		$calapptend = strtotime($calapptstart) + 60*60;
		$calstartend = date('Y-m-d\TH:i', $calapptend)."&path=/calendar/action/compose&rru=addevent&startdt=".date('Y-m-d\TH:i', strtotime($calapptstart));
		$studentname1 = preg_replace('/\s+/', '%20', $studentname);
		$calsuffix = "&subject=Appointment%3A%20".$studentname1;
		break;
	}
$AddtoCalLink = $calprefix.$calstartend.$calsuffix;

//display the calendar link and icon
	$this->AddToCalendar->ViewValue = "<span class='fas fa-calendar-plus'></span> <a href='".$AddtoCalLink."' target='_blank'>Add to calendar</a>";
	$this->AddToCalendar->TooltipValue = "Add to my Google Calendar";