Expand my Community achievements bar.

Due Date +1 (Requested due date & flexible due date)

Avatar

Level 1

Hello from a Workfront newbie. This is my first post to the Community, so I hope I'm asking this question correctly. I’m new to using/setting up WorkFront, but I’m hoping someone can help me with this.

 

We have a custom form that our requesters fill out to submit creative requests for our designers. We ask them for their due date of the project. Knowing that dates are “flexible” on some projects we also ask them if they have a “latest possible due date” (like an absolute drop-dead date) which would not be the same date as their requested due date. (it would be at least +1 day from that requested date) They can choose whatever this "flexible" date can be, but it has to be at least 1 day greater than the original requested date that they picked.

 

Is there a way that I can have a field that will automatically push out by 1 or more days from that original requested date? 

 

If someone has any suggestions, and could provide me with step-by-step instructions, I would greatly appreciate it!

2 Replies

Avatar

Level 7

If you always want this Flexible date to be automatic to +1 day to the requested date, you can use Calculated field on your custom form with below simple expression.

 

ADDDAYS({DE:Requested date},1)
 
Note that you wont be able to edit this new calculated field, it will only be read only.
 

 

Srinija_N_0-1764754083411.png

 

Avatar

Level 4

Hi @DELHB ,

If you need the date to be editable, you could add a validation rule to the field that would check that the flexible date is at least +1 from the requested date.  (So it wouldn't give the user a default of +1, but at least it would prompt them to enter a date that was at least +1.)

 

Here are some articles:

Add Logic Rules to Custom Forms and Fields | Adobe Workfront   (scroll to bottom for validation logic)

 

Examples of Advanced Logic in Custom Forms | Adobe Workfront

(**This one has a date validation example)