Discussions

Expand all | Collapse all

Changing field color based on a selection of another field.

  • 1.  Changing field color based on a selection of another field.

    Posted 09-16-2017 01:40

    I wanted to be able to select Critical or Gating on Urgency Level field and depending on what I selected, I want the "[Critical/Gating_Audit_OBC Descriptions]" field text to change color.

    Case([Urgency Level],
    "Critical", "<div style=\"color:black; background-color:Red;\">&[Critical/Gating_Audit_OBC Descriptions]&</div>", 
    "Gating", "<div style=\"background-color:Yellow;\">&[Critical/Gating_Audit_OBC Descriptions]&</div>", "")



  • 2.  RE: Changing field color based on a selection of another field.

    Posted 09-16-2017 16:49
    What is the problem?  Is there a Syntax error?  If so, can you post the error.