How to get value of a Relate field for use in calculate field

I believe that the target module is either RLI or QLI, right? That said, you can create an Extended Vardefs on that target module in order to add another field map into the populate_list in the field product_template_name. Take a look at modules/Products/vardefs.php for reference.

Hi Andre'
the modules in my example are a Custom module, with a Relate type field added via Studio to select the Product catalogue module.

The issue is regardless of module, but to do with the Relate type field itself not being available to select within Sugar logic / calculated fields.

Thanks for any other ideas

Unfortunately regular Related type field added via Studio doesn't support the attribute 'populate_list' as well as related field selection within sugarLogic/calculated fields. You may consider replacing it with a real relationship 1:M instead.

Unfortunately regular Related type field added via Studio doesn't support the attribute 'populate_list' as well as related field selection within sugarLogic/calculated fields. You may consider replacing it with a real relationship 1:M instead.

I realise can use standard 1:M relationship, but wanted to avoid subpanel at product catalogue level, and Sugar has no method yet to hide subpanels at module view level as you know it's all or nothing .

After creating a real 1:M relationship you can easily remove the custom field auto built by Studio which defines the subpanel (custom/Extension/modules/<Module>/Ext/clients/base/layouts/subpanels/<somefile>.php)

Hi Tony,

You can also hide the Subpanel in SugarCRM through custom code by referring this link.

Thanks and Best Regards,

PK,

www.bhea.com