Gists This sample script is converted this sample script (javascript) to Google Apps Script. The point for converting is signature as shown in the following sample script. At Bitfinex API, after "/api/" + apiPath + nonce + rawBody is encrypted using HMAC SHA-384, the data of byte array is converted to HEX. In Google Apps Script, there is no the method for this. The data which was encrypted by Utilities.
Gists This sample script is for splitting string by N characters for batch-file. In this sample, after it retrieves N characters from the first character of STR, the N characters are removed from STR. This is repeated until the end of STR. Sample script : @ECHO OFF SETLOCAL ENABLEDELAYEDEXPANSION SET "STR=ABCDEFGHIJKLMNOPQRSTUVWXYZ" REM Split STR by N characters SET "N=2" :LOOP SET "RES=%RES%!STR:~0,%N%! " SET "STR=!STR:~%N%!" IF DEFINED STR GOTO LOOP ECHO "%RES:~0,-1%" Result : N=2 "AB CD EF GH IJ KL MN OP QR ST UV WX YZ" N=5 "ABCDE FGHIJ KLMNO PQRST UVWXY Z" Reference : https://stackoverflow.
RearrangeScripts was updated. Added “About” to the menu of add-on. By this, users can see the help document easily. Add-on GitHub
Gists In this report, I would like to introduce a workaround for automatically recalculating custom functions on Spreadsheet. 1. Situation The sample situation is below. This is a sample situation for this document. There are 3 sheets with “sheet1”, “sheet2” and “sheet3” of sheet name in a Spreadsheet. Calculate the summation of values of “A1” of each sheet using a custom function. Sample script of the custom function is as follows.
RearrangeScripts was published as an add-on application Recently, I have reported RearrangeScripts for rearranging scripts in a GAS project. At that time, I got messages and mails from many developers. They said that you should publish this as an add-on. So, this was released. Now you can search “RearrangeScripts” as an add-on for Spreadsheet. If this is helpful for you, I’m happy. Add-on GitHub Demo