There are times you want to generate a unique serial number for each and every form that progresses sequentially in order, i.e. the smallest number was the first survey to be taken. Although this method may not meet all of your needs, it will give you an illustration of how much you can stretch calculate functions to achieve your needs.

  1. The first step requires that you create a calculate question in the formbuilder as described below. Please note the same calculate formula can work as an integer question when working from the XLS file. The formula you will need is: 

concat(substr(today(),0,4),substr(today(),7,5),substr(today(),10,8),substr(now(),13,11),substr(now(),16,14),substr(now(),19,17))

2. When you preview the form the serial number will be presented within the note question. 


Did this answer your question?