Hi, I am using appsheet for recording daily quantum of work done of my construction projects.
Each project has certain, not common across projects, number of activities.
e.g. plaster & tiling repair in one project and painting & cleaning on another project.
how should i now organise the table so that the form fields for project A will be
plaster repair: ___ m²
tiling repair: ___ m²
and project B will have
painting: ___ m²
cleaning: ___ m²
Thanks
Hi Mayank
We’ve done a number of construction Apps
So I’d set it out like this
Job Table
[Name]
[Address]
[Job Notes]
[Work Done Table]
[Job] = Key
[Type of Work] = ENUM (Plastering/Tiling/Painting/Cleaning)
[Area of work completed] = NUMBER
But connect with me if you need any advice
These might help you see what Appsheet can do - https://1minmanager.com/case-studies/
Thanks Simon.
Each project has more than 1 work so some have 2 and some have 5. In total there can be 19-20 types of different works. So, is there a way that I can control the number of fields that show based on the number of works specified in the Job Table?
Work Done is a subtable so you can link as many of those records to one Job table as you like
Explain a bit more what you mean by “control the number of fields that show based on the number of works specified in the Job Table”. Give me an example of why you’d do this
Each project will have different works that need to be finished e.g.
Project A
-Wall Painting
-Floor Coating type w
Project B
-Floor Coating type x
-Floor Coating type y
-Floor Coating type z
Notice, how each project has more/less number of works compared to the other project. Also, these works are a standard service that we offer so “Floor coating type x” is a complete service in itself. What does this mean: Each service entails a different billable price hence the differentiation.
I want only those fields to show on a specific project’s view, which relate to that project’s services in order to make it idiot proof. I mean if we are to alternately to show all possible services on every project’s page and expect the foreman to fill out the m² finished only of the relevant services, it will have a possibility of a stray entry into a service that doesn’t belong to that project.
How am I achieving this now: I had a Jobs table listing all projects with a dedicated column to each service while marking Y or N depending on whether services are required for that project or not
Then on the other table where I will record the daily report, I will have same number of columns as the Jobs table. A field will showif the corresponding column in the Jobs table has Y in the project name row. e.g. in Mockingbird Expo Center, column UR150 has a Y then the field in the Daily Report form view marked UR150 will show otherwise it will not.
Let me know if I can make it clearer.
Thanks in advance.
So one suggestion would be to set up a ENUMLIST column at the Job table called [Project WorkType]. With all the 20 different options. Then in the Work Done table have the [Type of Work] column set at an ENUM with an initial value of [Job].[Project WorkType].
So you’d set the allowed project work types in the Job table. Say 5 items out of 20. Then in the Work Done table, you’d only have the option of choose one of those 5.
Hope this helps
1 Like
Sounds great!
Will try it out and come back if there’s a problem.
Thanks a ton!
1 Like