Welcome to the KriyaNiti Group.
We are learners and we make learners.
We are very passionate about simplifying complex task...
Here we provide basic and needy scripts...
for learning purpose.....
Thankyou for joining us
@KriyaNiti
Here is a source code for a simple inventory management system using Google Apps Script: function checkInventory() { var sheet = SpreadsheetApp.getActiveSheet(); var data = sheet.getDataRange().getValues(); var message = "Inventory:\n"; for (var i = 1; i < data.length; i++) { var item = data[i][0]; var quantity = data[i][1]; message += item + ": " + quantity + "\n"; } Browser.msgBox(message); } function updateInventory(item, amount) { var sheet = SpreadsheetApp.getActiveSheet(); var data = sheet.getDataRange().getValues(); for (var i = 1; i < data.length; i++) { if (data[i][0] == item) { var newQuantity = parseInt(data[i][1]) + amount; sheet.getRange(i+1, 2).setValue(newQuantity); break; } } } function submitForm(e) { var i...
To create a CRUD web application with Google Apps Script, we will use Google Sheets as our database and build a web interface using HTML and JavaScript. Here is an example code for a basic CRUD web application: Step 1: Create a new Google Sheet To begin, open a new Google Sheet and give it a name. This sheet will serve as the database for our CRUD application. In the first row, add the following headers: "ID", "Name", "Email", "Phone". Step 2: Create a new Google Apps Script Next, click on "Tools" in the menu bar and select "Script editor". This will open the Google Apps Script editor. In the editor, create a new script file and give it a name. Step 3: Create the HTML interface In the script editor, create a new HTML file by clicking on "File" -> "New" -> "Html file". Name the file "index". In this file, we will create the interface for our CRUD application. Here is an example co...
“Parsing filters unsupported” error during extraction of RAR in Ubuntu install unrar: sudo apt-get install unrar then to extract, go to the path of the .rar file and run commond : unrar x [filename.rar]
Comments
Post a Comment