Am running into trouble with conditional formatting in Record View. And I think it's because what I want to do isn't possible in Record View and I should add some kind of status to the Form itself which automatically updates with some code.
I want to to see:
If most recent customer order > 3 months old, conditional format red, and colour all previous green.
E.g. Today's date = 01/09/2020
John Smith - 01/01/2020 - Green
John Smith - 01/02/2020 - Green
John Smith - 01/03/2020 - Green
John Smith - 01/04/2020 - Red
If most recent customer order < 3 months old, conditional format green, and colour all previous green.
E.g. Today's date = 01/09/2020
John Smith - 01/01/2020 - Green
John Smith - 01/02/2020 - Green
John Smith - 01/03/2020 - Green
John Smith - 01/08/2020 - Green
I don't see how this is possible.
Could I add a status field and some code to the customer order form that says:
If date on this order form is more recent than any of this customer's other orders, input status 'current' & input status of all previous orders 'previous'.
And if so, could someone help me with the code please?