Difference between revisions of "FieldJavaScripting"

From TempusServa wiki
Jump to navigation Jump to search
old>Admin
old>Admin
Line 43: Line 43:


{|
{|
|Field
!Field
|Client side example
!Client side example
|Server side format
!Server side format
|-
|-
|Date
|Date
Line 55: Line 55:
|1.234
|1.234
|}
|}


==== Example ====
==== Example ====

Revision as of 12:45, 24 June 2014

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

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