Google-Sheets-I-O-Table

Customizable Input-Output Table on Google Sheets using Apps Script

Comment

Google Sheets I/O Table

Google Sheets with Apps Script

Description

I/O Table is a Google Sheet app to log input/output using Google Apps Script.

Upon inserting an input...

Input
// insert input here
Output
No. Date Input

It automatically updates the table and clears the input cell.

Input
Output
No. Date Input
1 DD/MM/YYYY // input appears here

Quick Start

  1. Copy the following table. Make sure the "Input" column is on the cell A1.

    Input
    Output
    No. Date Input

  2. Paste the table in a desired location in your Google Sheet.

  3. Open Tools > Script Editor.

  4. Remove the empty myFunction(){} and make your Code.gs look like Code.gs.

  5. On the line "insertValues(...)", edit the parameter inputs to your customized needs.

  6. Save changes, and enjoy!

Share this project:

Updates