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

/*
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

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
);