Format rule question. App with two tables: r...

(Tammi Canelli) #1

Format rule question.

App with two tables: registry is main table,

check in table has ref to registry.

Is there any way to create format rules for the check in table based on data in registry without adding those columns to my check in table?

An example would be someone who has a medical device requiring electricity I would like to add an icon on table view next to name so when they check in it’s easily identified.

Trying to keep the check in fields to a min for rapid checking so I don’t want all the registry fields referenced in this table.

Hope that makes sense.


(Jesse Prud'Homme) #2

You might want to try using something like this as your formatting rule:

IF(ANY(SELECT(Registry Table[Medical Device Column],[Registry Key Column]=[_THISROW].[Registry Ref Column]))=“Requires Electricity”, TRUE, FALSE)

(Aleksi Alkio) #3

Because you have the ref field on your table structure, you can call the value with the deref expression… like [Registery ID].[MedicalDevice]=“Required Electricity”.

(Tammi Canelli) #4

So the expression verifies but it still wont format the name in the check in table view.

(Jesse Prud'Homme) #5

Try testing the expression in the edit (click test instead of verify) to see if they all come up as “N”