Customer Engagement & Dynamics CRM Forum

Expand all | Collapse all

Update Field Based on Multiple Inputs

  • 1.  Update Field Based on Multiple Inputs

    SILVER CONTRIBUTOR
    Posted Jul 12, 2019 05:36 PM
    I have an entity (Premium) that is used to calculate an insured's premium based on multiple fields - territory, coverage type, deductible amount, etc.  I can create an entity to store the rates based on the various scenarios but I'm not sure how to update the premium amount based on multiple inputs.  Ideally, I'd like to be able to update the Premium entity with the territory, coverage type, etc. fields and a process/function selects and updates the correct premium from the rate entity.  Can anyone recommend an OOB way to do this or an add-in?  Thank you!

    ------------------------------
    Johnny Bolton
    Project Manager
    State Volunteer Mutual Insurance Company (SVMIC)
    Brentwood TN
    ------------------------------
    Conference-CRMUG_200x200


  • 2.  RE: Update Field Based on Multiple Inputs

    Posted Jul 14, 2019 06:56 PM
    Hi Johnny,

    1. Is the amount on the rates being determined based on a formula? E.g. amount/multiplier based on the selected parameters such as territory, coverage type, etc. If yes, then does the parameters store the amount/multiplier? If yes then you may be able to use calculated field on both the rates and premium entity if they also store the parameters. E.g. the rate/premium could be 150 (as base amount) * territory.multiplier + coverageType.amount.
    See here for more details. Look at the Note section in this section.

    2. If none of the above applies and the rate entity simply stores the parameters and a final amount determined externally, and you are looking for a function to match the parameters on a premium to a rate record with the same parameters and return/update the amount, then you will probably need a custom workflow/plugin/javascript for that.

    Hope that helps.

    ------------------------------
    Jacky Chen
    Consultant
    Chamonix IT Solutions
    Adelaide
    ------------------------------

    Conference-CRMUG_200x200


  • 3.  RE: Update Field Based on Multiple Inputs

    SILVER CONTRIBUTOR
    Posted Jul 15, 2019 08:38 AM
    ​Another option is to create a Business Rule in a form. More details can refer to page: Create business rules and recommendations to apply logic in a form.

    Hope that helps.
    Junbin Duan

    ------------------------------
    Junbin Duan
    Senior Application Developer
    National Research Council Canada
    Ottawa ON
    ------------------------------

    Conference-CRMUG_200x200


  • 4.  RE: Update Field Based on Multiple Inputs

    Posted Jul 15, 2019 04:14 AM

    I would recommend having a look at NORTH52's Add-in


    they even have a (very basic) example on their web site about calculating premiums using decision tables and inputs from multiple sources.


    They are very helpful and will go online to discuss things with you if needed.

    Paul Smith
    Business Systems & Integration Analyst
    SSAFA, the Armed Forces charity. Queen Elizabeth House, 4 St Dunstan's Hill, London. EC3R 8AD
    T: 
    +44 20 7463 9363
    E: 
    Paul.Smith@ssafa.org.uk
    W: 
    www.ssafa.org.uk
    The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this e-mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Registered Charity No. 210760 Est. 1885. Registered charity in England and Wales No. 210760, in Scotland No. SCO38056 and in Republic of Ireland No. 20006082. Est. 1885.



    Conference-CRMUG_200x200


  • 5.  RE: Update Field Based on Multiple Inputs

    SILVER CONTRIBUTOR
    Posted Jul 15, 2019 09:12 AM
    Thank you Jacky, Junbin and Paul!  This is a decision table scenario because all of the parameters are independent so I think there are too many possibilities to handle it with a workflow, roll up field or business rule.  I will check out the North52 add-in - it sounds like the best possible solution for now. Thanks again!

    ------------------------------
    Johnny Bolton
    Project Manager
    State Volunteer Mutual Insurance Company (SVMIC)
    Brentwood TN
    ------------------------------

    Conference-CRMUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role