End Date=CASE WHEN ({custbody_leadtime} IS '2-4 We...
# generala
Alex Smith
03/09/2022, 3:42 PMEnd Date=CASE WHEN ({custbody_leadtime} IS '2-4 Weeks' THEN {enddate} IS to_date({trandate}) + 28 END ELSE CASE WHEN {custbody_leadtime} IS '4-6 Weeks' THEN {enddate} IS to_date({trandate}) + 42 END ELSE CASE WHEN {custbody_leadtime} IS '8-10 Weeks' THEN {enddate} IS to_date({trandate}) + 70 END ELSE CASE WHEN {custbody_leadtime} IS '10-12 Weeks' THEN {enddate} IS to_date({trandate}) + 74 END ELSE WHEN {custbody_leadtime} IS '12-14 Weeks' THEN {enddate} IS to_date({trandate}) + 74 END
a
AI1
03/09/2022, 4:01 PMIs this the formula that was the solution? Or are you saying this is still not working? If not working what error are you getting?
a
Alex Smith
03/09/2022, 4:02 PMIt's still not working. the error i get is
Alex Smith
03/09/2022, 4:03 PM"
You have entered an Invalid Field Value ERROR: Invalid Expression for the following field: enddate"
a
AI1
03/09/2022, 4:05 PMToo many commands in there.
Try this:
CASE WHEN {custbody_leadtime} = '2-4 Weeks' THEN {trandate} + 28 WHEN {custbody_leadtime} = '4-6 Weeks' THEN {trandate} + 42 WHEN.....etc (then after the last clause put END
a
Alex Smith
03/09/2022, 4:06 PMlet me try that
Alex Smith
03/09/2022, 4:06 PMi think i did try that at first and it still spit out that error message
a
AI1
03/09/2022, 4:11 PMYou'll probably get a date format error, (which I have a work around for), but let's get the formula wokring first
a
Alex Smith
03/09/2022, 4:14 PMok wow it worked!
Alex Smith
03/09/2022, 4:14 PMNOW the issue is I'd like to get it to work "after field edit" (i only got it to work "after record submit")
Alex Smith
03/09/2022, 4:14 PMbut when i change it to after field edit i have to change the client triggers and i have zero idea which one(s) to choose
Alex Smith
03/09/2022, 4:15 PMlol
a
AI1
03/09/2022, 4:22 PMWhy wouldn't you just use all of them? Is there a reason to not use some?
a
Alex Smith
03/09/2022, 4:23 PMoh i dont know
Alex Smith
03/09/2022, 4:23 PMlet me try selecting all
Alex Smith
03/09/2022, 4:25 PMhm its definitely not updating after field edit
a
AI1
03/09/2022, 4:40 PMWhat's your triggering client field?
a
Alex Smith
03/09/2022, 5:51 PMi selected all of them?
a
AI1
03/09/2022, 7:18 PMSet this field to your custom body Lead Time field so whenever anyone changes the lead time, it recalculates
a
Alex Smith
03/10/2022, 1:33 PMi tried that but everything just glitches on the screen when i try
a
AI1
03/11/2022, 1:33 AMSo are you taking the End Date field, then adding the lead time to it, then resetting the end date field with the new value? If so it will just be a continuos loop of updating. You should have it update a different End Date field, then after record submit copy that field to the regular end date field?
AI1
03/11/2022, 1:33 AMSomething must be a never ending loop of calculations that would cause that glitching...
7 Views