Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1026
  • Last Modified:

function to autonumber in infopath

what is the function to create a numbering field to autopopulate in InfoPath?
0
anncalk
Asked:
anncalk
  • 2
  • 2
1 Solution
 
anncalkAuthor Commented:
what is the function to create a numbering field to autopopulate in InfoPath?
0
 
Mohammed HamadaSenior IT ConsultantCommented:
0
 
Mohammed HamadaSenior IT ConsultantCommented:
0
 
anncalkAuthor Commented:
i thought it could have been better well explained.  I found that information also, I just needed a little more guidance on how the whole procedure is done.
0
 
Netadmin2Commented:
You know i read this solution and its way too hard for such an easy question! What happened to KISS. I needed a unique number and looked at this and thought there must be an easier way than data sources and all that.

Here it is:
1) create a Text Box (i'll call it Time)
Data Type: Text (string)
Value: now() - you have to click the Fx to get to this, you can type it in and get it to work right
make sure you uncheck the box that makes this date update

2) create another text box (i'll call it Auto)
Data Type: Text (string)
Value: again click the Fx. ok now you have to do some clicking and a little typing and cursor placement to make it come out right but make it look like this:
concat((substring(Time, 3, 2)), (substring(Time, 6, 2)), (substring(Time, 9, 2)), (substring(Time, 12, 2)), (substring(Time, 15, 2)), (substring(Time, 18, 2)))

now verify the formula and you should be good to go. K.I.S.S.
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now