I work for a LED lighting company and we use AppSheet to perform our onsite audits.
Each time someone is going to begin an onside audit they create a new Location.
For every location there are two related tables PreMeeting & LightingAudit. Each table gathers information specifically to that location.
In the LightingAudit table the user enters the counts of each lighting type. It is very common to have multiple lighting types within an area. It is also common to have similar lighting types across different areas. So within the LightingAudit table I have nested two tables: AreaDetails & LightingDetails. This way you only have to enter the general information for an area once and lighting details once. Then as you are performing the audit you can select the area (or create a new one) and a lighting type (or create a new one) and then proceed with counting them. An example below:
My challenge is this. I am wanting the areas created in AreaDetail and the lights entered in the LightingDetail to be filtered in the dropdown to what only relates to the original location. Right now any selection I put in is available in all locations but you may have similar area types (office space) with different details based on the location.
I have tried referencing the AreaDetails & LightingDetails to the Location and also the LightingAudit but I am not having any success. Any suggestions would be greatly appreciated.