U Man Genius docs
Pages
Scripting tips & tricks
Undocumented functions in Ninox
Jacques TUR
Some functions are not included in Ninox's official documentation. These were discovered by examining the code and understanding their behavior.
TypeOf
The typeof function returns the type of a specified field.
Example:
typeof(first(select Customer).'First Name');
Eval
The eval function executes the script passed as a parameter within the context of a specified record. It returns either the value or a text indicating an error in the script.
Example:
eval("---{this.'First Name'} {this.'Last Name'}---", first(select Customer));
Output:
Sofia Young
DebugValueInfo
The debugValueInfo function returns a text indicating the type and value of the parameter passed.
This is particularly useful for testing pieces of code in the Ninox console.
Example:
debugValueInfo(eval("---{this.'First Name'} {this.'Last Name'}---", first(select Customer)));
Output:
any("Sofia Young")
Debug
The debug function is equivalent to console.log in JavaScript.
It sends the value passed as a parameter to the browser's developer console. This is helpful for debugging code in formulas.
Example:
(select Customer where 'First Name' like "a").(
var 'firstName' := this.'First Name';
var lastName := this.'Last Name';
debug("Debug info: " + 'firstName' + " " + lastName);
)
The result appears in the browser's developer console (accessible via developer tools).
Records
The records function returns records based on a specified array of numbers.
Note: The array must be hardcoded; it cannot be a variable, which makes this function less flexible. It is primarily useful when you need to retrieve the same records consistently.
Example:
records(Customer, [1, 3, 6]).'First Name';
This retrieves the first names of records with the IDs 1, 3, and 6.
http with nx-file
function loadFileOnBase64FromUrl(URL : text) do
var fileName := extractx(URL, "\/([^\/?#]+)[^\/]*$", "$1");
{
fileName: fileName,
content: do as server
http("get", URL, {
'content-type': "application/octet-stream",
'nx-file': "base64url"
}, null).result
end
}
end;
var base64UrlFile := loadFileOnBase64FromUrl( url );
importFile(this, text(base64UrlFile.content), text(base64UrlFile.fileName));
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.