Hi,
Under Oracle APEX 24.2.15, I am struggling with a calculation in a DA with Javascript expression (until now I coud not succeed). I want to set the value of the element P7_PRORITE_CONTACT upon the value of the two elements P7_ROLE and P7_RELATION, when element P7_RELATION is modified.
The calculation is:
IF P7_ROLE = "Décideur" AND P7_RELATION = "Chaud" Then P7_PRIORITE_CONTACT = "Haute"
IF P7_ROLE = "Décideur" AND P7_RELATION = "Tiède"Then P7_PRIORITE_CONTACT = "Haute"
IF P7_ROLE = "Prescripteur" AND P7_RELATION = "Chaud" Then P7_PRIORITE_CONTACT = "Haute"
IF P7_ROLE = "Froid" Then P7_RELATION = "Basse"
ELSE P7_RELATION = "Moyenne".
If someone could help me, it would be welcome.
Best regards.