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

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


      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