From Layout to Data – Seeking examples

General discussion here.

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.

What other examples come to mind?

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.

1 Like
  • A screen that needs a dedicated data source (thanks @Ja_ke)
  • Reusable custom forms (thanks @Darren_Murphy)

A specific table layout. For example, daily schedules of available workers for the week.

1 Like

Oh yes that’s a good one ! Not just a chart layout but also a specific table layout.

Thanks, Bob.

Consolidating just for reference:

(in no particular order)

  1. 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.
  2. Custom filter. Same idea.
  3. Generate chart & table layouts. For instance yearly, quarterly, monthly, weekly charts and tables.
  4. Choice components. A choice component sources the data from a general choices table or a specific table just that given component.
  5. Screen that needs a dedicated data source.
1 Like