You are on the Xporter Cloud documentation. If you are looking for Xporter Server documentation, you can find it in this page.

Xporter allows rendering text based on JavaScript. The notation is:

%{<Javascript>}

Examples:

Output the current date 
%{( new Date()).getDate() +  "/" + (( new Date()).getMonth()+ 1 ) +  "/" + ( new Date()).getFullYear()}
Format the Creation Date in the dd-MM-yyyy HH:mm format (01-03-1978 8:00) 
%{var dateTime = '${dateformat("dd-MM-yyyy HH:mm:ss"):Created}'.split( ' ' ); var date = dateTime[ 0 ]; var time = dateTime[ 1 ]; var dateParts = date.split( '-' );
 var timeParts = time.split( ':' ); dateParts[ 2 ] +  '-' + dateParts[ 1 ] +  '-' + dateParts[ 0 ] +  ' ' + timeParts[ 0 ] +  ':' + timeParts[ 1 ]}
Format the Creation Date in the dd-MM-yyyy format (03-01-1978) 
%{'${dateformat("dd-MM-yyyy HH:mm:ss"):Created}'.substring( 0 , 10 )}
Format the Creation Date in the MMM d yyyy format (Jan 3, 1978) 
%{var months =  new Array( 'Jan' ,  'Feb' ,  'Mar' ,  'Apr' ,  'May' ,  'Jun' ,  'Jul' ,  'Aug' ,  'Sep' ,  'Oct' ,  'Nov' ,  'Dec' ); var dateParts
 = '${dateformat("d-MMM-yyyy HH:mm:ss")}'.split( '-' ); var month = dateParts[ 1 ]; var year = dateParts[ 0 ] ; var day = dateParts[ 2 ].split( ' ' )[ 0 ];
 months[Number(month) -  1 ] +  ' ' + day +  ', ' + year;}
Export the content if the field is not empty; otherwise, display other text 
%{( '${Focus}' .length >  0 ) ?  'Focus: ${Focus}' :  'Focus not Available' }
  • No labels