T
TheTruePhoenix
Hi all,
I've made a form with a "risk matrix" which has a tick box for each
cross reference (I'll explain it better below). What I want to know is
if it is possible to update three (3) different fields by clicking on
this single tick box (as in code wise, etc).
The full story is I have three fields (Impact, Likelihood, Risk) and I
want it to automatically populate these fields bases on which tick box
they press on. The "risk" is worked out based on the "impact" (1-5) vs
the "likelihood" (A-E) which makes the risk, depending which tick box
was pressed, Low, Medium, High, or Extreme.
Is there anyway to automate this so the risk matrix isn't just a
graphic reminding them what to put in the fields?
On a less note is there a way to change the background of a form (just
for th record with this data) based on the data in a field (it's a
field with the options, "normal" or "high") as I want the background to
go red for a high priority?
I've made a form with a "risk matrix" which has a tick box for each
cross reference (I'll explain it better below). What I want to know is
if it is possible to update three (3) different fields by clicking on
this single tick box (as in code wise, etc).
The full story is I have three fields (Impact, Likelihood, Risk) and I
want it to automatically populate these fields bases on which tick box
they press on. The "risk" is worked out based on the "impact" (1-5) vs
the "likelihood" (A-E) which makes the risk, depending which tick box
was pressed, Low, Medium, High, or Extreme.
Is there anyway to automate this so the risk matrix isn't just a
graphic reminding them what to put in the fields?
On a less note is there a way to change the background of a form (just
for th record with this data) based on the data in a field (it's a
field with the options, "normal" or "high") as I want the background to
go red for a high priority?