I have tables assessor, buildings, rooms, de...

(Alexander Muir) #1

I have tables assessor, buildings, rooms, defects and want to create a dashboard that will interact between the assessor and the 3 tables e.g. I want to be able to select on the assessor and filter the buildings, rooms in the buildings and the works required.

I can only get interactions between the assessor and the buildings. How do I filter the rooms and the works so they are shown in the dashboard and filter when the assessor is selected?

(Aleksi Alkio) #2

You need to create relationship between the assessor and rooms (defects). You probably have it only between assessor and building.

(Alexander Muir) #3

@Aleksi_Alkio No I have relationships between the assessor and building, assessor and rooms and assessor and defects.

e.g.

assessor

->Assessor ID (3 Virtual Columns) ref_rows(“Buildings”, “Inspector ID”)

List ref_rows(“Rooms”, “Inspector ID”)

List ref_rows(Defects, “Inspector ID”)

List

Then 1 Virtual column for each table

Buildings

=[Inspector ID]

Text Rooms

=[Inspector ID]

Text Defects

=[Inspector ID]

Text

When I test the REF_Rows, the correct answers appear. But only the buildings table works in the dashboard.

(Aleksi Alkio) #4

May I ask what is the app name and account ID and if it’s okay to check your app?

(Alexander Muir) #5

@Aleksi_Alkio Sure it is the Buildings Dashboard and account is 350562

(Aleksi Alkio) #6

Your ref columns “Inspector ID” are hidden and then they won’t work. Remove hidden option and the Dashboar view will work.

(Alexander Muir) #7

It works thank you very much. I thought it might have been something simple.

(Aleksi Alkio) #8

You’re welcome