Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- *Oct 2019
- */
- /*
- * Handles a HTTP GET request, redirects to landingPage.html
- */
- function doGet(e){
- checkMultipleAccountIssue(initiator);
- if(e!= undefined){
- var page = HtmlService.createHtmlOutputFromFile('landingPage');
- page.setTitle("NUHS Theater Sales Tracker");
- return page;
- }
- }
- /*
- * Checks currently logged in user's email address for authorization against
- * a pre-existing range in the containing sheet.
- * @param user The user's email address.
- */
- function isEditAuthorized_(user){
- if(user == undefined){
- var user = Session.getActiveUser().getEmail();
- }
- var sheet = getSheetById_(435412363);
- var lastRow = sheet.getLastRow();
- var data = sheet.getRange("A1:" + "A" + lastRow).getValues();
- var isAuthorized = false;
- for(var i = 0; i < lastRow; i++){
- if(user == data[i]) {return true;};
- }
- return false;
- }
- function getSheetById_(id) {
- return SpreadsheetApp.openById("1Y9WMEnirPZtmosQOF4fRY7lpkPjPwij9QIk3Hv4mmw8").getSheets().filter(
- function(s) {return s.getSheetId() === id;}
- )[0];
- }
- function newEntry(formData){
- if(isEditAuthorized_(Session.getActiveUser().getEmail())){
- Logger.log("New Entry Attempt by: " + Session.getActiveUser().getEmail());
- var sheet = getSheetById_(0);
- // Write data to sheet.
- var entry = [
- formData.firstName,
- formData.lastName,
- formData.showtime,
- Session.getActiveUser().getEmail()
- ];
- sheet.appendRow(entry);
- // Log access data
- sheet = getSheetById_('1782382348');
- //var d = new Date();
- //Logger.log(d.getTime());
- entry=[
- ];
- sheet.appendRow(entry);
- }
- }
- function getSaleEntries(param, filter){
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement