I am building an app that will provide users with multiple multi-stop walking tours for a given Town. I am struggling with Glide trying to figure out the best way to represent two levels of multiple sets of data. Specifically, here are the categories and hierarchy of data:
Level 1: Tours – this is a list of the walking tours. For each of the tours, there is a Name, Description, Starting location, etc… Currently, I have three tours, but this will grow to 10-15 over time.
Level 2: Stops – for each named stop, there is a Picture of the stop, a Description of the stop, the Location of the stop, and the Next Stop. Currently, for the three tours, the number of stops varies from 7 to 10.
Visually, here is an outline of my current data:
Level 1: Tours
…Level 2: Stops
Lexington Battle Green
Old Burying Ground
…Childs Family Grave
…Hancock & Clarke Tabletop Grave
…Original Militia Burial Site
Hancock St. Architecture
…12 Hancock Street
…8 Goodwin Road
…16 Hancock Street
My initial strategy for my spreadsheet data was to have one sheet in a Google Spreadsheet for the list of Tours. This sheet has three rows, one for each tour.
It’s when I get to the stops for each of the multiple tours that I am getting confused. My first approach has been to have one sheet for each of the different tours. This means that there are three sheets containing the stops of the three different tours.
Stops in all three tours have the exact same style of presentation with a combination of text, images, audio, and maps.
I have successfully created the template for displaying the stops of the first tour (i.e., one of the tour/stops sheets).
Now I have discovered that there is no obvious way to apply that same template to the contents (stops) of the other two sheets.
One idea I had was to put all of the stops into one sheet and have a field that I could filter on to indicate which of the three tours a stop belonged. But that seems wrong. I like the modularization of the multiple sheets in a Google Spreadsheet and don’t like having to use this additional field to simulate multiple sheets of the same type of data.
What am I missing?