menu

Glide

🚨🚨🚨 The Glide community forum has moved! Please click the new link below:

Channels
# All channels
view-forward
# General
view-forward
# Announcements
view-forward
# Bugs
view-forward
# Bugs (Fixed)
view-forward
# Feature Requests
view-forward
# Help
view-forward
Team

Inventory of Freezer with Glide App & automated move row to different sheet

May 12, 2019 at 5:23am

Inventory of Freezer with Glide App & automated move row to different sheet

May 12, 2019 at 5:23am
Glide Apps are mobile apps that can be created for free using just data from Google Sheets. GlideApps home: https://www.glideapps.com/ Video:
This is a simple Inventory of my Freezer. This app could extend to a warehouse type inventory. It follows on from a process I was developing using the GlideApps SWITCH Component to activate a change in the Sheet on my DEFECTS LIST APP. This activation AUTOMATICALLY copies the row from the sheet to Another sheet and deletes that row in the original sheet.
The script for doing this is: function Used() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheetByName(FromSht);
var data = sheet.getRange(13,7).getValue(); // Logger.log(data);
var lastrow=sheet.getLastRow(); // iterate from row 13 on dowbn to last row for(var i=13;i<lastrow +1;i++){ //get value in column 7 data = sheet.getRange(i,7).getValue(); //if that value is TRUE then inner loop if(data==true){ //get that whole row of data from Col A to 9th column
var dataRow = sheet.getRange(i,1,1,9).getValues();
sheet.deleteRow(i);
Logger.log(dataRow); nextSheet = ss.getSheetByName(ToSht); lastRow = nextSheet.getLastRow(); nextSheet.getRange(lastRow+1,1,1,9).setValues(dataRow); }else { // Logger.log(data); // Logger.log(i); } } }
I’d like to say thankyou to the Learn Google Spreadsheets videos for helping me get the iteration process working from this video:

May 12, 2019 at 11:16am
Very cool about copying data automatically between sheets. Thanks for sharing!!
like-fill
1
  • reply
  • like

January 2, 2020 at 9:45pm
Hi! This looks cool. Im also trying to build an inventory app. But I'm unable to get the script to execute every time data changes. How do you ensure that? Did you setup a trigger?
  • reply
  • like
private
This channel has been archived