tinod-code
-
Joined
Oct 19, 2025
tinod-code
/ gist:a5886c023dbcf29b5b336897fe74b8e9
Created
October 19, 2025 06:35
Mengubah link Google Drive menjadi direct link
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * Mengubah link Google Drive menjadi direct link (uc?id=...) | |
| * Bisa memproses link tipe: | |
| * - https://drive.google.com/file/d/ID/view | |
| * - https://drive.google.com/open?id=ID | |
| * | |
| * Otomatis mendukung array (range) dan mengabaikan sel kosong. | |
| * Contoh penggunaan: | |
| * =DriveDirectLink(I2:I) | |
| * =DriveDirectLink(I2) |
tinod-code
/ gist:fb657b328fa569e0c02bf4aeec954664
Last active
October 19, 2025 03:53
Mengubah tanggal format Indonesia menjadi format US pada google sheet
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * Mengubah tanggal format Indonesia (misal: "16 Oktober 2025") | |
| * menjadi format US (misal: "October 16th, 2025") | |
| * | |
| * Cara pakai: | |
| * =IDTOUS(A1) | |
| * atau untuk banyak baris: | |
| * =IDTOUS(A1:A) | |
| */ | |
| function IDTOUS(inputRange) { |