pfelipm

<form action="https://script.google.com/macros/s/AKfycbzlDk0jJzHB5zIeb78PEWRYb_TOi5wY7RfTdDe3c3Oyac_S2Is/exec" method="get" target="_blank">
<label>DNI</label><br />
<input name="DNI" required="" type="text" /><br /><br />
<label>Correo electr&oacute;nico</label><br />
<input name="EMAIL" required="" type="email" /><br><br>
<button>Buscar</button>
</form>

pfelipm

/**
 * Determina si la celda indicada está protegida (no es editable por el usuario)
 * @param {A1} celda Referencia a celda en formato A1 o R1C1 entre comillas dobles ("..")
 * @returns VERDADERO | FALSO
 * @customfunction
 *
 * MIT License
 * Copyright (c) 2020 Pablo Felip Monferrer(@pfelipm)
 *
 * @OnlyCurrentDoc

pfelipm

// This object stores text strings in several languages inside sub-objects {ES}, {EN_US}...
const TRANSLATIONS = {
  ES: {
    MSG_HELLO: 'Hola',
    MSG_GOODBYE: 'Adiós'
  },
  EN_US: {
    MSG_HELLO: 'Hello',
    MSG_GOODBYE: 'Goodbye'
  }

pfelipm

/**
 * Importa intervalos de datos idénticos procedentes de todas
 * las hdc que se encuentran en la carpeta indicada
 * y los consolida en la actual.
 * No realiza ningún control de errores.
 * El orden de importación no está garantizado.
 * Demo: https://drive.google.com/drive/folders/1BZNT5TNcOpKaP5Hy3BuvVZhT_FhtrWjr?usp=sharing
 */

const ID_CARPETA_ORIGEN = '1bqlCmxWaL-LCNb6T7vOWNtPky3bK99K-';

pfelipm

/**
 * Multiple <placeholder> text substitutions
 * using a JS map data type and reduce() with initial value (+other methods)
 */
 
function globalTextSubst(){

  // Some sample data
  const alumno = 'Juan Rebote';
  const ciclo = 'Gestión de ventas y espacios comerciales';

pfelipm

/**
 * These two functions:
 * 1. Transform a UNICODE string to blob, compress and encode it as text using two different methods (base64 or JSON.stringify)
 * 2. Reverse de process
 */

function testTextoGzipBlob() {

  // Method 1: base64Encode (better compression):
  // Text >> Blob >> gzip >> getBytes Byte[] >> *base64Encode* text >> [cache key/value] >> *base64Decode* Byte[] >> Blob >> ungzip >> Text 😅

pfelipm

/**
 * generated.photos API demo >> Faces generated from scratch by AI
 * 
 * 1. Get API key at https://generated.photos/api
 * 2. Make a copy of https://docs.google.com/spreadsheets/d/1RkLy6e0h1QURtsOj1gsAfWGzvAUua0yIky_THy8ut1Q
 * 3. Write your API key inside cell C3 (don't share!)
 * 
 * Please, note:
 *   - Just 50 API calls/month! (API free plan)
 *   - Some trait combinations apparently fail to return results :-?

pfelipm

/**
 * Simple demonstration of LockService...
 * https://developers.google.com/apps-script/reference/lock
 * ...to prevent concurrent executions of a GAS function, 
 * for example when invoked by a button in a Spreadsheet (rather likely).
 * Demo: https://docs.google.com/spreadsheets/d/1n_7nZIi5QtN9URzsKdFW6WtSxPM9uUK3QhQSbzbltHg
 *  
 * @OnlyCurrentDoc
 */

pfelipm

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

pfelipm

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