Change border colour of Text field based on Date Field - Calculated Field | Community
Skip to main content
Missile64
Missile64
New Participant
November 21, 2022
Solved

Change border colour of Text field based on Date Field - Calculated Field

  • November 21, 2022
  • 2 replies
  • 723 views

I have a list of documents that require periodic reviews. I would like to have a Calculated field that adds a Red border on the Title field when the Review Date field is =< Today, and Amber if the Review Date field is Today -1 Month.

JS is not allowed hence the need for a Calculated field.

Title - Text Filed Review Date - Date Field Todays Date 21-11-2022
Document 1 25-10-2022 Red border because it is past Review Date
Document 2 12-12-2022 Amber border because it is within 1 month of Review Date
Document 3 20-02-2023 Nothing as it is over 1 month from Review Date

 

Thanks in advance
Pete

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Vijay_Katoch

You can achieve this by putting javascript something like below in the calculate event of the field whose border color need to change:

 

if(CallFunctionToCompareDateWhichReturnTrueOrFalse(putCurrentDate,DateofYourField)){
this.border.edge.color.value="255,0,0";
}else{
this.border.edge.color.value="255,255,0";
}

2 replies

Mayank_Gandhi
Mayank_Gandhi
Employee
November 21, 2022

sample :


xfa.resolveNode("form1.#subform.TextField1").border.edge.color.value="255,0,0"

 

https://help.adobe.com/en_US/livecycle/10.0/DesignerHelp/WS92d06802c76abadbe98a8d5129b8b01f08-7fe2.html

 

@missile64 

    Vijay_Katoch
    Vijay_KatochAccepted solution
    New Participant
    November 21, 2022

    You can achieve this by putting javascript something like below in the calculate event of the field whose border color need to change:

     

    if(CallFunctionToCompareDateWhichReturnTrueOrFalse(putCurrentDate,DateofYourField)){
    this.border.edge.color.value="255,0,0";
    }else{
    this.border.edge.color.value="255,255,0";
    }

      Terms & ConditionsAccessibility statement

      Loading footer...