This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// Review each line. Replace the variables inline. TEST before try | |
// It expects a file which has name, suburb, state, url. You may have as many columns as you need. | |
// In a given drive, it will generate QR codes as PNG files (Name-Suburb-State.png) | |
// Original inspiration and instructions : https://stackoverflow.com/questions/69058384/export-images-from-google-sheets | |
function isImageToImage(){ | |
const ss = SpreadsheetApp.openById('XXXXXXXX'); // replace with your spreadsheet ID | |
const sheet = ss.getSheetByName('YYYYY'); // replace with sheet name | |
// row (4) and columns (A/B/C) | |
const urls = sheet.getRange(4,9, sheet.getLastRow()-1).getValues() ;//.flat(); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
return if !CurrentRecord.IsInProgress | |
timenow = dateprint({format:"U"}) | |
emp = db_record({system:"Employee" , id:CurrentRecord.Employee}) | |
contact = db_record({system:"Contact" , id:emp.Contact}) | |
opunit = db_record({system:"OperationalUnit" , id:CurrentRecord.OperationalUnit}) | |
ename = string({input:emp.DispayName , function:"urlencode"}) | |
url = "https://yourtyeform.typeform.com/to/FORMID?shift_id=#{CurrentRecord.Id}&employee_id=#{CurrentRecord.Employee}&employee_name=#{ename}&location_id=#{opunit.Company}" | |
msg = "Hey #{emp.FirstName}, please fill out this call report #{url} "; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#Save it as Reccord After Save | |
empAgreement = db_record({system:"EmployeeAgreement" , id:CurrentRecord.EmployeeAgreement}) | |
return 1 if !empAgreement | |
# is there a balance? | |
`<db_fetch system="LeaveAccrual" fetch="first_row" assign="lacc"> | |
<db_condition> | |
<db_compare column="Employee" function="ge"> | |
<atom var="empAgreement" index="EmployeeId"/> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
// manage session | |
session_start(); | |
// constants - please update after getting credentials from https://once.deputy.com/my/oauth_clients | |
define('DEPUTY_API_CLIENT_ID' , 'YOUR CIENT ID HERE'); | |
define('DEPUTY_API_CLIENT_SECRET' , 'YOUR API SECRET HERE'); | |
define('DEPUTY_API_REDIRECT_URI' , 'YOUR SERVER ADDRESS WHERE it will redirect'); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
// Just run via command line php -q sample_timesheet_fetch.php | |
date_default_timezone_set("Australia/Sydney"); | |
$actual_db = array(); | |
$total_count = 0; | |
// get all timesheets | |
//$search = array('emp_search' => array('field' => 'Employee' , 'data'=> "1" , 'type' => 'ge' ) ); | |
// get just everything since last 1 week | |
$search = array('created_search' => array('field' => 'Created' , 'data'=> date("Y-m-d 00:00:00" , strtotime("-1 week")) , 'type' => 'ge' ) ); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"field.subject" : "summary", | |
"project.lead" : "YOUR USERNAME", | |
"field.category" : "components", | |
"value.status.Closed" : "6", | |
"value.status.New" : "3", | |
"date.import.format" : "yyyy-MM-dd", | |
"value.status.Feedback" : "3", | |
"field.tracker" : "issuetype", | |
"project.name" : "Project", |