Mahdi About RealSlimMahdi

Project Requirements Document: The Urlist Website

The following table outlines the detailed functional requirements of The Urlist website.

Requirement ID	Description	User Story	Expected Behavior/Outcome
FR001	Creating a New URL List	As a user, I want to be able to start a new, empty list so I can begin adding URLs.	The system should provide a clear way for the user to initiate the creation of a new list, potentially presenting an empty list view or an "add new list" button.
FR002	A

Hiding and Deleting Rows and Columns on Google Spreadsheet using Google Apps Script

These are the sample scripts for hiding and deleting rows and columns on Google Spreadsheet using Google Apps Script. I sometimes see the questions for hiding and deleting rows and columns on Spreadsheet at Stackoverflow. So here, I would like to introduce the sample scripts for this.

In this case, when the process costs of the scripts created by using Spreadsheet service and Sheets API are compared, the cost of script created by Sheets API is much lower than that of script created by Spreadsheet service. So when the rows and columns of your Spreadsheet is large and you can use Sheets API, I recommend to use Sheets API.

Sample situation

As the sample situation, the following sample Spreadsheet is used.

VSCode Shortcuts

List of helpful shortcuts for faster coding

If you have any other helpful shortcuts, feel free to add in the comments of this gist :)

Official List of all commands

Windows
Mac

	{
	"name": "workshop-setup",
	"version": "1.0.0",
	"description": "This is the common setup script for most of my workshops",
	"bin": "./setup.js"
	}

	import React from "react"
	import { render, Static, Box, Color, Text } from "ink"
	import BigText from "ink-big-text"
	import BBox from "ink-box"
	import TextInput from "ink-text-input"
	import { Tabs, Tab } from "ink-tab"
	import _ from "lodash"

	const purple = [102, 51, 153]
	const hexPurple = `#663399`