Can a security filter rule depend on a virtual column in the table its referencing or do all the columns need to be in the spreadsheet?
I have 2 tables.
Job is the main table and Photos is the sub-table.
The security filter I use at the moment is
The issue I’ve realised is that Photos[JobStatus] uses a formula of [Job].[Status].
But if there are multiple photos Row then changing Job[Status] does not update the Photos[JobStatus]
So would a VC work?