emmaly

    function Write-ThisDownHere {
      [CmdletBinding()]
      param (
        [Parameter(ValueFromPipeline = $true)]
        $InputObject,

        [ValidateSet("Host", "Info", "Log")]
        $Medium = "Host",

        [ValidateSet("List", "Table", "Wide", "String", "JSON", "Raw")]

emmaly

//
const NOOP = true; // must be === false to make *ANY* actual modification work happen, not just !== true.
//
const GROUP_CREATION_OKAY  = false; // must be === true for this to happen
const ACLRULE_ADD_OKAY     = false; // must be === true for this to happen
const ACLRULE_REMOVE_OKAY  = false; // must be === true for this to happen
const ACLRULE_FIXROLE_OKAY = false; // must be === true for this to happen
//
const GROUP_TEMPLATE = {
  name: ({buildingName}) => buildingName + " Resource Custodian Role",

emmaly

function resolveRelationships(relationships, included, parentIds) {
	if (typeof relationships !== "object" || !Object.keys(relationships).length) return [];
	if (typeof included !== "object" || !Array.isArray(included)) return [];
	if (typeof parentIds === "string") parentIds = [parentIds];
	if (typeof parentIds !== "object" || !Array.isArray(parentIds)) parentIds = [];

	/**
	 * @param {string} type 
	 * @returns {string}
	 */

emmaly

// An example of how something like this could be used:
//
// Set some ranges as NamedRanges named "ColumnFormat_PhoneNumber" and "ColumnFormat_DateTime"
// and those will end up processed by the functions named "Format_PhoneNumber" and "Format_DateTime"
// which should enforce a value format or number format or possibly even a visual format upon edit
// and then set occasionalSheetFormatPatrol as a scheduled trigger to catch the items that were
// updated by API/scripts or other things that couldn't have been caught by the onEdit function.
// **

function occasionalSheetFormatPatrol() {

emmaly

/**
 * @param {SpreadsheetApp.Range} ranges
 * @returns {boolean}
 * - `true` indicates all ranges share the same overlapping point(s) with all others
 * - `false` indicates no shared overlap point, even if they all overlap individually
 */
function DoRangesHaveOverlap(...ranges) {
  return GetRangeUnion(...ranges) !== null;
}

emmaly

/**
 * @param {string} url
 * @param {Object<string,string|string[]>} qs - query string
 */
function urlWithQueryStringObject(url, qs) {
  if (!qs) return url;
  return [
    url,
    Object.entries(qs)
    .map(([k,v]) => {

emmaly

function Get-FilesFromGithubLatestRelease {
    # original function from https://github.com/microsoft/winget-cli/issues/1861#issuecomment-1193136622
    param (
        [parameter(Mandatory)][string]$Project, # e.g. paintdotnet/release
        [parameter(Mandatory)][string[]]$Patterns, # regex
        [switch]$Prerelease
    )

    $releases = Invoke-RestMethod -Method Get -Uri "https://api.github.com/repos/$Project/releases"
    $release  = $releases | Where-Object { $_.prerelease -eq $Prerelease } | Select-Object -First 1

emmaly

=
ARRAY_CONSTRAIN(
  SORT(
    FILTER(
      range,
      MAP(
        range,
        LAMBDA(
          cell,
          ISDATE(cell)

emmaly

function Search-FileAccess {
  param (
    [Parameter(Mandatory=$true)]
    [string]$IdentityReferenceRegex,
    [Parameter(Mandatory=$true)]
    [string]$Path,
    [Boolean]$Recurse=$true,
    [switch]$Visualization
  )

emmaly

\b(?:(?<International>[A-Z]{2}[0-9]{9}[A-Z]{2})|(?<FedEx>[0-9]{4} ?[0-9]{4} ?[0-9]{4} ?(?:[0-9]{3})?)|(?<UPS>(?:(?:(?:1Z)[0-9A-Z]{16})|(?:(?:T)[0-9A-Z]{15}[0-9])|(?:[0-9]{9})|(?:[0-9]{26})))|(?<USPS>(?:(?:(?:93|92|94|95)[0-9]{2} ?[0-9]{4} ?[0-9]{4} ?[0-9]{4} ?[0-9]{4} ?[0-9]{2,4})|(?:(?:70|14|23|03)[0-9]{14})|(?:(?:M0|82) ?[0-9]{3} ?[0-9]{3} ?[0-9]{2})|(?:(?:[A-Z]{2})[0-9]{9}(?:[A-Z]{2})))))\b