JeancarloFontalvo

/*
 * script to export data of the named sheet as an individual csv files
 * sheet downloaded to Google Drive and then downloaded as a CSV file
 * file named according to the name of the sheet
 * original author: Michael Derazon (https://gist.github.com/mderazon/9655893)
*/

function onOpen() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var csvMenuEntries = [{name: "Download Primary Time File", functionName: "saveAsCSV"}];

JeancarloFontalvo

-- J2 = "Alfanumerico|6|SI|SI|Personalizado"
--FORMULA

=Y(
   SI(
    SI.ERROR(HALLAR("Alfa"; J2); -1) <> -1; 
        VERDADERO;
        SI(
            SI.ERROR(HALLAR("Numerico"; J2); -1) <> -1; 
                REGEXMATCH(TO_TEXT(K2); "^(\d+)$"); 

JeancarloFontalvo

var checkboxes = $('input[type="checkbox"]');
checkboxes.each((item, element) => {
	element 	= $(element);
	var value 	= element.is(":checked");
	element.after(`<span class='text-white label label-${value ? "primary": "danger"}'>${value ? "SI": "NO"}</span>`);
})