AnsweredAssumed Answered

Set up a Lookup for a value in a related module

Question asked by john mckenzie on Mar 14, 2018
Latest reply on Mar 22, 2018 by john mckenzie

Hi All,

I've created two custom modules:

CE Contacts, CE Post Codes.

 

I'm trying to write a calculated formula for a checkbox field in the CE Contacts that looks at the post code within the CE contacts module and then looks for a record that equals it within the CE postcode module.

 

I thought is was a simple formula:

equal($ce_postcode_uppercase,related($ce01_ce_post_codes_ce01_ce_contacts,"name"))

 

I can't get this to work - anybody any ideas?

 

Using Sugar (version 7.8.2.2) Pro on demand 

 

Kind regards John

Outcomes