Displaying functions by Andries Heylen

date.previous ( _date ; _day )

Calculation that allows you to calculate the previous weekday (so last friday, last sunday etc).

    By Andries Heylen   (2 comments Posted 16 November 2016   Rating:  unrated

DistanceSpherCoord ( _Lat1 ; _Lon1 ; _Lat2 ; _Lon2 )

Calculates the distance between two spherical co-ordinates, with an almost exact accuracy using the Haversine formula

    By Andries Heylen   (1 comments Posted 21 April 2009   Rating:  5.0

field.hasAccess ( _fieldName )

Returns a boolean if the user has access to the field or not. You can use it to hide fields if the user has no access to them.

    By Andries Heylen   (0 comments Posted 23 May 2017   Rating:  unrated

FindIndex ( _value ; _array ; _startIndex ; _occurrence )

Finds the index of the value in the array

    By Andries Heylen   (2 comments Posted 29 March 2013   Rating:  4.0

GetRealXMLFromWebViewer ( _html )

Transforms the result of GetLayoutObjectAttribute ( "wv" ; "content" ) on a Windows machine to a parseable XML

    By Andries Heylen   (4 comments Posted 16 February 2012   Rating:  5.0

LinearPolarization ( _xPolarise ; _yValues ; _xValues )

This function allows you to predict a value based on a dataset ( { X1 ; Y1 } ; { X2 ; Y2} ; ... ; { Xn ; Yn} )

    By Andries Heylen   (0 comments Posted 11 December 2008   Rating:  unrated

LinearTrend ( _xValues ; _yValues )

This function returns the linear regression equation of a given dataset.

    By Andries Heylen   (4 comments Posted 10 December 2008   Rating:  5.0

LookUpX ( _lookUp ; _trigger )

A funtion to trigger a lookup based on any field inside the same table.

    By Andries Heylen   (0 comments Posted 20 March 2010   Rating:  unrated

SaveTemp ( _filename )

Creates a real path to a temporary file, by adding the FMTEMPFM string before the filename.

    By Andries Heylen   (7 comments Posted 10 March 2009   Rating:  unrated

sql.debug ( _executeSQL )

Helps you to debug your sql function in the data viewer

    By Andries Heylen   (8 comments Posted 28 July 2012   Rating:  5.0

While ( _exitCondition ; _iterator )

Use this function in a Exit Loop If script step.

    By Andries Heylen   (4 comments Posted 10 September 2010   Rating:  5.0

 

 

 

 

 

 

 

Top Tags

Text Parsing  (33)
List  (31)
Date  (28)
XML  (26)
Format  (23)
Sql  (22)
Dev  (20)
Debug  (17)

 

Interface  (15)
Layout  (15)
Text  (14)
Variables  (12)
Layout Objects  (11)
Filter  (11)
Design  (10)
Array  (7)