CBM.SCAN
RFID ENTRY SYSTEM
NO SHEET
READY
TAP TO SCAN
GUEST ID
—
EVENT
—
VENUE
—
ACCESS TIER
—
TAG UID
—
SCANNED
—
LOG
EXPORT
SHEETS
MANUAL
No scans yet this session
EXPORT SCAN LOG
CSV — Excel / Numbers
DOWNLOADS AS .CSV — OPENS IN EXCEL, NUMBERS, GOOGLE SHEETS
↓
PDF Report
FORMATTED SCAN REPORT — SAVE OR PRINT
↓
Email Log
OPENS MAIL APP WITH LOG AS CSV ATTACHMENT
→
Clear Session
RESET ALL SCANS AND STATS FOR THIS SESSION
GOOGLE SHEETS — WEB APP URL
Paste the deployed Google Apps Script URL here.
See setup instructions below.
See setup instructions below.
EVENT ID FOR THIS SESSION
⚠ Not connected — paste your Apps Script URL above to enable live logging to Google Sheets.
SETUP INSTRUCTIONS
1. Open Google Sheets — create a new sheet named ScanLog
2. Add headers in row 1:
Timestamp | GuestID | EventID | VenueCode | AccessTier | TagUID | Result | Reason | AccessPoint
3. Go to Extensions → Apps Script
4. Paste the script from the CBM Scanner setup doc
5. Click Deploy → New Deployment → Web App
6. Set access to "Anyone"
7. Copy the deployment URL and paste it above
2. Add headers in row 1:
Timestamp | GuestID | EventID | VenueCode | AccessTier | TagUID | Result | Reason | AccessPoint
3. Go to Extensions → Apps Script
4. Paste the script from the CBM Scanner setup doc
5. Click Deploy → New Deployment → Web App
6. Set access to "Anyone"
7. Copy the deployment URL and paste it above
APPS SCRIPT CODE — COPY THIS
function doPost(e) {
try {
var data = JSON.parse(e.postData.contents);
var sheet = SpreadsheetApp
.getActiveSpreadsheet()
.getSheetByName('ScanLog');
sheet.appendRow([
data.timestamp,
data.guestId,
data.eventId,
data.venueCode,
data.tier,
data.uid,
data.result,
data.reason,
data.accessPoint
]);
return ContentService
.createTextOutput(JSON.stringify({status:'ok'}))
.setMimeType(ContentService.MimeType.JSON);
} catch(err) {
return ContentService
.createTextOutput(JSON.stringify({status:'error',msg:err.toString()}))
.setMimeType(ContentService.MimeType.JSON);
}
}