This should be using the relation instead of directly pointing to the table.
1 Like
I think I have done itā¦
I works.
Im a bit shell shockedā¦
And quite pleased. 
Thank you to everyone who weighed in and helped. I have spent the whole afternoon going backwards and forwards, copying & pasting and then re-pasting, moving things and cursing my slow internet!
Is there a way of sharing it with you so you can see this incredible achievement that you have helped me create? Im hoping this link worksā¦
I still have a couple of gaps as I donāt know how to achieve what I hope to do next but thereās always tomorrow to deal with that!
Thank you, again for getting me this far. I donāt think I have a career as an app developer ahead of me though!
Well done
It does, but you might want to check your Privacy Settings because it looks like you have it set up for restricted access. Presumably you want the App to be open to anyone?
If you tell us which plan you have and show your current privacy settings, we can help recommend the best settings for your use case.
Weāre always here to help and encourage
You never know, you might surprise yourself 
Im only on the free plan as I wasnāt sure I was ever going to crack this. While Iām still working on it, I wasnāt going to make it public - thereās a lot of mistake in it and some formatting that needs to be done yet.
Is there way to make it available only by a link rather than an open slather sort of a thing?
Problem with the Free Plan is if you require sign in, then youāll be limited to 10 users.
Perhaps thatās okay while you are still testing?
Although the way you have it setup now nobody can sign in unless you explicitly allow them to.
Iām not sure what your settings are, but Iād guess you probably have it limited to Users in the User table.
Once you are ready to open it up, then you should make it Public with no sign in. Then anyone will be able to view your App with no restrictions on numbers.
1 Like
I broke itā¦
All my data is still in the spread sheets. But when I go into layout - this is all I getā¦
I think I deleted a spreadsheet called category that had three blank entries in it.
Anyone have a clue as to what I did? and more importantly, what I can do to get it all back?
The app doesnāt show any content for me, but what does you User Profile screen or Admins table have to do with Categories?
1 Like
Yes, Itās blank in layout at my end too. Somehow Iāve deleted something crucial that has done this. The Admins and Catagory spreadsheets seemed to have been Glide generated when I set up the app. When I had the app working, I decided to clean up the app a bit, and opened categories to see what it was. It was a spreadsheet with Category 1,2 and 3 on different lines. I deleted it and with it, the app layout. I still have all three spreadsheets (plus admin) - just no visible app.
I am now assuming that the category spreadsheet was some sort of internal structure and deleting it has stopped the app from displayingā¦
I guess I would check your Category tab and see how the components are configured. What table is the tab sources from? What components do you have on that screen, and if there is a collection, what is its source?
I just closed the app and reopened it realising that I hadnāt done the simple and basic, turn it off, turn it on again reset.
Surprisingly - it worked. I should have though of that sooner. I have full functionality on it again. 
BUT - weirdly I now have an empty spreadsheet called cynical-sand that is blank. Is my app possessed? 
Delete the table if you donāt need it. Guessing you added it at some point. All new tables get random names before you rename them.
By the way, Iām still not seeing anything in your app on my end. Check for any filters or visibility conditions that may be making it visible to signed in users only or only your specific user.
Could you see it in the past?
I did change all the settings hoping that you could see it.
Ill have a look now.
No, I still see the same thing that I shared in my screenshot earlier. Iām in the app, but the screen is blank. Your privacy settings are fine, but you need to check the tab screen and component visibility and filter settings.
Sorry, Im going to need some direction on all that. Im not advanced enough to know what all that is yetā¦ 
Ill look through the Glide videos and see what I can find to help.
Any thoughts on what and how the cynical-sand spreadsheet might be?
At some point you created a new table and that was the default name. Itās always a random name.
Thanks for this - So I can delete the cynical sand table without having to do a complete rebuild.
Just trying to set the privacy and visibility now.
Fixed lots of issues - but not the spelling yet!
Does this link work?