Recent Completions
Search a worker's name to verify orientation status before allowing site access.
Orientation Videos — Vimeo IDs
Find your Vimeo video ID in the URL: vimeo.com/123456789 — paste just the numbers.
To permanently save these IDs, open the HTML file in Notepad and find:
const VIMEO_EN = '1176965298';
const VIMEO_ES = '1176967345';
Replace the placeholder text with your actual Vimeo IDs and save.
const VIMEO_EN = '1176965298';
const VIMEO_ES = '1176967345';
Replace the placeholder text with your actual Vimeo IDs and save.
💡 Make sure your Vimeo videos are set to Unlisted or Public — Private videos will not embed.
Step 1 — Create your Google Sheet
Go to sheets.google.com and create a new blank spreadsheet.
In Row 1, add these column headers exactly:
Name | Company | Project | Timestamp | Confirmation ID | Status | Certs Held | Certs Uploaded
Name the sheet tab: Completions
In Row 1, add these column headers exactly:
Name | Company | Project | Timestamp | Confirmation ID | Status | Certs Held | Certs Uploaded
Name the sheet tab: Completions
Step 2 — Add the Apps Script
In your Google Sheet, click Extensions → Apps Script. Delete any existing code, paste the script below, then save.
function doPost(e) {
var sheet = SpreadsheetApp
.getActiveSpreadsheet()
.getSheetByName('Completions');
var data = JSON.parse(e.postData.contents);
sheet.appendRow([
data.name,
data.company,
data.project,
data.timestamp,
data.id,
data.status,
data.certsHeld,
data.certsUploaded
]);
return ContentService
.createTextOutput('OK')
.setMimeType(ContentService.MimeType.TEXT);
}
Step 3 — Deploy as a Web App
In Apps Script click Deploy → New deployment.
• Type: Web app
• Execute as: Me
• Who has access: Anyone
Click Deploy, authorize when prompted, and copy the Web app URL.
• Type: Web app
• Execute as: Me
• Who has access: Anyone
Click Deploy, authorize when prompted, and copy the Web app URL.
Step 4 — Paste the URL into the portal file
Open the HTML file in Notepad and search for:
const SHEETS_URL = '';
Paste your URL between the quotes:
const SHEETS_URL = 'https://script.google.com/macros/s/YOUR_ID/exec';
Save. Every completed orientation will now write a new row — including which certifications were held and which files were uploaded.
const SHEETS_URL = '';
Paste your URL between the quotes:
const SHEETS_URL = 'https://script.google.com/macros/s/YOUR_ID/exec';
Save. Every completed orientation will now write a new row — including which certifications were held and which files were uploaded.