SugarBPM: add relation between two records

Hello Mirco and greetings to Opensymbol colleagues,

Let me clarify the use case please

There is the relationship between Opps and Campaigns in OOTB metadata (see screenshot below)


Please confirm the task is to relate the particular Opportunity to Campaign as soon as the Opportunity Lead Source value is set from dropdown, correct?

Hi Dmytro, thank you for your answer.

Here below you can find and example of an opportunity; I want to be sure that if I choose a particular lead source (dropdown menu) the system will apply the correct campaign.

So,

if Campaign = Google --> lead source = Google

if Campaign = AutoAffariStore.it 2018 --> lead source = AutoAffariStore.it

and so on..

Let me know if it is clear  

Hi Dmytro, thank you for your answer.

Here below you can find and example of an opportunity; I want to be sure that if I choose a particular lead source (dropdown menu) the system will apply the correct campaign.

So,

if Campaign = Google --> lead source = Google

if Campaign = AutoAffariStore.it 2018 --> lead source = AutoAffariStore.it

and so on..

Let me know if it is clear  

Yes, definitely you can not handle/update related fields through SugarBPM, so you may have 2 options:

1. To implement such a feature in a sugarLogic formula by a nesting "ifElse", which may introduce maintenance cost.

2. To configure a Process Business Rules which returns the id for each campaign based on value of lead_source field, then you update a custom varchar(36) field with return from Business Rule, and finally you setup a Dependency SetValue in that new custom field and send its value to campaign_id.

Regards