| 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)
	
	
	
 Add a comment
Add a comment