You need to sign in to do that
Don't have an account?
S Balaji 8
Can someone help me how to implement the below scenario please?
There are two objects:
1.Order- Order start date and Order object is the child object looking upto Order Detail
2. Order Detail Object-
=====================================
Basically i have a week picklist field in order detail object with different values like 2W,4W,6W,8W.
Use case to be implemented:
1.Week field should be populated as 2W: If Email sent date field is between the Order Start Date, and until 3 Mondays after the Order Start Date
2. Week field should be populated as 4W Between the 2W Monday Date, and 2 Weeks after the 2W Monday Date
For example:
IF order start date is 1st November and if the Email sent date is anywhere between 1st and 21 Nov- Then update week status as 2W.
IF order start date is 1st November and if the email is sent anywhere between 21st Nov and 5th Dec- Then update week status as 4W.
Email sent date is already populated in the order detail object.
1.Order- Order start date and Order object is the child object looking upto Order Detail
2. Order Detail Object-
=====================================
Basically i have a week picklist field in order detail object with different values like 2W,4W,6W,8W.
Use case to be implemented:
1.Week field should be populated as 2W: If Email sent date field is between the Order Start Date, and until 3 Mondays after the Order Start Date
2. Week field should be populated as 4W Between the 2W Monday Date, and 2 Weeks after the 2W Monday Date
For example:
IF order start date is 1st November and if the Email sent date is anywhere between 1st and 21 Nov- Then update week status as 2W.
IF order start date is 1st November and if the email is sent anywhere between 21st Nov and 5th Dec- Then update week status as 4W.
Email sent date is already populated in the order detail object.
S Balaji 8
Can someone help me on this?