Skip to main content

I wonder how can a Folio in the form be built based in a Formula for example if today date is:

 

11-06-15 13:27:05 ... Instead of use the now() function how can have some expression to genereate:

 

Project Name: ABC

TIMESTAMP: 110615132705

 

Expected Folio for each form: "Project Name" + "TIMESTAMP"

 

So If I complete the form right now will assign the current folio based in the time stamp preceding by the Project Name which is static.

 

Folio: ABC110615132705

 

I wonder if is regular expressions or just some formating on the Date Fields... 

 

THX Dino.

I kind of figure it out with Expression... setup a Expression Header liks MyFolioABC...

 

Then use the concatenate function to generate... not sure if this is the best way but seem to work for Year+Month+Day... not sure abut Min+Sec... but its a start...

 

11763i9525A61856A9ED15.jpg

 

Why not use Format Date function with Concatenate?

 

Concatenate ("ABC", Format Date and Time (Current Date, "yyyyMMdd")).

 

More details on Format Date and Time: http://help.k2.com/onlinehelp/k2blackpearl/userguide/4.6.5/webframe.html#date_and_time.html

You are correct Victoria this is the way to do it....

 

16691iA1265257C38E01A8.jpg

 

It worked great !!!

 

This video is awesome !!!

http://community.k2.com/t5/K2-Appit/Video-Using-expressions-to-concatenate-dates/ta-p/76468

 

 

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings