Google Spreadsheets
Google Spreadsheets forms the foundation of GUBUS desktop concepts. We have enhanced these concepts to a more sophisticated level of logical patterns, creating a unique GUBUS approach.
- Admin Panel (manages rules and routing data)
- Localizer (handles front-end mapping functionality)
- Input Sheets (available in two types)
- Mosaic Input (for complex items)
- Multipanel Input (for simple inline inputs)
- Workfeeds (sections containing crucial data flows, formulas, and data validations)
- Buttons, which trigger the GUBUS server to execute GUBUS operations
- Formulas, responsible for scanning, summarizing, filtering, and sorting data
The primary building blocks of GUBUS, namely multipanels and workfeeds, can be seamlessly integrated with each other on the same sheet. Learn more about it on the Workspaces page...
Google Apps Script
The Apps Script ecosystem is a remarkable feature of the Google Cloud Platform.
Google Apps Script operates serverlessly on the backend of each Spreadsheet. It's freely available to all users and can interact with any endpoint on the web using the urlFetchApp method, fetching responses from any server and populating Spreadsheets with external data.
With the Apps Script ecosystem, you can swiftly create a web application, library, executable API, or an add-on. It might operate slowly, but it will function!
To be honest...
... everything that GUBUS offers here can be built by yourself using Google Apps Script. There's no fee for using it, and its built-in API - SpreadsheetApp is simply fantastic... but it will be significantly slower than GUBUS!
GUBUS minimizes the use of Google Apps Script and the SpreadsheetApp class. Ideally, it doesn't use the built-in SpreadsheetApp at all. Even when it comes to retrieving data from a single cell, it's faster if GUBUS does it itself through Google REST API v4.
Buttons
Buttons are the most effective way to operate GUBUS. Maintaining buttons in Google Spreadsheets can be costly, so we limit the number of buttons in interfaces and automate as much of your project as possible.
When you click a button, Google Apps Script activates and runs its urlFetchApp method, contacting the GUBUS server. Upon being triggered, GUBUS retrieves client-specific rules from its database and performs its operations, such as reading, transforming, deleting, and posting data. It's that simple!
You will understand it when you use it...
Think of GUBUS as a series of atomic routing data events. It happens instantly, reads data, deletes rows, inserts rows, updates cells, and then disappears. GUBUS is a small but essential part that performs all the most complex, intelligent work that could be done manually. And there's a BIG essential part... We simply call it Google Spreadsheet Formulas.
Formulas
Google Spreadsheets as a whole, and FORMULAS in particular, are the critical functional aspects of your well-structured, dynamic, intelligent project. Without formulas, GUBUS would be non-functional.
When GUBUS posts or changes something in a range observable by a formula, the formula's output changes instantly. It's a reactive mechanism, a secret ingredient that makes GUBUS magic possible. It's akin to the wave-particle concept of light, where the particle represents GUBUS's posting magic, and the wave represents the formula changes that spread throughout the spreadsheet!
For more about the formulas that GUBUS uses to create a detailed replica of your project, read here...
A truly marvelous project!
Join our Newsletter
Subscribe to stay up to date with the latest GUBUS updates, features, and videos!