afro-coder

(function(){
// Click on Apply for WFH button
$('#lnkApplyODRequest').click()

//Set the WFH type
$('#ctl00_mainContent_ApplyOD_ddlOdtype').val(1)

// Day type
$('#ctl00_mainContent_ApplyOD_ddlDayType').val(1);

afro-coder

// Function was taken from
// https://joeybronner.fr/blog/google-apps-script-get-current-user-email-from-a-spreadsheet-add-on/
function getCurrentUserEmail() {
    var userEmail = Session.getActiveUser().getEmail();
    if (userEmail === '' || !userEmail || userEmail === undefined) {
        userEmail = PropertiesService.getUserProperties().getProperty('userEmail');
        if (!userEmail) {
            var protection = SpreadsheetApp.getActive().getRange('A1').protect();
            protection.removeEditors(protection.getEditors());
            var editors = protection.getEditors();

afro-coder

package main

import (
        "encoding/json"
        "fmt"
        "io/ioutil"
        "log"
        "net/http"
        "os"
        "database/sql"

afro-coder

# This will remove the manual work of copying the file names
# You can run this in batches to processes it
# pip install --user tika to download the tika library
# the first run will download tika.jar
from tika import parser


filename="path_to_file"

#parse the pdf

afro-coder

import gzip
import json
import re
import os
import datetime
import pprint
import argparse
from collections import OrderedDict

class _RegEx:

afro-coder

"""
I'm really new to python and flask so this maybe terribly wrong but it works at least for me

usage:
python clitools.py --config {{your config}} command


It also prompts just in case you forget.
The ctx object from the click documentation along with the '@click.pass_context helps to push the app variable through
all the functions.