Skip to content
Gallery
JS Runner
Overview
Formula ExecuteFunction
More
Share
Explore

icon picker
Formula ExecuteFunction

The JS Runber pack for Code provides the Formula ExecuteFunction. ExecuteFunction requires at least two parameters:
code: Javascript code defining one or more function.
functionName: Name of the function in the Javascript code to execute.
The simplest possible example (and rather useless):
ExecuteFunction("function sumOfTwo() { return 1+2;}", "sumOfTwo")
The result is:
3
⁠
⁠
Additionally parameters can be passed to ExecuteFunction. Each of these parameters are provided to the function with functionName.
A simple example to calculate the sum of two values is:
ExecuteFunction("function sum(v1, v2) { return v1+v2;}", "sum", 1, 2)
And the result is:
3
⁠
⁠
Now you can calculate the sum of any two numbers!

A more complex example

The following shows a more complex example, it allows to calculate the
fibonacci number
⁠
:
ExecuteFunction("
function fibonacci(num) {
if(num < 2) {
return num;
} else {
return fibonacci(num-1) + fibonacci(num - 2);
}
}", "fibonacci", 10)
The result is:
55
⁠
⁠
Please note that this is a very inefficient algorithm to calculate the fibonacci number, it only serves as a simple example here.

Reference code from a formula

You can "store" your code in a formula, name the formula and then reference the code later to reuse it:
⁠
function fibonacci(num) { if(num < 2) { return num; } else { return fibonacci(num-1) + fibonacci(num - 2); } }
⁠
⁠
Use it like this:
ExecuteFunction(thisDocument.fibonacci, "fibonacci", 10)
And the result is again:
55
⁠
⁠
You can use the
JS Flowchart
⁠
pack to analyse your code:
⁠
⁠
⁠

Reuse code from a formula in a table

Once you have the code reusable, you can use a table to calculate a set of values:
The first n fibonacci numbers
1
N
Fibonacci(N)
1
1
1
2
2
1
3
3
2
4
4
3
5
5
5
6
6
8
7
7
13
8
8
21
9
9
34
10
10
55
There are no rows in this table
⁠
And see how it grows:
Chart of The first n fibonacci numbers
1
⁠


Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.