Skip to content

Instantly share code, notes, and snippets.

View pfelipm's full-sized avatar
🎯
Focusing

pfelipm

🎯
Focusing
37 followers · 0 following
View GitHub Profile
@pfelipm
pfelipm / formatocondicional.gs
Last active December 13, 2024 11:38
Ejemplo de generación automatizada de reglas de formato condicional en Google Sheets con Apps Script | Example of automatically generating conditional formatting rules in Google Sheets using Apps Script.
/**
* Genera reglas de formato condicional sobre las celdas indicadas para modificar
* sus colores de fondo de acuerdo con la paleta seleccionada en el desplegable de referencia
* @OnlyCurrentDoc
*/
function generaReglasFormatoCondicional() {
const hoja = SpreadsheetApp.getActive().getSheetByName('SPARKLINE_BARRAS');
const celdasObjetivo = ['C5', 'D5', 'E5', 'F5', 'G5'];
const paletas = [
@pfelipm
pfelipm / fxCONTARCOLORv2.gs
Last active January 22, 2024 18:56
Función personalizada Apps Script para hojas de cálculo CONTARCOLOR (v2)
/**
* Realiza un recuento o calcula la suma o el promedio de los valores de las celdas
* que tienen un color de texto o fondo determinado. También puede simplemente devolver
* los valores que cumplan la condición de color para que puedan ser utilizados en cualquier
* fórmula.
*
* Versión modificada de la función CONTARCOLOR incluida en HdCPlus (https://workspace.google.com/marketplace/app/hdc+/410659432888),
* ahora:
*
* - Admite, además del recuento, la suma y el promedio de valores de celda según color.
@pfelipm
pfelipm / instalarAutoFirma.sh
Last active September 24, 2024 14:51
Este script instala el cliente Linux de AutoFirma y Firefox ESR en tu dispositivo ChromeOS. Soluciona el error "archive uses unknown compression for member control.tar.zst" al instalar el paquete DEB de AutoFirma. Ejecuta el script en el terminal de comandos Linux de tu chromecosa e instala a continuación tus certificados digitales en Firefox.
sudo apt update
sudo apt -y install default-jre
sudo apt -y install binutils
sudo apt -y install zstd
wget https://estaticos.redsara.es/comunes/autofirma/currentversion/AutoFirma_Linux_Debian.zip
unzip AutoFirma_Linux_Debian.zip
ar x AutoFirma_*.deb
zstd -d < control.tar.zst| xz > control.tar.xz
zstd -d < data.tar.zst| xz > data.tar.xz
ar -m -c -a sdsd AutoFirma_repacked.deb debian-binary control.tar.xz data.tar.xz
@pfelipm
pfelipm / Bookmarklets left panel GAS IDE
Last active June 14, 2023 19:18
Four bookmarklets to toggle / shrink / resize the left panel (and top section) of the Google Apps Script IDE
// Create a new bookmark in your browser using any of these URLs | @pfelipm 06/02/23
// Demo: https://twitter.com/pfelipm/status/1622395953721364481
// 1. Toggles the side panel out of view
javascript:(function() {const style = document.querySelector('div[jsname="Iq1FLd"]').style;if (style.display == 'none') style.display = '';else style.display = 'none';})()
// 2. Allows the side panel to shrink down to 150px when resizing window
javascript:(function() {const style = document.querySelector('div[jsname="Iq1FLd"]').style;if (style.minWidth == "150px") style.minWidth = "225px";else style.minWidth = "150px";})()
// 3. Resizes the side panel to the width specified by a JS prompt
@pfelipm
pfelipm / fxParseJson.gs
Last active August 13, 2023 16:12
PARSEJSON Apps Script custom function for Google Sheets
/**
* Parses a JSON string and returns a single element designated by its full path.
* Mimics Coda's ParseJSON (https://coda.io/formulas#ParseJSON) formula.
* @param {A2:A3} jsonData Source JSON string or data interval containing JSON strings to parse.
* @param {A5:A6} fullPath Path string or data interval of paths to use for extraction, use ".number" for array elements.
* @param {false} stringify Optional, false (default) if result should be stringified only if it is an object.
* @return Extracted primitive value or stringified representation, if array or object.
*
* @customfunction
*
@pfelipm
pfelipm / Check user onOpen workflow.gs
Last active October 3, 2022 15:59
/**
* Demo authorization workflow that checks whether the current user can run this Apps Script, uses
* the Admin SDK Directory Advanced Service
* Twitter thread here: https://twitter.com/pfelipm/status/1576954653425618945
* @pfelipm (OCT/22)
*
* @OnlyCurrentDoc
*/
@pfelipm
pfelipm / Reset slicers.gs
Last active November 23, 2021 17:04
Reset all slicers in the current sheet of a Google Spreadsheet
/**
* Resets all slicers in the active sheet using the Apps Script Spreadsheet Service.
*
* Context:
*
* Calling setColumnFilterCriteria(columnPosition, null) or trying to modify
* in some other way the current filter criteria of a slicer whose criteria
* has already been set manually (using the GUI) won't have any effect.
* So, this function clones & deletes all slicers, instead.
*
@pfelipm
pfelipm / getGroupsRecursively.gs
Last active February 28, 2022 08:41
Get
/**
* Recursively gets all groups that a given user/group is a member
* of, either directly or indirectly, in a GWS domain.
*
* -OR-
*
* checks whether user/group is a member of provided group,
* both tasks support external users to the domain.
* Uses the AdminDirectory advanced service, and should be invoked by domain Admins!
*
@pfelipm
pfelipm / TOC custom fx.gs
Last active November 22, 2021 20:08
/**
* Builds a TOC in the spreadsheet.
*
* Pablo Felip (@pfelipm).
*
* @param {true} includeId Include sheet ID
* @param {true} includeUrl Include link to sheet
* @return List of [Sheet name, Sheet ID, Sheet URL]
* @customfunction
*/
@pfelipm
pfelipm / fxRepetirFilas.gs
Last active May 23, 2021 22:27
Función personalizada para HdC repetirFilas()
/**
* Repite cada fila un nº indicado de veces
* @param {A2:C4} intervaloDatos Intervalo de datos cuyas filas se van a repetir
* @param {D2:D4} colRepeticiones Vector columna que indica el nº de veces a repetior cada fila
* @customfunction
*/
function repetirFila(intervaloDatos, colRepeticiones) {
// ⚠️ ¡Se debería realizar un control de errores sobre los parámetros de la función!