In the case of the existing body temperature recording 1, after scanning, after checking the name and entering additional information, it was saved, but in the case of the body temperature recording 2, it is possible to enter the normal body temperature immediately after scanning qr. The writing time can be minimized)
1. You need to create a Google sheet
2. Make a column for entering name, body temperature, cough, sore throat, difficulty breathing, sputum, contact information, purpose of visit, etc., timestamp
3. Coded in script
function doGet(e){
var ss = SpreadsheetApp.openById("SheetID");
var sheet = ss.getSheetByName('sheet name');
addUser(e,sheet);
}
function doPost(e){
var ss = SpreadsheetApp.openById("SheetID");
var sheet = ss.getSheetByName('sheet name');
addUser(e,sheet);
}
function addUser(e,sheet){
var Name = e.parameter.Name;
var Temp = e.parameter.Temp;
var Sta1 = e.parameter.Sta1;
var Sta2 = e.parameter.Sta2;
var Sta3 = e.parameter.Sta3;
var Sta4 = e.parameter.Sta4;
var Sta5 = e.parameter.Sta5;
var Come = e.parameter.Come;
var Memo = e.parameter.Memo;
var Time = e.parameter.Time;
sheet.appendRow([Name,Temp,Sta1,Sta2,Sta3,Sta4,Sta5,Come,Memo,Time]);
}
4. Create URL to be accessible
5. Enter the URL into the app storage path and you're done
1. You need to create a Google sheet
2. Make a column for entering name, body temperature, cough, sore throat, difficulty breathing, sputum, contact information, purpose of visit, etc., timestamp
3. Coded in script
function doGet(e){
var ss = SpreadsheetApp.openById("SheetID");
var sheet = ss.getSheetByName('sheet name');
addUser(e,sheet);
}
function doPost(e){
var ss = SpreadsheetApp.openById("SheetID");
var sheet = ss.getSheetByName('sheet name');
addUser(e,sheet);
}
function addUser(e,sheet){
var Name = e.parameter.Name;
var Temp = e.parameter.Temp;
var Sta1 = e.parameter.Sta1;
var Sta2 = e.parameter.Sta2;
var Sta3 = e.parameter.Sta3;
var Sta4 = e.parameter.Sta4;
var Sta5 = e.parameter.Sta5;
var Come = e.parameter.Come;
var Memo = e.parameter.Memo;
var Time = e.parameter.Time;
sheet.appendRow([Name,Temp,Sta1,Sta2,Sta3,Sta4,Sta5,Come,Memo,Time]);
}
4. Create URL to be accessible
5. Enter the URL into the app storage path and you're done
Show More