Most of the time in Glide, it’s wise to start with the data in mind and then to build the layout. Here, the data determines the layout.
But sometimes, it is a specific layout that drives a specific data setup. For example:
A custom form. This specific layout requires a single-row helper table. That single-row helper table wouldn’t “naturally” exist in the database schema if it weren’t for the custom form.
A custom filter. Same idea.
Yearly, quarterly, monthly, weekly charts.
Choice components. A choice component sources the data from a general choices table or a specific table just that given component.
Sometimes if i have a dashboard that i want to have collections and other fields from many different tables accessible in one screen. I often use a single row table with all user specific columns that once done, its an odd assortment of lookups, templates and queries.
I have always wondered if I was missing a better way of doing something when i had this.
Custom form. This specific layout requires a single-row helper table. That single-row helper table wouldn’t “naturally” exist in the database schema if it weren’t for the custom form.
Custom filter. Same idea.
Generate chart & table layouts. For instance yearly, quarterly, monthly, weekly charts and tables.
Choice components. A choice component sources the data from a general choices table or a specific table just that given component.