The idea behind SpoG

Google Sheets, as well as Excel sheets, carry for many businesses their organizational data, from static data, to dynamic updating data. Sheets holds all kinds of constraints and relations between data parts, to encode complex data facts of the business, into the data structures supported by sheets. These relations, as well as the data structure itself, evolve with time, and the Sheets platform is easy to customize to adapt to these changes. With time more and more customizations put the integrity of the data at growing risk, and the user interface across the sheets may become inconsistent, as the customization is performed locally.

SpoG implements a layer of codeless meta-data, where the developer describes the data structures and relations in a flexible but unified way. SpoG then takes that meta-data and creates formatted sheets columns with UI components such as dependent comboboxes, so the user is provided with consistent interface for entering data, making data-actions such as complex queries, generating documents, and activating external interfaces. All of these keep a unified behavior which the user easily becomes familiar with, and they are generated codelessly, after the developer defines the meta-data, following SpoG logic.

The idea behind SpoG

Leave a Reply

Your email address will not be published. Required fields are marked *

Scroll to top