4D v18Field references |
||||||||||||||||
|
4D v18
Field references
|
Type | Value type in 4D View Pro |
Alpha, Text | string |
Integer, Long integer, Integer 64-bit, Real, Float | number |
Date | JavaScript Date type (hour, minute, sec = 0) |
Time | JavaScript Date type (date in base date, i.e. 12/31/1899) |
Boolean | bool |
Picture | supported picture types: jpg, png, gif, bmp, svg; other types converted into png. Creates an uri (data:image/png;base64,xxxx) set as background for the 4D View Pro cell where the formula is executed |
To insert a reference to a field in a formula, enter the field with the following syntax:
TABLENAME_FIELDNAME()
For example, if you declared the "Name" field of the "People" table in the virtual structure, you can call the following functions:
=PEOPLE_NAME()
=LEN(PEOPLE_NAME())
Notes:
We want to print the name of a person in a 4D View Pro area cell using a 4D field:
ARRAY TEXT($tableTitles;1)
ARRAY LONGINT($tableNum;1)
$tableTitles{1}:="Emp"
$tableNum{1}:=2
SET TABLE TITLES($tableTitles;$tableNum;*)
ARRAY TEXT($fieldTitles;1)
ARRAY LONGINT($fieldNum;1)
$fieldTitles{1}:="Name"
$fieldNum{1}:=2 //last name
SET FIELD TITLES([Employee];$fieldTitles;$fieldNum;*)
Product: 4D
Theme: 4D View Pro Database References
Created: 4D v17 R2
4D View Pro Reference ( 4D v18)