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.
Thanks
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)
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โ.
So the expression verifies but it still wont format the name in the check in table view.
Try testing the expression in the edit (click test instead of verify) to see if they all come up as โNโ
User | Count |
---|---|
40 | |
26 | |
22 | |
20 | |
15 |