Skip to content

Releases: TheSortingHash/DigitalDocumentLogbook-GAS

v1.0.0: Finance Logbook Automation Kit - The "No-Code" Starter Template

23 Jan 05:25
@TheSortingHash TheSortingHash
google-apps-script
db22964
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.

Choose a tag to compare

View all tags
v1.0.0: Finance Logbook Automation Kit - The "No-Code" Starter Template Latest
Latest

Release Notes: v1.0.0 - Initial Public Release

Title: Finance Digital Document Logbook (Open Source Edition)
Tag: v1.0.0

🎉 Welcome to the Future of Document Tracking!

We are thrilled to release v1.0.0 of the Finance Document Management System (DMS). This project was born out of a simple need at the Development Academy of the Philippines (Finance Dept): to finally stop using handwritten logbooks and start tracking documents digitally.

Who is this for?
This release is specifically designed for government offices, admin units, and teams who have little to no coding experience but want to modernize their workflow. If you can use Google Sheets and copy-paste code, you can run this system!

🚀 What's Inside?

This system helps you manage two common office headaches:

1. The "Incoming Documents" Workflow (External)

  • The Problem: Clients drop off documents, and you write them in a logbook. Later, they call to ask, "Is it signed yet?" and you have to dig through pages to find out.
  • The Solution:
    • Digital Entry: Your staff logs the document into a simple web form.
    • QR Slips: The system prints a small slip with a QR code to attach to the file.
    • Auto-Email: The client automatically gets an email saying, "We received your document."
    • Auto-Notify: When your Manager signs it, the system emails the client: "Ready for pickup!"

2. The "Office Routing" Workflow (Internal)

  • The Problem: You pass a file to a colleague for review, but they forget they have it.
  • The Solution:
    • Digital Handover: Scan the QR code, select your colleague's name, and have them digitally initial on your tablet/phone.
    • Tracking: The system records exactly who has the document and when they received it.

💡 Why You Should Try It

  • Zero Cost: Runs entirely on your existing Google Workspace (Sheets, Drive, Gmail). No subscriptions needed.
  • Copy-Paste Setup: We have written the code so you don't have to. The README contains a step-by-step guide on how to copy this into your own Google Sheet.
  • No More Handwriting: Say goodbye to illegible logbook entries.
  • Searchable: Find any transaction from months ago in seconds.

🛠️ Getting Started

You don't need to be a developer to use this!

  1. Check the README: Follow the "Database Setup" to prepare your Google Sheet.
  2. Copy the Code: Copy the files from this repository into your Google Apps Script editor.
  3. Deploy: Click "Deploy" and start using your new Digital Logbook.

We encourage you to fork this repository, customize it for your office, and share your improvements back with the community!

Assets 2
Loading