Thank you! This looks like it might be what I haven’t seen or understood yet!
I’ll try and watch them at work today and see if I can get it through my thick skull 
1 Like
And now it is all behaving itself the way that its meant to - thank you all for your perseverance and expertise. Thank you for dumbing it down enough for me to finally find the right buttons to hit in the right order. Now to nestle the grandchildren under their children! Fingers crossed!
(Yes, I know they arent unique row numbers and Ill have trouble down the track but it just wasn’t obvious how to do that. Ill change it as soon as I work out how to. For now, I just want to see it working!!)
2 Likes
So, now that that part is working, I have new question… Same type of problem…
When building the grandchild spreadsheet for the third layer for people to delve into the individual walks, waterfalls and cafes, each category has totally different info.
Everything has a name, description and location, a lot have amenities but Waterfalls dont have opening hours and cafes don’t have track grades for example.
Do I build this spreadsheet with every heading and just put whats needed under each heading and leave the rest blank?
Do you have some advice for this level of my app? This is as far as I need to go. The third layer of individual information under the individual walks, cafes and other info.
Thanks again - I couldn’t have got this far without your help! 
I would suggest still keeping that under the same spreadsheet, and group your column names like this for easier tracking in the Data view.
“Cafes/Opening Hours”
“Cafes/Column 2”
“Waterfalls/Track Grades”
“Waterfalls/Column 4”
So, Only two spreadsheets?
The parent with the three categories (Experiences/Plan/Learn)
The children (waterfall/walk/history) with a relationship column/link to the parent (Experiences/Plan/Learn)
How do I put in the huge variety of info for the individual 27 categories (that’s each individual cafe, waterfall, track, etc) ?
Opening hours location, menu, images, walk grade, waterfall type, directions, maps, etc - or do I put all in one giant spreadsheet and leave some parts blank?
I mean in the Grandchild spreadsheet, you have columns like above, so it’s 3 not 2.
Would the info differ a lot between those 27 categories though? If you expect not too many columns in total, I would still only do it in one sheet. You don’t want 27 sheets for 27 categories.
Ah, so three spreadsheets! Yes!
Yes, a lot differs. The info for the cafes is different from the walks, the animals that you’ll see and history differs greatly from where you will find wifi and toilets.
I have 27 individual entries for the children and then each of these 27 have a minimum of one but up to 10 grandchildren under them.
Im quite keen to find a way to make this work - Im happy to do a ton of cutting and pasting. I have 90% of the info in the 27 tables already.
So in each category, how many columns of info would you expect?
I’m trying to think of a way that doesn’t make you create 27 sheets, but I fear it might be too complex to setup.
What I tried was building a spreadsheet where I tried to have as few top-row categories as possible.
What I couldn’t find corresponding info for, I left blank.
I called a few rows Info 1 and Info 2 and put in things that had no correlation to anything else.
It works but I have a relationship problem.
I used words for the Row Id (I know you said not to) as I cant figure out how to get it to self-populate with a row ID reliably. Sometimes it does but often it doesn’t.
How do I make a relationship between the grandchildren (3rd layer) and the children (2nd layer)?
For the record - I already have the 27 spreadsheets - I just cut and pasted them into one giant grandchild one with every waterfall, cafe etc. I still have them separate - just in case. Ive done the hardest part - compiling it all!
Sounds like you didn’t actually have a RowID column.
RowID is a special type of column. Once you add a RowID column, it will always add a value for every row.
2 Likes
Its displays well - the blanks just don’t appear.
Whats wrong is the original issue. I have all the grandchildren under every parent again…
So Im thinking I don’t have the relationship column right yet. Or Im asking Glide to display the wrong thing?
What do you think?
Sorry, I meant all my grandchildren are under each child, rather than under the parent as quoted. The parent/child level is working. The child/grandchaild is not.
That’s not a RowID column, it’s just a normal Text column that you have named “RowID”.
To get a proper RowID column you should add the column via the Glide Data Editor, and select the Row ID column type.
Anyway, it looks like you are using that column as your second level categories, so you may as well rename it for clarity.
Can you show us how each of your relations are configured?
1 Like
Your “Catagory” column here appears to be User Specific. I can tell that because the “T” icon is coloured blue. That will not work, so you should fix that first. Add another column with the same name, do not check the “make user specific” box, copy/paste the values into the new column, then delete the original.
I can’t see how your relations are configured, but this is how they should be:
- In your first table:
– Match Category with Category in your Children table - In your second table:
– Match Title with Category in your Grandchildren table
To make it more robust (as others have suggested), instead of having Category names in your Grandchildren table, you would have the matching RowID values from your Children table. That would allow you to change any of the Children names without breaking any relations.
2 Likes
The first and second layer are now behaving very well Thank you all so much!
I get everything I want under each of the original three headings - this is perfect. Ive formatted it and its all good.
On the third level where all the details for the individual items are, I’m getting every single item. I haven’t managed to break walks into the walk section and waterfalls into the waterfall section in the third level.
Does this third level have a relationship column?
This is my children’s (2nd level) with the relationship configuration. Is this right? Is the match multiple tick correct?
I will change it all to rowIDs as soon as I understand how to make the relationships work with the names (Im slightly numerically dyslexic and get easily confused with long strings of numbers) but I’m sure I can substitute them when it is all in the right place
