MauricioMoraes

function getFirstGmailDraftAttributes() {
  var draftThreads = GmailApp.search("in:drafts", 0, 1);
  
  if (draftThreads.length === 0) {
    Browser.msgBox("No drafts found.");
    return
  }
  
  var draft = draftThreads[0].getMessages()[0];
  

MauricioMoraes

function columnNumberByName(sheetName, ColumnName) {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = spreadsheet.getSheetByName(sheetName)
  
  var firstRowRange = sheet.getRange(1, 1, 1, sheet.getMaxColumns());
  var columnNames = firstRowRange.getValues()[0];
  
    for (var columnNumber in columnNames) {
      if (columnNames[columnNumber] == ColumnName) {
        return parseInt(columnNumber);

MauricioMoraes

function findRowNumberForCellWithValue(targetValue, rangeA1Notation, sheet) {
  var range = sheet.getRange(rangeA1Notation);
  var values = range.getValues()
  
  for (var i = 0; i < values.length; i++) {
    if (values[i][0] == targetValue) {
      return i+1;
    }    
  }  
}

MauricioMoraes

function setupDatatableCheckboxesWithPagination(tableSelector, attributeName) {
  var dataTableObject = $(tableSelector).dataTable();
  form = $(tableSelector).closest("form");

  $(form).submit(function(){
    insertHiddenInputsWithCheckboxesValues(tableSelector, attributeName);
    dataTableObject.fnFilter('');
  });
};

MauricioMoraes

// Takes and array of arrays matrix and return an array of elements.
function flatten(arrayOfArrays){
  return [].concat.apply([], arrayOfArrays);
}

MauricioMoraes

// Pass the column headers range and names, and it will return an object with the relation between column names and column numbers
function getColumnNumbersForNames(sheetName, columnHeadersRangeA1Notation, columnNames){
  var thisSpreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = thisSpreadsheet.getSheetByName(sheetName);
  var columnHeadersRange = sheet.getRange(columnHeadersRangeA1Notation);
  var columnNamesOnSheet = flatten(columnHeadersRange.getValues());
  
  var columnNumbersForNames = {};
  for(var count = 0; count < columnNames.length; count++){
    var columnName = columnNames[count]

MauricioMoraes

// Using jquery.inputmask: https://github.com/RobinHerbots/jquery.inputmask
// For 8 digit phone fields, the mask is like this: (99) 9999-9999
// For 9 digit phone fields the mask is like this: (99) 99999-9999
function setupPhoneMaskOnField(selector){
  var inputElement = $(selector)

  setCorrectPhoneMask(inputElement);
  inputElement.on('input, keyup', function(){
    setCorrectPhoneMask(inputElement);
  });

MauricioMoraes

Option Explicit
Sub delete_all_shapes()
  Dim shape As Shape
  Dim worksheet As Worksheet
  
  Dim response As Integer
  response = MsgBox("This action will delete all pictures and shapes from your spreadsheet. Do you want to continue?", vbYesNo, "Delete all shapes from spreadsheet")
    
    If response = vbYes Then
      For Each worksheet In ThisWorkbook.Worksheets

MauricioMoraes

function listFilesInFolder() {
  var folder = DocsList.getFolder("Maudesley Debates");
  var contents = folder.getFiles();
  
  var file;
  var data;
  
  var sheet = SpreadsheetApp.getActiveSheet();
  sheet.clear();
  

MauricioMoraes

You have to do 2 things in order to allow your container to access your host's postgresql database

1. Make your postgresql listen to an external ip address
2. Let this client ip (your docker container) access your postgresql database with a given user

Obs: By "Host" here I mean "the server where docker is running on".

Make your postgresql listen to an external ip address

Find your postgresql.conf (in case you don't know where it is)

$ sudo find / -type f -name postgresql.conf