Difference between revisions of "FieldJavaScripting"
Jump to navigation
Jump to search
old>Admin |
m (17 revisions imported) |
||
(4 intermediate revisions by one other user not shown) | |||
Line 37: | Line 37: | ||
** JavaScript IO functions like '''alert''' and '''input''' | ** JavaScript IO functions like '''alert''' and '''input''' | ||
** JavaScript DOM objects like '''window''' and '''document''' | ** 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 ==== | ==== Example ==== |
Latest revision as of 11:51, 10 December 2021
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