I’m a Coda novice and could use some help here. How could I make a lookup column change values based on checkboxes in another table?
I’m tracking the progress of visual effects on a TV show. I have 2 main tables: 1) [VFX List] where I create an ID for each VFX shot in the show, and 2) [VFX Received] where I track every version that comes in for every shot. Below are simplified views of these tables. In the example below, [VFX List].[Status] is looking up values from a table called [VFX Status]. Also, [VFX Received].[VFX ID] is looking up from [VFX List].
I’ve been unsuccessful in my attempts to create a formula for [VFX List].[Status] along these lines…
When [VFX Received].[VFX ID] is equal to this row and [VFX Received].[Approved] is checked, then switch [Status] to "Approved."
Ideally this formula ignores multiple versions of shots and will return a result when any matching ID yields Approved=true.
Hope I’m making sense. Thank you for the help!