Register Form

function doGet(e) { var x = HtmlService.createTemplateFromFile(""); var y = x.evaluate(); var z = y.setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL); return z; } function AddRecord(name, email, phone) { var url = ''; var ss= SpreadsheetApp.openByUrl(url); var webAppSheet = ss.getSheetByName("Sheet1"); webAppSheet.appendRow([name,email,phone]); }

Login Form

If you don't have an account,

Create Account

Password must contain letters and numbers. It will not work without letters and numbers.

Your account has been successfully created. Login to your account

Hi !

You are successfully logged in.

**************

function doGet(e) { var x = HtmlService.createTemplateFromFile(""); var y = x.evaluate(); var z = y.setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL); return z; } function checkLogin(username, password) { var url = ''; var ss= SpreadsheetApp.openByUrl(url); var webAppSheet = ss.getSheetByName("DATA"); var getLastRow = webAppSheet.getLastRow(); var found_record = ''; for(var i = 1; i <= getLastRow; i++) { if(webAppSheet.getRange(i, 1).getValue().toUpperCase() == username.toUpperCase() && webAppSheet.getRange(i, 2).getValue().toUpperCase() == password.toUpperCase()) { found_record = 'TRUE'; } } if(found_record == '') { found_record = 'FALSE'; } return found_record; } function AddRecord(usernamee, passwordd, email, phone) { var url = ''; var ss= SpreadsheetApp.openByUrl(url); var webAppSheet = ss.getSheetByName("DATA"); webAppSheet.appendRow([usernamee,passwordd,email,phone]); }

	Your Company
	kadra, Shahrasti, Chandpur
	Your Profile
	Phone	01920352398		SA2577
	Name		Employee ID		premium	inst.No
	Sofikul Islam		RD202401		1000	1
	Address		First Payment		Total Amount	Last Payment
	Kadra, Shahrasti,Chandpur		8/1/2024		1,000.00	8/1/2024
	Nominee Name		Relation	Expiry
	Tanzila Akter Alo		wife	1 year
	Adjust. Date	inst.no	Premium		payment	Amount
	8/1/2024	1.00	1,000.00		bKash	1,000.00
					1,000.00

এখানে ক্লিক করুন