Survey123 Inbox text to chg color per condition

Idea created by WILLIAM51 on Jun 28, 2019
    New
    Score20
    • WILLIAM51
    • dthompson299

    When using an inbox query like:

    UserAssigned=${username} AND InsStatus='InProgress' OR InsStatus='FieldComplete' OR InsStatus='WaitingOnRepair'

    I'd like the 'WaitingOnRepair' to change to color orange when the 'Proposed Repair Correction Date' gets within 14 days & red when the date is passed.