Copy link to clipboard
Copied
I am trying to build a time card form fill. One feature I would like to incorporate is when user inputs starting pay period date and ending pay period date the actual date for the corresponding day of the week is populate. I have two fields Starting day and ending day. User will enter (we get paid once every two weeks and our pay periods always begin on a Monday) for starting date 10/31/2016 and an ending date 11/13/2016. I have fields for each week like week1MON, week1TUE, week2MON, week2TUE. Based on the dates the user inputs can I get field week1MON to be automatically filled with 10/31 and week1 TUE to be filled with 11/1 and have this done for a two week period. I know asking a lot.
Copy link to clipboard
Copied
This can be achieved using a script. Basically you would need to convert the date string the user enters into the first field into a Date object and then add 1, 2, 3, etc. days to it, and output it back as a string to the other fields.
If you don't wish to mess around with the code that does it I've developed a tool that allows you to easily set up such calculations.
You can find it here: Custom-made Adobe Scripts: Acrobat -- Apply Automatic Date Calculation
Find more inspiration, events, and resources on the new Adobe Community
Explore Now