So, I’ve been teaching myself JavaScript to use with Google Sheets to make little programs to improve my life for several months now (side projects). I’m working on a randomizing Dinner Picker right now, but I’ve been stuck on this looping array for weeks now, and scouring Google and forums hasn’t yielded results yet.
This is where I am stuck. The array works with the logger portion, but nothing else. I cannot figure out what I need to replace the ??? with to get the values of certain cells in the rows, so I can check against them, and add the values of one cell into another.
// A looping function that goes down the rows, starting with row 2, and adds +1 to +5 depending on the priority of the meal.
// Stops and continues the main script once a priority is null.
function iterateThroughRows() {
var activePage = SpreadsheetApp.getActive().getSheetByName("Meal List");
var data = activePage.getDataRange().getValues();
data.forEach(function (row) {
Logger.log(row);
var mealPriority = ???(row, 2).getValue(); // MEAL ( B / 2 )
var mealSkip = ???(row, 3).getValue(); // TEMP_SKIP ( C / 3 )
var mealPickedChance = ???(row, 4).getValue(); // PICKED_CHANCE ( D / 4 )
console.log("Logger Row"); // DEBUGGING LOGS
console.log("mealPriority = " + mealPriority); // DEBUGGING LOGS
console.log("mealSkip = " + mealSkip); // DEBUGGING LOGS
console.log("mealPickedChance = " + mealPickedChance); // DEBUGGING LOGS
// if mealSkip == TRUE (set to FALSE and skip to the next row)
// else mealPickedChance.setValue(mealPickedChance+mealPriority);
});
}
I am trying to capture the values of 3 cells in each row.
One value is a bool, if it is set to TRUE, I want to change it to FALSE and them skip to the next row.
If that value is FALSE, I want to take the int value of one cell and add it into another.
(Example, if mealPriority = 5 and mealPickedChance = 4, then mealPickedChance would get updated to = 9.)
Rinse and repeat until the array finishes all rows.
So far I have tried:
-
getRange
-
getRow
-
getColumn
-
getCell
-
row
-
column
I’m pretty sure I can figure out the if and else statement and how to add the value from one cell to another. I’m just stuck on how to capture those values in the first place. Any help in the right direction would be greatly appreciated.