We want to create a custom field RAG_STATUS on the Supplier Info header screen.
if Insurance Renewal Request = ‘YES’ THEN RAG_STATUS = ‘GREEN’
If Insurance Renew Requested = ‘NO’ and Insurance Renewal Date has not expired but is >= TODAY’S DATE -30 DAYS then RAG_STATUS = ‘AMBER’
If Insurance Renewal Date has expired then RANG_STATUS = ‘RED’
Finally, if possible we would like the field to highlight the RAG_STATUS field in the colour of the RAG_STATUS answer.
Probably achieving the above via a custom event.
Any ideas on how I can achieve this.
