Designing by coding Google Apps Script.

Опубликовано: 04 Май 2020
на канале: atom house

Learn how to create Web App with Google Apps Script and have it interact with Google Sheets using JavaScript & HTML.

Making a geometric design by programming Google Apps Script (GAS).

code:
==================================================
function autoColor() {
const sheet = SpreadsheetApp.getActiveSheet();
sheet.getRange(1,1,39,39).setBackground("white");

//----------change those numbers to change colors
const dividerBase = 6;
var redIntNum = sheet.getRange(1,41).getValue();
var greenIntNum = sheet.getRange(5,41).getValue();
var blueIntNum = sheet.getRange(9,41).getValue();

//----------do NOT change these
const redLeft = 255 - redIntNum;
const greenLeft = 255 - greenIntNum;
const blueLeft = 255 - blueIntNum;

for (var i = 0; i[[[ANGLED BRACKET]]]=dividerBase; i++){

//declaration of units that gradates colors
var redGradUnit = Math.round(redIntNum/dividerBase)-1;
var greenGradUnit = Math.round(greenIntNum/dividerBase)-1;
var blueGradUnit = Math.round(blueIntNum/dividerBase)-1;

//declaration of rgba values
var colorValueRed = redLeft + redGradUnit * i;
var colorValueGreen = greenLeft + greenGradUnit * i;
var colorValueBlue = blueLeft + blueGradUnit * i;
var colorCode = "rgb(" + colorValueRed + "," + colorValueGreen + "," + colorValueBlue + ")" ;

//declaration of vertical range
var repeatRangeVert = sheet.getRange(i+1, 14+i, 39-(2*i), 13-(2*i));
repeatRangeVert.setBackground(colorCode);

//declaration of left range
var repeatRangeLeft = sheet.getRange(14+i, 1+i, 13-(2*i), 13);
repeatRangeLeft.setBackground(colorCode);

//declaration of right range
var repeatRangeRight = sheet.getRange(14+i, 27-i, 13-(2*i), 13);
repeatRangeRight.setBackground(colorCode);
}
}
==================================================

Time took: 5 hours
Tools used:
none

Atom house presents drawings using pens, rulers, compass and hands. Paper used in my creation is A4-sized, just ordinary one.
It usually takes days or even weeks to finish one. I really hope I could be of any help for you guys to be creative, inspired or just have fun.

Please leave your comments in the comment box.
Your support will definitely give me more boost.
Suggestion, request and questions are always welcome.

Twitter: / atomhousetwitt

На этой странице сайта вы можете посмотреть видео онлайн Designing by coding Google Apps Script. длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь atom house 04 Май 2020, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 35 раз и оно понравилось 0 зрителям. Приятного просмотра!

806,412

3.5 тыс

00:00:00