JustinByrne

name: CI/CD workflow
on:
  push:
    branches:
      - main
  pull_request:
    branches:
      - main
jobs:
  testing:

JustinByrne

// get queue number
function getQueueNum() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheets()[0];
  var range = sheet.getRange(1,getColByName('status'),sheet.getLastRow());
  var values = range.getValues();
  
  var queue = 1;
  
  var statuses = ['Pending','pending','In Progress','in progress','In progress','in Progress'];

JustinByrne

// send email
function email(subject, body, col = "email") {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheets()[0];
  var selection = ss.getActiveRange();
  var currRow = selection.getRowIndex();
  var emailCol = getColByName(col);
  
  var email = sheet.getRange(currRow, emailCol).getValue();
  

JustinByrne

// get column by the content in it - first row only
function getColByName(columnName) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheets()[0];
  var range = sheet.getRange(1, 1, 1, sheet.getLastColumn());
  var values = range.getValues();

  for (var row in values) {
    for (var col in values[row]) {
      if (values[row][col] == columnName) {

JustinByrne

Keybase proof

I hereby claim:

• I am justinbyrne on github.
• I am justinbtechguy (https://keybase.io/justinbtechguy) on keybase.
• I have a public key ASDDO5PWn_efQXTT8vdePYaL3z8SGGx6ZocdDDJoVoWNKAo

To claim this, I am signing this object: