6 Replies Latest reply on Feb 18, 2017 4:50 AM by siplus

    Starting a new section to a Solution, need help getting started.

    xxx202xxx

      The Issue:

      On my Service MGMT Table I have a field called Service::Priority where the user inputs manually a value between 1 - 4 for each ticket created.  Now I am attempting to automate this process to leave the guess work out of the users hands sort-a-speak.  Users will still need to pick from the Urgency table and the Impact table (see below) but the join table will need the calculations done up.

       

       

      New Tables I have come up with but need help doing the calculations for the 3rd table.

       

      UrgencyProject LocationImpactIssue Impact
      1North1No DataUrgency1234
      2South2degraded service11124
      3East3HW/SW Issue21224
      4West4Non-Customer
        affecting
      32334
      44444