FieldJavaScripting

Calc: JavaScript

Executing Javascripts client AND serverside

NOTE: This feature is currently BETA, and features are subject to change.

Properties

• Type: Complex
• Groupable: No
• Show in lists: No
• Searchable: No

User interface

Due to its nature this field has no special editing mode.

Configuration

This field requires configuration before deployment.

Edit the values using "Manual edit" feature

Required:

• Functional JavaScript (Configuration1)

Options:

• None (yet)

Help for syntax

The API currently supports the following language features

• All standard functions from JavaScript
  • Librarys like Math
• Support for basic TS form functions
  • getValue( variable )
  • setValue( variable, valueToAssign )
• Unsupported features include
  • JQuery commands (clientside only)
  • JavaScript IO functions like alert and input
  • JavaScript DOM objects like window and document

Important notice

Some field values are represented differently server and client side, namely date and decimal values

Field	Client side example	Server side format
Date	31/1/2014	2014-01-31
Decimal	1,23	1.234

Future versions will include these methods callable server and clientside

• getValueDate( fieldname )
• getValueDecimal( fieldname )
• getDateFromString( string )
• getDecimalFromString( string )

Example

 if( getValue('NUMBER2') > 1000 )
   setValue('NUMBER1',  Math.round( 100 * Math.random() ) );

Developer info

• FeltTypeID: 83
• SQL datatype: n/a
• Class name: FieldJavaScripting
• Field is ignored in tables