Expand my Community achievements bar.

July 31st AEM Gems Webinar: Elevate your AEM development to master the integration of private GitHub repositories within AEM Cloud Manager.

Autofill cell with current date

Avatar

Level 2
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
4 Replies

Avatar

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

Avatar

Level 2
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))

Avatar

Former Community Member
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