I am creating a field in our report view that is a checkbox in our campaign module that determines if our system sends out a survey e-mail. Each campaign can have many appointments associated with it (appointments are always associated with one campaign, so should be many to one). I want the appointment level to show this same value, so created a calculated value that references this checkbox related($campaigns_appointments,"allow_feedback_c")).
The problem is they are not mimicking their value, In a test I check the box on the campaign level the appointment level is blank and not checked.
How do I get this checkbox to correctly have the value calculated per its related view?