# Pool service app - work orders and dup-to-date chemical logs
**URL:** https://community.glideapps.com/t/pool-service-app-work-orders-and-dup-to-date-chemical-logs/80908
**Category:** Ask for Help
**Created:** [March 22, 2025, 11:52pm UTC](https://community.glideapps.com/t/pool-service-app-work-orders-and-dup-to-date-chemical-logs/80908 "2025-03-22T23:52:13Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@JohnsonPool](https://community.glideapps.com/u/JohnsonPool)
#### Post date: [March 22, 2025, 11:52pm UTC](https://community.glideapps.com/t/pool-service-app-work-orders-and-dup-to-date-chemical-logs/80908/1 "2025-03-22T23:52:13Z")
I’m just diving in but I’d like to outline my goals from the start so anyone that wants to can give advice.
I run a Pool service/maintenance company with my Father and brother. We have 5 full time guys that would be using the app most. We have 70 commercial locations with unique situations.
So far what I have is a “Pool Info” Tab with a list of the Location names and basic information. I used one table for this. Easy enough.
Next, I want to make another tab for work order management. I don’t really know how to begin there because I don’t already have any excel sheets with data. I want to be able to create a work order that is related to a location (or not) from the “Pool info” table and I want to be able to sort those work orders by various fields; Location, scope of work, due date, start date, current status, etc. I want the work orders to have it’s own tab but I also want to be able to view those work orders for a particular pool in its info page in the “pool info” tab. And I want a button in the pool info tab that takes me to the work order list for that pool. I started trying to figure out that button but I can’t figure out how to make it “go to” another page in the app. closest I got was “go to tab”.
Thirdly, I’d like to incorporate a chemical log somehow. Each pool will have its own chemical log with multiple entries per day. This can be in its own tab but will certainly need to be organized by pool. I’ve experimented with adding the chemical log to the “pool info” details page because I believe the chem log tab will look pretty similar. I’ve added a button on the “pool info” details page but not much luck adding specified data. I can only add pre-populated data.
Thanks in advance for any advice. I’ll follow up here with updates and more specific questions.
---
### Author:  [@JohnsonPool](https://community.glideapps.com/u/JohnsonPool)
#### Post date: [March 22, 2025, 11:55pm UTC](https://community.glideapps.com/t/pool-service-app-work-orders-and-dup-to-date-chemical-logs/80908/2 "2025-03-22T23:55:58Z")
One more thing, I have a File picker component on the “pool info” details page but I’m not sure it is what I want. I want to be able to store documents related to each pool (finished work orders, historical changes, etc.) on that page. Is this the Component I’m looking for? is there a way to access the files once they are uploaded? can I limit who can upload?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [March 23, 2025, 12:22am UTC](https://community.glideapps.com/t/pool-service-app-work-orders-and-dup-to-date-chemical-logs/80908/3 "2025-03-23T00:22:23Z")
> [@JohnsonPool](#):
>
> So far what I have is a “Pool Info” Tab with a list of the Location names and basic information. I used one table for this. Easy enough.
I would use a map layout for something like this.
> [@JohnsonPool](#):
>
> I want the work orders to have it’s own tab but I also want to be able to view those work orders for a particular pool in its info page in the “pool info” tab.
[ ](https://www.youtube.com/watch?v=HwKoIekup00)
Check this out for how to create relations in Glide.
> [@JohnsonPool](#):
>
> And I want a button in the pool info tab that takes me to the work order list for that pool. I started trying to figure out that button but I can’t figure out how to make it “go to” another page in the app. closest I got was “go to tab”.
I think you just need to show the list of orders for a pool inside its details screen.
> [@JohnsonPool](#):
>
> Thirdly, I’d like to incorporate a chemical log somehow. Each pool will have its own chemical log with multiple entries per day. This can be in its own tab but will certainly need to be organized by pool. I’ve experimented with adding the chemical log to the “pool info” details page because I believe the chem log tab will look pretty similar. I’ve added a button on the “pool info” details page but not much luck adding specified data. I can only add pre-populated data.
Have a table for this and create a relation, same process as above, then use a collection to display them.
> [@JohnsonPool](#):
>
> One more thing, I have a File picker component on the “pool info” details page but I’m not sure it is what I want. I want to be able to store documents related to each pool (finished work orders, historical changes, etc.) on that page. Is this the Component I’m looking for? is there a way to access the files once they are uploaded? can I limit who can upload?
Same for this as well, have another table, and use a form with a file picker to upload them, give those files a text entry to have a name as well.
You can limit who can upload, based on fields in their user profiles.
---
### Author:  [@JohnsonPool](https://community.glideapps.com/u/JohnsonPool)
#### Post date: [March 23, 2025, 5:16pm UTC](https://community.glideapps.com/t/pool-service-app-work-orders-and-dup-to-date-chemical-logs/80908/4 "2025-03-23T17:16:56Z")
thanks so much for the reply. I obviously have a lot to learn, as most of what you said is over my head. But I will dive in to the map layout and relations that you’ve mentioned and see what I can come up with. Thank you!
---
### Author:  [@JohnsonPool](https://community.glideapps.com/u/JohnsonPool)
#### Post date: [March 24, 2025, 3:28pm UTC](https://community.glideapps.com/t/pool-service-app-work-orders-and-dup-to-date-chemical-logs/80908/5 "2025-03-24T15:28:57Z")
The File picker seems a little restrictive. In the app, it allows me to upload documents or photos and shows them above the picker after uploading, but the icon is very small and there’s no way to select the document for viewing, downloading. or otherwise. Also, I can only upload one document; trying to add another replaces the original. Is there a function I’m missing or is there another component that would be more like a folder of documents related to each item?
---
### Author:  [@JohnsonPool](https://community.glideapps.com/u/JohnsonPool)
#### Post date: [March 24, 2025, 5:45pm UTC](https://community.glideapps.com/t/pool-service-app-work-orders-and-dup-to-date-chemical-logs/80908/6 "2025-03-24T17:45:32Z")
I’ve started working on the work orders aspect. I opted for a tab dedicated to work orders, but I’m going to put a button on the main list of pools to access the work orders for each pool.
Working on the dedicated tab, I have a collection sourced by a table of all work orders. Clicking into an item opens the details of the work order. Next to the Title, there is an edit button which I would like to be used to edit the work order itself. But It will only let me edit the Title Name only. Same issue when making a dedicated button component, The only option when choosing the data for the action is “This Item” when “show edit screen” interaction is chosen. How do I edit entire the row of data with this button?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 24, 2025, 11:19pm UTC](https://community.glideapps.com/t/pool-service-app-work-orders-and-dup-to-date-chemical-logs/80908/8 "2025-03-24T23:19:02Z")
> [@JohnsonPool](#):
>
> Same issue when making a dedicated button component, The only option when choosing the data for the action is “This Item” when “show edit screen” interaction is chosen. How do I edit entire the row of data with this button?
Add more input components to the Edit Screen.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [March 24, 2025, 11:49pm UTC](https://community.glideapps.com/t/pool-service-app-work-orders-and-dup-to-date-chemical-logs/80908/9 "2025-03-24T23:49:51Z")
> [@JohnsonPool](#):
>
> thanks so much for the reply. I obviously have a lot to learn, as most of what you said is over my head.
You can work through lessons here to get started.
> **[University](https://learn.glideapps.com/)**
> [@JohnsonPool](#):
>
> The File picker seems a little restrictive. In the app, it allows me to upload documents or photos and shows them above the picker after uploading, but the icon is very small and there’s no way to select the document for viewing, downloading. or otherwise.
Well that’s exactly what it is for, a picker.
If you want to view an image after uploading, use an image component.
If you want to show an embed of a PDF, use a web embed.
Otherwise, a links component would do.
> [@JohnsonPool](#):
>
> Also, I can only upload one document; trying to add another replaces the original. Is there a function I’m missing or is there another component that would be more like a folder of documents related to each item?
I assume you don’t want an extra table that would consume more rows. In that case, you add a multiple files column, and point the file picker to that column.