I wasn’t sure if this should go into the ‘Showcase’ section but as it is far from complete I felt it better here - feel free to move it if necessary.
Anyway, I am currently building a prototype app which will consist of one part of the finished article- my plan is to a) ensure I can do what I want to within the app via Glide and b) send my app out to a few friends to play around with and offer me feedback. Once that is sorted I will then build the app in its entirety.
However, I have come across a couple of questions regarding what I want and can’t quite get to meet my plans for my app. Basically the app is a data and logging app for trainspotters in the UK - we all need a hobby after all and I decided to head down this route for myself because I have yet to find a similar app that covers everything I will be covering - other apps out there do parts meaning I have to have a number of apps to get everything I want.
The link to my app is here - https://5t2w1.glideapp.io (go easy on me as this is my first ever attempt at this).
So onto my questions…
On the front page there is a basic table which basically shows the number of units the user has ticked off as sighted, photographed or travelled on. I would also like a column that shows the ‘Total’ number of units but I can only see that you can add rows to the table and not an extra column - would adding a 3rd column be possible? If not is it possible within Google Sheets for me to show the number as 20/87 (20 units seen out of a possible 87) as an example, and still maintain the ability to have the first part of the fraction increase or decrease based selections made within the app?
Once we enter the ‘Fleet Detail’ button we will see the list of unit numbers (under the page title of ‘Home’) which I have used a checklist format for. This checklist currently relates to the ‘Sighted’ switch within each unit number - if the ‘Sighted’ switch is set to true then the checklist is ticked which is great but I would also like to show if the ‘Photographed’ and ‘Haulage’ switches have been checked next to the unit numbers - is it possible to have more than one checkbox there and also can the checkboxes be made so they can’t be edited and only reflect which way the relevant switches are set?
We now move to within the individual unit numbers where I have set multiple components - some of which is strictly data and some of which - the switches - which are user operated. The first sticking point (and possibly a key one) relates to the section I have titled “Travelled in…” and using the 350101 screen as an example you will see that the numbers in this section relate to the ‘formation’ information further up. This data is different for each unit and therefore I need the numbers in the “Travelled in…” section to relate to that unit’s formation but when I change the label in one screen, it changes the label in them all. Is there a workaround for this?
My penultimate question keeps us within the unit numbers and relates to the ‘Notes’ section. You can see an example of inputted notes on the 350101 screen but I would prefer the notes to be in a list format instead of clumped together as they appear now. Is that possible?
Also, on the topic of notes, is it possible for me to have 2 separate note sections - one that I can amend but no other users can and another that the user can amend for themselves. Is this possible?
- And you will be pleased to know this is the final question and relates to the “Amendments” button towards the bottom of the units page. This is basically a similar issue to that of Q3 - in this case, when I click on the ‘Amendments’ button I would only want to see amendments for that particular unit but at the moment it brings up amendments for all units - sorry to keep repeating this but is this possible? This one is not a major issue if it isn’t possible as you will see I have already implemented a backup option below the ‘Amendments’ button - I just thought too much on one screen would look a bit clustered so a button leading off to a new screen would tidy things up somewhat.
And that’s all folks - really sorry for throwing all of these out in one go but I thought it better to do it this way rather than post in dribs and drabs. If it is a problem how I have done it then feel free to shout at me and let me know the better way - as I say I am very new to this world!
I have spent the last couple of days trying to find solutions to these problems for myself - I’m not the sort to simply try and get others to find the answers for me, I prefer to learn and solve so feel free to just prod me in the right directions if you prefer
If you have made it this far, thanks for reading and thanks in advance to anyone who can assist.