RR-Helpdesk

DROP TABLE "public"."varCalcValue";
CREATE TABLE "public"."varCalcValue" (
  "id" bigint NOT NULL GENERATED ALWAYS AS IDENTITY,
  "varCalcValue" VARCHAR(50) NOT NULL,
  "createdOn" TIMESTAMP NULL,
  "updatedOn" TIMESTAMP NULL
);

RR-Helpdesk

/*
Some Global Variables to make it easier to keep a track of changing column
positions, etc.
*/

// 'Folder Name' column number
var folderNameCol = 1;

// 'Folder Link' column number
var folderLinkCol = 2;

RR-Helpdesk

/**
 * Returns the Hexadecimal value of a cell's background color.
 *
 * @param {number} row The cell's row number.
 * @param {number} column The cell's column number.
 * @return The Hexadecimal value of the cell's background color.
 * @customfunction
 */
function BGHEX(row, column) {
  var background = SpreadsheetApp.getActive().getDataRange().getCell(row, column).getBackground();

RR-Helpdesk

regexp_replace('revenue'), '[$K,1]', '') * 100

RR-Helpdesk

Add this code as an HTML embed in your footer:

 <div class="paragraph">&copy; Company Name <script>document.write(new Date().getFullYear())</script>. All Rights Reserved.</div>

RR-Helpdesk

SHOW password_encryption;

SELECT rolpassword from pg_authid where rolname = '{your-db-user-name}';

ALTER USER "{your-db-user-name}" with password '{your-new-db-password}';

SET password_encryption  = 'scram-sha-256';
SET password_encryption  = 'md6';

SHOW password_encryption;

RR-Helpdesk

// Copyright 2018 Google LLC
//
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
//
//     http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,

RR-Helpdesk

 https://blog.coupler.io/filter-function-google-sheets/

RR-Helpdesk

 function organizeFolders() {
  // Parent Folders
  var parentA = DriveApp.createFolder('Dad');
  var parentB = DriveApp.createFolder('Mom');

  // Child folder inside Parent Folder A
  var child = parentA.createFolder('Child');

  // Place Child Folder inside another Parent Folder B
  parentB.addFolder(child);

RR-Helpdesk

 <script>
$( function() {
    function changeTab() {
        var tabName = window.location.hash.substr(1);
        var tabEl = $('[data-w-tab="' + tabName + '"]');
        if (tabEl.length) {
            tabEl.click();
        }
    }