These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Auto fill series in PDF forms

Forum Index > Forms: Acrobat > Auto fill series in PDF forms
2009-05-23 20:15:33
mraheelgujjar
Registered: May 23 2009
Posts: 17
Answered

Hi,
I have a form, at the top of which i write a date. below that are 14 cells. I want to achieve is that as soon as i enter the date at the top of the form, the cells get auto filled by previous two weeks dates e.g

i enter 25-05-09
and the cells below get automatically filled with..

12-05-09
13-05-09
14-05-09
.
.
.
.
.
25-05-09

Thanks for ur help...

My Product Information:
Acrobat Standard 9.1.1, Windows
Top
2009-05-24 09:00:12
#1
gkaiseril
Online
Expert
Registered: Feb 23 2006
Posts: 4307
In FormCalc you can use the "Date2Num()" function to convert your inputted number to the number of days since the Epoch date, base date used for LiveCycle Designer's date calculations. You can then subtract the necessary days to this value to obtain the day number for each of your previous 14 days. Once you obtain this number, you can use "Num2Date()" function to populate the various date fields with the date string as you want it formatted. Using this script in the "Exit" event for the inputted date field will let you perform all the calculations at one time and you can use a control loop to compute each day and depending upon how you name your fields, you can even calculate the field name based on the control loop's counter.

George Kaiser

Top
2009-05-25 00:20:30
#2
ranmori
Registered: May 24 2009
Posts: 4
Thank you again for your reply and information ^^
[url=http://simulationcreditauto.net/][color=#DEDFDF][u]simulation credit auto[/u][/color][/url]
Top
2009-07-05 17:59:42
#3
manola
Registered: Jul 5 2009
Posts: 1
I'm looking forward to those weekends!
[url=http://sonneriegratuite.org][color=#DEDFDF][u]sonnerie portable gratuite[/u][/color][/url]
Top