Using SugarCRM Professional, v7.2.2.1
I have two custom modules and am trying to populate fields on the first module (KGSProject) when I relate a record of the second module (DeploymentSurveys). Using the built-in formula builder in Module Builder, I create a calculated field on KGSProject field like so (formula created through prompts, not hand-typed):
However, when I relate a DeploymentSurvey to a KGSProject, the calculated field does not populate and remains blank.
I've tried saving and resaving, redeploying the modules, even executing a Mass Update and Recalculate Values on the KGSProjects Module list. I can't seem to get the field on KGSProjects to populate from the related field on DeploymentSurveys. The related field on the related DeploymentSurvey is definitely populated with text, it's not blank and should be returning a Submitter's Name on KGSProjects.
Is there something I am missing? It seems like this should be very straightforward, but it's not producing results.
Regards,
Stephen
