Thread Details
  • State Not Answered
  • +1 person also asked this people also asked this
  • Replies 14 replies
  • Subscribers 368 subscribers
  • Views 2329 views
  • Users 0 members are here
Forum Actions

Roll-up RLI Product Category Values to Opportunity Multiselect

Vince Outlaw

We would like a field on our Opportunity record that reflects all of the Product Category values on related Revenue Line Items. For instance, for an Opportunity with 2 Revenue Line Items, if a "WP" Product Category was on 1 Revenue Line Item and "EC" was on the second Revenue Line Item, we would have a field on the Opportunity that reflects both "WP" and "EC" so that we can filter and report on "Opportunities with Product Category "WP", for instance. 

We like the idea of the "RollUp" SugarLogic formulas, but there isn't anything like this for these fields, so we were thinking maybe a SugarBPM process could do this for New Opportunities and whenever the RLI Product Category field was changed. 

Thanks...VO

Parents
  • 0

    What is the purpose on configuring in the Opportunity a custom multiselect whose options are the unique categories related to RLIs? Can you eplain, please?

    Through Reports you should be able to fetch all Categories related to RLIs related to a set of Opportunities, so what is the point?

    Regards

    André Lopes
    Lampada Global
    Skype: andre.lampada
  • 0 in reply to André Lopes

    What is the purpose on configuring in the Opportunity a custom multiselect whose options are the unique categories related to RLIs? Can you eplain [SIC], please? We want to be able to filter Opportunities based on what Product Categories they have in them. 

    Through Reports you should be able to fetch all Categories related to RLIs related to a set of Opportunities, so what is the point? Having them available in List View filters is the point, I believe.

    Thanks for asking and helping! VO

  • 0 in reply to Vince Outlaw

    Thank you for your answers, so the strategy solving that puzzle:

    • Create a dropdown list containing all the available Product Categories. Mind that you will need to update such dropdown list whenever changes are made on Categories module (update, create, delete). We have implemented some logic hooks which update a dropdown list as per changes on a specific module. This may be a good start point for you for maintanance.
    • Create a logic hook before_save on Opportunities which looks for all RLIs related to an Opportunity being created. Fetch the Category for each RLI and populate a custom multi select field accordingly (the one for which you created the Categories dropdown list).

    Good luck!

    André Lopes
    Lampada Global
    Skype: andre.lampada
  • 0 in reply to André Lopes

    Thank you, Andre! I haven't written or deployed a logic hook before, so I will need to get up to speed on that. 

    Is there a reason why SugarBPM is not used for these types of things that are initiated when records are created / editted? I see Logic Hooks brought up a lot more than SugarBPM among those that know the platform, so I'm wondering how decisions are made on what tools to use for customizations. Thanks for any insights. 

  • 0 in reply to Vince Outlaw

    I always try using SugarBPM first so that it can be changed by a non-developer. But it does have some limitations and that is when I choose to use Logic Hooks. Sometimes, more complex SugarBPM processes can be more efficient when written as a Logic Hook but the changes require a developer.

Reply
  • 0 in reply to Vince Outlaw

    I always try using SugarBPM first so that it can be changed by a non-developer. But it does have some limitations and that is when I choose to use Logic Hooks. Sometimes, more complex SugarBPM processes can be more efficient when written as a Logic Hook but the changes require a developer.

Children