cddouglass

Agent Guidelines for Python Code Quality

This document provides guidelines for maintaining high-quality Python code. These rules MUST be followed by all AI coding agents and contributors.

Your Core Principles

All code you write MUST be fully optimized.

"Fully optimized" includes:

Updated Specification of Google Spreadsheet: Multiple Hyperlinks to a Cell

Recently, it seems that the specification of Google Spreadsheet was updated. Before this, when a cell has only one hyperlink. In this case, the hyperlink was given to a cell using =HYPERLINK("http://www.google.com/", "Google") as following figure.

But by the recent update, a cell got to be able to have multiple hyperlinks as following figure. In this case, the hyperlinks are set by the RichTextValue object.

	javascript: Promise.all([import('https://unpkg.com/[email protected]?module'), import('https://unpkg.com/@tehshrike/[email protected]'), ]).then(async ([{
	default: Turndown
	}, {
	default: Readability
	}]) => {

	/* Optional vault name */
	const vault = "";

	/* Optional folder name such as "Clippings/" */

	/*
	Script: Check for Speaker Schedule Conflicts
	Author: Jeremy Oglesby
	License: MIT

	This script was written to be used with the "Event planning"
	Airtable template, and can be adapted to any similarly
	structured base where the requirement to detect overlapping
	start and end times is pressing.

	// Playing around with a PowerBI query to pull data from monday.com into PowerBI
	// This can come in handy when building PowerBI reports that utilize GraphQL endpoints for loading data.

	let
	Source = Web.Contents(
	"https://api.monday.com/v2",
	[
	Headers=[
	#"Method"="POST",
	#"Content-Type"="application/json",

	function onOpen() {
	var menuEntries = [ {name: "Create Diary Doc from Sheet", functionName: "createDocFromSheet"}];
	var ss = SpreadsheetApp.getActiveSpreadsheet();
	ss.addMenu("Fitness Diaries", menuEntries);
	}

	function createDocFromSheet(){
	var templateid = "1O4afl8SZmMxMFpAiN16VZIddJDaFdeRBbFyBtJvepwM"; // get template file id
	var FOLDER_NAME = "Fitness Diaries"; // folder name of where to put completed diaries
	// get the data from an individual user