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 show or edit mode.

Configuration

This field requires configuration before deployment.

[INSERT IMAGE]

Edit the values using "Manual edit" feature

Required:

• Functional JavaScript (Configuration1)

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

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