FieldJavaScripting

Calc: Formula

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 )
• Unspported features include
  • JQuery commands (clientside only)
  • JavaScript IO functions like alert and input
  • JavaScript DOM objects like window and document

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