Balancing with Google Apps Script
I learned Google Apps Script for fun. My current task is balancing game. I use google spread sheet for balancing game. There are some calculation that can't be done only with functions in Google Spread Sheet. At that moment, Google Apps Script is very useful. 1. Use function with button I wrote calculation that use random function. I wanted to refresh the result anytime I want to. But to click refresh button is not good. I found easy way. This way is using a Google Apps Script. 1) You put a button in spreadsheet. 2) Right click the button you made. Then choose 'allocate script'. 3) Allocate the function you write at a script editor. When doing this, just write the name of function. No '()' allowed. 4) You can write functions in Google Apps Script here. Upper menu bar> Tool> Script Editor Ignore other code from 'act' function. All I wanted is 'flush' method. 'flush' method refresh every value that are linked to 'curr...