체온기록하기2 icon

체온기록하기2

John Ryu
Free
10+ downloads

About 체온기록하기2

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

체온기록하기2 Screenshots

More from John Ryu