Ghost repeat records being written even though relevant condition not met
Having an issue with my survey and not sure what exactly is going on. Most of the community responses I see on this issue are from half a decade ago, so not sure if they're relevant.
The issue: Nested repeat is writing to table even though relevant condition is not met.
The nested repeat is (Photopoints) layer, where there's point geometry and an attachment. The entire repeat is set to relevant by a yes/no question NeedPhotos. NeedPhotos has a calculation, so that if another question (PositiveImpact_YN_ = 'Yes') it sets to 'Yes', thereby necessitating photos. Fairly simple. Yet it's pushing ghost records to the photo table with no geometry. There are calculations that automatically pull in values from other layers, but if the whole repeat is hidden via relevant shouldn't that silence them?
xlsx is attached.
What gives?
