Skip to content

Instantly share code, notes, and snippets.

@QPeiran
Created May 8, 2020 05:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save QPeiran/6cfe91468b805ba1e18b0b6075170e3c to your computer and use it in GitHub Desktop.
Save QPeiran/6cfe91468b805ba1e18b0b6075170e3c to your computer and use it in GitHub Desktop.
Push data from "monitor sheet"
//
function extractInfo()
{
var current_sheet = SpreadsheetApp.openById("<MonitorSheetID>").getSheetByName("Monitor");
var array = []
for (var i = 2; i < 101; i++)
{
var value = current_sheet.getRange(i, 5).getValue();
if (value)
{
var loc_day = (Math.ceil(i/5) - 1) * 5 + 2;
var week_day = current_sheet.getRange(loc_day, 2).getValue();
var recipe = current_sheet.getRange(i, 3).getDisplayValue();
var arr = [week_day, recipe, value]
array.push(arr);
}
}
return array;
}
function pushNumber(e)
{
var Dest_sheet = SpreadsheetApp.openById("<YourSheetID>").getSheetByName("Meal Kits Produced");
var get_Days = Dest_sheet.getRange(1, 2, 1, 7).getDisplayValues()[0];
var get_Recipe = Dest_sheet.getRange(2,1, 29).getDisplayValues().map( e => {return e[0]});
var Arr = extractInfo();
Arr.map(Arr => {
var loc_day = get_Days.indexOf(Arr[0]);
var loc_recipe = get_Recipe.indexOf(Arr[1]);
var value = Arr[2];
Dest_sheet.getRange(loc_recipe + 2, loc_day + 2).setValue(value);
});
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment