cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

C4C UI Rule Editor - IF/AND/THEN

0 Likes
996

Dear Experts,

I am struggling with defining the correct UI Rule condition for following scenario:

IF Root.EndTimePoint < TODAY AND Root.LifeCycleStatusCode = Open THEN Root.EndTimePoint should be the color BAD_DARK if the criteria don't match then GOOD_DARK

I managed to set up the IF rule without taking the status into consideration but it's quite irritating to have quotes marked as overdue if they are closed.

Is it possible to set this up?

Your help is highly appreciated!

Kind regards,

Kerstin

Accepted Solutions (1)

Accepted Solutions (1)

former_member438195
Participant

Hello Kerstin,

Based on this conditions IF Root.EndTimePoint < TODAY AND Root.LifeCycleStatusCode = Open THEN Root.EndTimePoint should be the color BAD_DARK if the criteria don't match then GOOD_DARK


The following rule will attend it:

IF(AND(Root.EndTimePoint < TODAY(),Root.LifeCycleStatusCode == 1),'BAD_DARK','GOOD_DARK')

In case of any issue or further clarification is required, please let me know.

BR,

Vandré

Hello Vandré,

Thank you very much for your quick help - that's exactly what I was looking for!

Have a great day.

Kind regards,

Kerstin

Answers (0)