Formulae: Field/Cell direct access functions CELL, etc. (2.8+)
-
These 4 new formula functions allow you to access arbitrary cells in the data. Also available in scripting.
CELL
FIELDCOUNT
FIELDNAME
FIELDNUMBER
Formula examples to obtain cell valuesCELL([Price], 53)CELL(FIELDNAME(3), CURRENTROW()-1)
Javascript preprocessing example to list all field values
for (n = 1; n<=fieldCount(); n++) {
out.println(fieldName(n)+": "+cell(fieldName(n), 1)+"<br>");
} -
2 Comments
-
This feature is now publicly available in 2.8 beta:
http://forums.visokio.com/discussion/2130/omniscope-2.8-beta
Welcome!
It looks like you're new here. If you want to get involved, click one of these buttons!
Categories
- All Discussions2,595
- General680
- Blog126
- Support1,177
- Ideas527
- Demos11
- Power tips72
- 3.0 preview2
Tagged
To send files privately to Visokio email support@visokio.com the files together with a brief description of the problem.