Highlighted

Autofill cell with current date

Avatar

Avatar

NL_Erik_G

Avatar

NL_Erik_G

NL_Erik_G

21-11-2008

Hi,



Here is a question about a table containing 2 columns. These are:



Barcodescan - date scan



The purpose of the form is that a user can scan a barcode so that the text of the barcode is put in the first column. Automaticly the next column should be filled with the date (and if possible) time of the scan (This means the data/time of filling the one cell).



The question is how to automaticly have the date-cell fill with the date without having the user to enter in manually.



Any help in MUCH appreciated!



Erik

Replies

Highlighted

Avatar

Avatar

Thomas_McConnac

Avatar

Thomas_McConnac

Thomas_McConnac

21-11-2008

xfa.host.currentDateTime()



Tom
Highlighted

Avatar

Avatar

Thomas_McConnac

Avatar

Thomas_McConnac

Thomas_McConnac

21-11-2008

Not sure about how its used, but know that's the command
Highlighted

Avatar

Avatar

ibwaheemi

Avatar

ibwaheemi

ibwaheemi

27-11-2008

a current date box comes as standard and is found under 'custom'



it puts this formcalc in the form:ready box



// Current Date in short-style date format.



$.rawValue = num2date(date(), DateFmt(1))
Highlighted

Avatar

01-12-2008

Hi Joe,

On the exit event of the "barcode text field", you can set the current date of the other field by (Formcalc)

barcodeDateField.rawValue = Concat(Num2Date(Date(), "MM/DD/YYYY"), " ", Num2Time(Time(), "HH:MM"));



Hope helps

In case of consultancy issues on LiveCycle Designer and LiveCycle ES family, you can contact us.



Asiye Günaydın

Project Consultant

KGC Consulting Co.

www.kgc.com.tr

+90 312 292 02 00 - 803