DEV Community: HibikiDaBull

How to reflect values received from Google Forms into a Google Doc with GAS

HibikiDaBull — Sun, 31 Mar 2024 22:02:02 +0000

I think there are people who often have to create documents in the same format as part of their regular work. It would be convenient if you could receive information from the requester via a form and reflect it in the document, such as inserting names, addresses, and start dates of employment into the same contract document, where the information changes depending on the party to the agreement, wouldn't it?

I have demonstrated a method for doing so in the repository below, along with GAS (Google Apps Script) code, a Google Form, and a Google Document. While the example is for an employment contract, I believe it can be applied to the automatic creation of various documents.

Github repo: https://github.com/HibikiDaBull/Hibiki_GAS-Hacks/blob/main/GAS%20Code_how%20to%20apply%20value%20from%20Google%20form%20to%20Google%20Doc

Google Document sample: https://docs.google.com/document/d/19TpSooLhsBHlCisv93mM_Tp6an4xisJToJ5hDUy61c0/edit

Google Form sample: https://docs.google.com/forms/d/1zO9vA_aTyRsmvcKaHmqcdfi3JyVcT4q_3l4HzO-8Xhg/edit

What is Amazon VPC ? and how to create it

HibikiDaBull — Sun, 30 Oct 2022 07:35:02 +0000

Amazon VPC is virtual network provided by AWS.
VPC stands for Virtual Private Cloud.
You can create a web services in VPC, and you can　also connect VPC to Internet.

In this post I will explain how to create a VPC with your AWS account.

At first you have to choose VPC in your AWS management console ,and next tap the "create VP" button.

After you tapped "create VPC" , you have to set CIDR block to reserve IP address for your VPC.

In this part , you may realize the notation "/24".
IP address is a binary number with 32 digits.
"/24" means the first 24 digits in this IP address is fixed , and the rest 8(32-24) digits are unfixed.

So with the address 172.16.1.0/24 ,you can reserve IP address ranging from 172.16.1.0 to 172.16.1.255 .

After you set the CIDR block , click the "create VPC" in button right bottom.
Now you have created one VPC.

3 services for someone who hates using a mouse🐭

HibikiDaBull — Mon, 03 Jan 2022 00:45:08 +0000

Using a mouse on computer is no more than one little action but, it could be a stressful experience when it comes to handling repeated tasks.
Today, I want to introduce 3 nice services for someone who hates using a mouse.
Let's get it started!

1.Rectangle

In short,Rectangle is an app that allows you to adjust the size and position of window so easily and smooth
.

With a combination of [option]＋[control]＋[(several keys)],you can move windows to anywhere in the desktop (to the bottom or corner or center or etc) or adjust their size.

You can also move windows in between multi displays with this app without using a mouse.

Here's a short movie of this app's demo.

2.Rearrange Tabs

Rearrange Tabs is a Chrome extension that allows you to change the order of tabs with keyboard.

With [shift]＋[control]＋(←or→)　,you can change the order of tabs in the browser so easily.

Here's a short movie of this app's demo

3.Vimium

Vimium is a Chrome extension that allows you to create shortcuts to almost every link in the browser.
Tap [f] or [shift]＋[f],then you will see yellow shortcut keys to every link in the web page. (see down below)

Goodbye to those days you were mashing [tab] key not to use a mouse.

Thanks to the ones who created those 3 nice services.