I am new to Airtable but have spent time using Access, etc. I am creating a Project Tracker that identified Tasks per Project. I then want to capture the costs associated with some of the Tasks. Example…
Project: Renovate Entryway
Task(s):
- Remove Existing Flooring
- Install New LVP Flooring
Underlayment 500 Square Feet $0.45/Square Foot $225.00
Luxury Vinyl Plank ABC 500 Square Feet $1.65/Square Foot $825.00
- Paint Area
I have created the Project Tracker Base, Project Table, Task Table and Materials Table. I can expand the the Project to see the Tasks. I can also expand the Task to see the Materials. How do I setup the views to see the information as I have illustrated above?
Thanks