Reference Guide

Introduction

This is the complete Molnify Reference. It covers the various components of a Molnify application, and how to customize them for your application.

To get started with Molnify, see one of the following resources:

Creating a Molnify application, which explains how to quickly and easily create a Molnify application from scratch.
Molnify video tutorials, which introduce the basics of Molnify. Additional video tutorials on developing Molnify applications are also available at Molnify's YouTube channel.

Some other useful resources and tools are:

Molnify example applications, with Excel sheets available to download from each example application.
The CSS-generator, which helps you generate and experiment with stylings of your app.
The Molnify forum, containing various guides, tips, and a space to interact with and ask questions of other Molnify users.

Throughout this reference, boxed text such as this one contains more in-depth and technical details.

Database Connection

You can connect your Molnify application to an SQL database. Contact us to have your database set up.

Once your database is enabled, you can:

Perform database lookups using the Database Lookup macro.
Insert rows into your database table using the Insert Row action.
Use Autofill to populate your app with data from a database table.
Save inputs to your database, and restore them, using the Add Record action.

Single-Sign-On (SSO)

Molnify supports multiple types of sign-on: email/password, Google based, Azure AD, TokenAuthentication (described below) and SAML-based logins. Contact us to enable SSO for your domain(s).

Token Authentication

The purpose of TokenAuthentication is so that you as a client of Molnify can easily log in your customer to Molnify applications, without having to go through the process of having your users creating accounts on Molnify or alternatively integrate with your SSO solutions (e.g., Google Domains or Microsoft Active Directory). An app can be enabled for token-based authentication by specifying the metadata TokenAuthentication.

For more information, contact us.

Structure

Molnify turns a spreadsheet into an app containing different elements: inputs, outputs, charts, tables and actions. In short, inputs let the user fill in data, while outputs, charts and tables show results. Actions are used to perform tasks such as sending emails and much more. The colors of your spreadsheet cells tell Molnify what types of elements to create.

The basic structure for an input and output consists of three cells: (1) title, (2) value and (3) user interface (UI string). The UI string decides how an input or output is presented and is optional. If left out, Molnify will choose the most appropriate representation.

Colors

Use these colors to let Molnify know what types of elements to create.

Green (#00b050): Inputs
Red (#ff0000): Outputs
Light blue (#0070c0): Charts and Tables
Yellow (#ffff00): Actions
Purple (#7030a0): Metadata

You can use other spreadsheet-editors than Excel and Google Sheets to create your Molnify application, but you need to use the hex values of the standard colours for Excel and Google sheets.

	A	B	D	E
1	Value A	5	A Chart	Series
2	Value B	10	Value A	=B1
3			Value B	=B2
4	Product	=B1*B2
5
6	Name	My App
7	ID	myApp

Copy for Excel Copy for Sheets

This would create a fully functional app with two inputs (Value A and Value B) with default values of 5 and 10. An output box, titled Product, would show the product of the two inputs. A chart, titled A Chart, would plot the two inputs. The purple cells set the metadata; i.e., the name would be My App and its ID would be myApp.

User Interface (UI) String

To customize an input or output, you may specify different settings in the cell to the right of the actual input/output (cell C1 in the example). We call this the UI (user interface) string. All these options are separated by ;. E.g., min=0;max=50.

	A	B	C
1	Label	0	min=0;max=50

Copy for Excel Copy for Sheets

This example would generate a numeric input titled Label with a default value of 0. Its UI string is min=0;max=50, so only values between 0 and 50 would be allowed.

It is important that there are no blankspaces in the UI string, in order for it to be parsed correctly.

Inputs

If you color a cell green, you will get an input. There are many different types of inputs, such as text fields, sliders, dropdown menus and more.

An input consists of the following elements:

Title: Specify the title of the input to the left.
The actual input: The green cell in the middle contains the actual input element. Any value or result of formula present in this cell will determine the default value of this input. Additionally, if the UI string does not specify which kind of input the element is, then Molnfiy will choose a type of input based on the default value of this cell.
UI string: The cell to the right contains UI options for the input.
Tooltip: Add a comment to the title cell (the green cell) to make Molnify show a tooltip when you hover over the title of the input.

Example:

	A	B	C
1	Label	0	min=0;max=50

Copy for Excel Copy for Sheets

This example would generate a numeric input titled Label with a default value of 0. Its UI string is min=0;max=50, so only values between 0 and 50 would be allowed.

Any formulas present in input value cells are only calculated when the application is loaded, to generate default values for inputs. Afterwards, they are not re-calculated when the state of the application changes, e.g. when the value of another input changes, to avoid overriding any data already filled in by the user.
In other words, to dynamically change the default value of an input, you need to use e.g. javascript to work around this limitation.

Button Group

Try It Download

By having data validation enabled for an input cell and assigning a list of values, Molnify will show a group of buttons - one for each value in the list. If the list contains more than 5 options, Molnify will present a dropdown list instead.

Example:

	A	B	C
1	Select Country	Sweden	select

Copy for Excel Copy for Sheets

This example would create an input titled Select Country with a default value of Sweden. Its UI string is select, which would tell Molnify to show this as a button group regardless of the length of the data validation list.

The button group input supports the following UI strings: class, dividerName, hidden, JSOnChange, multiple, NOCALC, resetWhenHidden, select, variable.

Date-picker

Try It Download

An input field can be rendered as a date-picker by formatting the input cell as a date in your spreadsheet. Alternatively, you may instruct Molnify to interpret the cell as a date-picker by specifying date in the UI string.

Example:

	A	B	C
1	Date	2020-01-01	date

Copy for Excel Copy for Sheets

This example would create a datepicker titled Date with a default value of 2020-01-01. Its UI string is date.

The date-picker input supports the following UI strings: date (required), class, dividerName, hidden, JSOnChange, NOCALC, variable.

	A	B	C
1	Select Country	Sweden	dropdown

File Upload

A file upload input lets your users upload files. Referencing the input (e.g., =B1) will give you a comma-separated string of URLs to the uploaded files. E.g., https://files.myserver.com/files/anImage.jpg,https://files.myserver.com/files/anotherImage.jpg. If you need to retrieve a full-sized image, add __full_ to the filename, e.g., .../anImage__full_.jpg.

Next to the file upload area is a gallery of the uploaded files associated with the specific input.

Optionally, you may limit the number of uploaded files by using the maxFiles UI string, e.g. maxFiles=10;. Similarly, you may limit the accepted file types by using the acceptedFileTypes UI string, see acceptedFileTypes for more information.

Example:

	A	B	C
1	Upload Files		fileUpload;maxFiles=10

Copy for Excel Copy for Sheets

This example would create an input titled Upload Files. Its UI string is fileUpload;maxFiles=10, which would tell Molnify to create a file upload area and gallery. It would allow for a maximum of ten files to be uplodad.

The file upload input supports the following UI strings: fileUpload (required), acceptedFileTypes, class, dividerName, hidden, JSOnChange, maxFiles, NOCALC, variable.

Infotext

Try It Download

An infotext is actually not an input, but a descriptive text placed among your inputs. For longer infotext, you may use the long infotext instead.

As input cells do not re-calculate any formula present in their value cell, infotext inputs cannot be used to create dynamic text contents. To create a dynamic text that is displayed among inputs, use a HTML output among inputs instead.

Example:

	A	B	C
1	Description	This may be...	infoText

Copy for Excel Copy for Sheets

This would create an info text with the title Description and the text This may be.... Its UI string, infoText, tells Molnify to render it as an info text.

The infotext input supports the following UI strings: infotext (required), class, dividerName, hidden, variable.

Long Infotext

Try It Download

A long infotext is actually not an input, but a descriptive text placed among your inputs. Wider than the regular Infotext input, the long infotext does not show a title, but instead uses the space where the title would have been as additional space to display its value.

As input cells do not re-calculate any formula present in their value cell, long infotext inputs cannot be used to create dynamic text contents. To create a dynamic text that is displayed among inputs, use a HTML output among inputs instead.

Example:

	A	B	C
1		This may be long...	longInfoText

Copy for Excel Copy for Sheets

This would create a long info text with the text This may be long.... Note that long info texts do not have titles. Its UI string, longInfoText, tells Molnify to render it as a long info text.

The long infotext input supports the following UI strings: longinfotext (required), class, dividerName , hidden, variable.

Manager

A manager cell will contain TRUE or FALSE, depending on if the signed in user is a manager or not.

The manager supports the following UI strings: manager (required).

Numeric text field

Try It Download

Text fields are the default input types. A text field becomes a numeric text field when the default value is numeric.

Example:

	A	B	C
1	Label	0	min=0;max=50

Copy for Excel Copy for Sheets

This example would generate a numeric input titled Label with a default value of 0. Its UI string is min=0;max=50, so only values between 0 and 50 would be allowed.

The numeric text field supports the following UI strings: class, dividerName, hidden, JSOnChange, max, min, noButtons, NOCALC, postFix, preFix, regEx, variable.

Records Table

A records table input accesses database records saved in another app. The appId UI string is used to specify which app the records are to be fetched from, and the columns UI string is used to specify which columns are to be fetched from the records table.

	A	B	C
1	Records		recordstable;appId=MY_APP;columns=A,B

Copy for Excel Copy for Sheets

This would create a records table with the title Records. Its UI string, recordstable;appId=MY_APP;columns=A,B, tells Molnify to render it as a records table, listing the fields A and B from the app MY_APP.

The records table supports the following UI strings: appId (required), class, columns (required), recordsTable (required), dividerName, hidden, JSOnChange, variable.

Signature

Try It Download

This input provides a signature area for hand-written signatures. The data format is Base30. To access the data in SVG code instead, use the signature (SVG) input.

Example:

	A	B	C
1	Sign Here		signature

Copy for Excel Copy for Sheets

This would create a signature input with the title Sign Here. Its UI string, signature, tells Molnify to render it as a signature area.

The data format of a signature is Base30. To access this data as SVG instead, see copySVGToTextInput.

The signature supports the following UI strings: signature (required), class, dividerName, hidden, JSOnChange, NOCALC, variable.

Slider

Try It Download

A slider is a numeric input which is shown as a slider. By default, the slider ranges between [0,1337], unless overridden by the UI string.

Example:

	A	B	C
1	Label	10	slider;min=0;max=50

Copy for Excel Copy for Sheets

This example would create a slider titled Label with a default value of 10. Its UI string is slider;min=0;max=50, which tells Molnify to present this as a slider with a range of 0-50.

The slider supports the following UI strings: slider (required), class, delta, dividerName, gridNum, hidden, JSOnChange, max, min, NOCALC, variable.

Superuser

A superuser cell will contain TRUE or FALSE, depending on if the signed in user is a superuser or not.

The superuser supports the following UI strings: superuser (required).

Text area

A text area is a slightly larger text field that the user may resize to accomodate larger text inputs.

Example:

	A	B	C
1	Text area		textArea

Copy for Excel Copy for Sheets

This would create a text area with the title Text area. The UI string, textArea tells Molnify that the input is to be rendered as a text field.

The text area supports the following UI strings: textarea (required), class, hidden, dividerName, JSOnChange, NOCALC, placeholder.

See also: Numeric text field, Text field.

Text field

Try It Download

This is the default input type.

Example:

	A	B	C
1	Text field	Lorem ipsum ...

Copy for Excel Copy for Sheets

This would create a text field with the title Text field. No UI string is needed, since the text field is the default input type.

The text field supports the following UI strings: barcode, class, dividerName, hidden, JSOnChange, NOCALC, placeholder, postFix, preFix,regEx, variable.

See also: Numeric text field, Text area.

Time-picker

Try It Download

An input field can be rendered as a time-picker by formatting the input cell as a time-of-day in your spreadsheet. Alternatively, you may instruct Molnify to interpret the cell as a time-picker by specifying time in the UI string.

Example:

	A	B	C
1	Time	12:00:00	time

Copy for Excel Copy for Sheets

This example would create a timepicker titled Time with a default value of 12:00:00. Its UI string is time.

The time input supports the following UI strings: time (required), class, dividerName, hidden, JSOnChange, NOCALC, variable.

Toggle button

Try It Download

An input whose default value is either TRUE or FALSE becomes a toggle button.

The above TRUE and FALSE refer to values, and not strings. Notably, if your spreadsheet editor is in a non-English language, you will need to use that language's equivalents to "True" and "False." For example "Sannt" in Swedish, and "Vrai" in French.

Example:

	A	B	C
1	A toggle	TRUE

Copy for Excel Copy for Sheets

This would create a toggle button with the title A toggle. Since the value is TRUE, the button would be active by default.

The toggle button supports the following UI strings: class, description, dividerName, hidden, JSOnChange, NOCALC, variable.

User

A user input is not rendered, but the cell will contain the email or personal number of the logged in user, depending on what was used to log in. To specify email or personal number, use user.email or user.identificationnumber respectively.

The user supports the following UI strings: user (required).

Outputs

If you color a cell red, you will get an output. There are different types of outputs, such as output boxes, HTML panels and more.

An output consists of the following elements:

Title: Specify the title of the output to the left.
The actual output: The red cell in the middle contains the actual output element. Any formula present in the output will be evaluated and updated whenever an input or data is changed in the application.
UI string: The cell to the right contains UI options for the output.
Description: Add a comment to the red cell to make Molnify show a description within an output panel or below an output box.

	A	B	C
1	Result	=SUM(B2:B20)	icon=fa-money

Copy for Excel Copy for Sheets

This would create an output box titled Result. Its value is calculated by =SUM(B2:B20). Its UI string is icon=fa-money, which would tell Molnify to show the Font Awesome icon fa-money next to the value inside the output box.

HTML Panel

Try It Download

The HTML Panel output type renders the result in the cell as an HTML-formatted panel. The copy button copies the HTML-element's data to the user's clipboard.

The HTML panel output is very flexible, and only limited to what you can do in HTML, CSS, and JavaScript.

Example:

	A	B	C
1	An HTML Panel	="<b>This is: </b>" & A1	html

Copy for Excel Copy for Sheets

This would create an HTML-formatted panel titled An HTML Panel. Its value is set to ="<b>This is: </b>" & A1. The text shown in the HTML panel would thus be This is: An HTML Panel. Its UI string, html, is what tells Molnify to show this as an HTML-formatted panel.

The HTML panel output supports the following UI strings: html (required), amongInputs, class, dividerName, hideCopy, JSOnChange, leftColumn, noTitle, panelHidden, rightColumn, variable.

Output Box

Try It Download

This is the default output type. All output boxes are rendered on the same output panel, in the order in which they appear in the spreadsheet.

Numbers are generally displayed using the client's locale. For instance, the thousand separator in some countries is , and in others it's a space ( ), etc. If the digits are joined by a non-number character, e.g., a currency symbol, Molnify interprets the number as a text string, and the number formatting is lost.
If the number you wish to format is the value of cell A1, then TEXT(F10,"$#,##0.00") would format it with a dollar-sign as prefix, with a comma as thousands delimiter, a dot as decimals delimiter, and rounded to 2 decimal places.
Sometimes dates are represented by the number of days from January 1 1900. To format such a number as a human-readable date, you can use TEXT(A1,"MM/DD/YY").
For more examples of common formatting solutions, see Google's or Microsoft's documentation of the TEXT function.

Example:

	A	B	C
1	Value	=B3*B4	icon=fa-flag;background=gray;color=white

Copy for Excel Copy for Sheets

This example would create an output box titled Value. Its value is calculated by =B3*B4. Its UI string is icon=fa-flag;background=gray;color=white, which would tell Molnify to show the Font Awesome icon fa-flag next to the value inside the output box, set the background color to gray and the text color to white. If you add a comment to the red cell, it will be displayed below the value.

The output box output supports the following UI strings: background, class, color, decimals, dividerName, hidden, icon, JSOnChange, tab, variable.

People Matrix

Try It Download

A people matrix represents a value from 0 to 100 as part of a matrix of 100 people.

Example:

	A	B	C
1	Number	10	peopleMatrix

Copy for Excel Copy for Sheets

This example would create a People Matrix titled Number. Its value would be 10. Its UI string, peopleMatrix, tells Molnify to display the value as 10 highlighted people out of 100.

The people matrix output supports the following UI strings: peopleMatrix (required), class, color, columns, icon, JSOnChange, leftColumn, panelHidden, rightColumn, rows, variable.

Charts

If you color a rectangular area of cells blue, you will get a chart. There are many different types of charts, such as bar charts, pie charts and more.

Title: Specify the title of the chart in the topmost left cell.
The actual data: The blue cells contain the actual chart data
UI string: The topmost right cell contains UI options for the chart.
Description: Add a comment to the chart title cell (i.e., the topmost left cell) to add a description above the chart.

To set the height of a chart, add the desired height as CSS in your metadata. E.g., div[cell='Sheet1!C7:C33'] svg { height: 2000px; } for a chart in cells C7:C33.

Bar Chart

Try It Download

The bar chart is the default chart type.

Note that if the chart data consists of a single data series that sums up to 1 or 100%, then the chart will be rendered as a pie chart instead.

Example:

Copy for Excel Copy for Sheets

This would create a bar chart with two series and six datapoints. The chart title, Graph, is in cell A1. The series names are specified in cells B1 and C1. The labels for the datapoints are in column A. The UI string, in cell D1, is xAxis=Month;yAxis=Rate, which sets titles for the X and Y axes.

The bar chart supports the following UI strings: barChart, atLeast, axisDecimals, centerZero, class, decimals, horizontal, JSOnChange, leftColumn, noControls, noGridLines, noGroupedStackedControls, noWordWrap, panelHidden, rightColumn, series, seriesInColumns, seriesInRows, showValues, stacked, staggerLabels, xAxis, yAxis, yAxisTicks.

Geo Chart

Try It Download

A geo chart shows a world map with values specified for different countries. The chart is specified the same way as a bar chart with one series. Countries are defined using country codes (e.g., US, SE, DK, NO) as datapoint labels.

Example:

Copy for Excel Copy for Sheets

This example creates a geo chart titled Geo chart five datapoints, one datapoint for each country: Sweden, Denmark, Norway, the U.S.A., and Great Britain. The UI string, geoChart, instructs Molnify to present the data as a geo chart.

The geo chart supports the following UI strings: geoChart (required), class, decimals, JSOnChange, leftColumn, map, panelHidden, rightColumn.

Line Chart

Try It Download

A line chart represents data as a line.

For a combined line/bar chart (UI string: lineBarChart), the first series represents the bars and the second series represents the line. Specify atLeastSync to make atLeast=value apply to both Y axes.

Example:

Copy for Excel Copy for Sheets

This would create a line chart titled A Line Chart with two series (An index and Another index) and twelve datapoints. The UI string, lineChart, instructs Molnify to present the data as a line chart.

The line chart supports the following UI strings: lineChart (required), atLeast, axisDecimals, class, decimals, JSOnChange, leftColumn, noGridLines, panelHidden, rightColumn, series, seriesInColumns, seriesInRows, steps, xAxis, yAxis.

Line/Bar Chart

A line/bar chart is a bar chart where the first series of data is rendered as a bar chart, and the remaining series of data are rendered as lines on top of the bars.

Example:

Copy for Excel Copy for Sheets

This would create a line bar chart titled A Line Bar Chart with two series (An index and Another index) and twelve datapoints. The UI string, lineBarChart, instructs Molnify to present the data as a line bar chart.

The line/bar chart supports the following UI strings: lineBarChart (required), atLeast, atLeastSync, axisDecimals, class, decimals, JSOnChange, leftColumn, noGridLines, panelHidden, rightColumn, series, seriesInColumns, seriesInRows, showValues, xAxis, yAxis.

Pie Chart

Try It Download

A pie chart is a circular chart divided into areas proportional to the percentages of the whole.

Example:

Copy for Excel Copy for Sheets

This example creates a pie chart titled A Pie Chart with three datapoints. The UI string, pieChart, instructs Molnify to show the data as a pie chart.

The pie chart supports the following UI strings: pieChart, class, decimals, JSOnChange, leftColumn, panelHidden, rightColumn, series.

Scatter Chart

To create a scatter chart, you need an area with at least three columns - series, x and y. Optionally, you can also specify size and shape.

The available shapes are:

circle
diamond
triangle-up
triangle-down
cross
square

Example:

Copy for Excel Copy for Sheets

This would create a scatter chart titled A Scatter Chart with three datapoints and two series (A and B). The UI string, scatterChart, instructs Molnify to present the data as a scatter chart.

The scatter chart supports the following UI strings: scatterChart (required), atLeast, axisDecimals, class, decimals, JSOnChange, leftColumn, noGridLines, panelHidden, rightColumn, xAxis, yAxis, yAxisTicks.

Table

Try It Download

Aggregated data can also be presented as a table. As with most other charts, column titles and row titles are entered outside the blue area.

Example:

Copy for Excel Copy for Sheets

Example of how to create a table with the panel title A Table. Its UI string, table, tells Molnify to display your data as a table instead of a chart.

The table supports the following UI strings: table (required), class, decimals, JSOnChange, leftColumn, panelHidden, rightColumn.

Waterfall Chart

Try It Download

A waterfall chart looks like a horizontal bar chart, and shows the net change in data between point. Enter e whenever you want to present an accumulated value.

Example:

Copy for Excel Copy for Sheets

Example of how to create a waterfall chart titled A Waterfall Chart with two series (Rocks and Spoons). e lets Molnify know to show the accumulated value. e is actually also what makes it a waterfall chart without explicitly specifying it in the UI string. In this example, atLeast is set to 20 in the UI string (atLeast=20), meaning that the value 20 will always be included on the Y axis.

The waterfall chart supports the following UI strings: waterfallChart (required), atLeast, class, decimals, JSOnChange, leftColumn, noGridLines, noWordWrap, panelHidden, rightColumn, seriesInColumns, seriesInRows, showValues.

UI Strings

UI Strings are used to customize inputs, outputs, and charts. This section lists all of them, along with any notes on their usage.

acceptedFileTypes

Limits the accepted file types, by specifying comma-separated MIME types and file extensions. E.g. use image/*,application/pdf to accept all types of images and PDFs. The file extension can be a wildcard (*).

See: File upload.

amongInputs

Displays the output element among the input elements, as if it was an input.

See: HTML panel.

appId

Specify the ID of another app.

Usage: appId=MY_OTHER_APP.

See: HTML panel.

atLeast

Ensures that the specified value always is shown on the y-axis of the chart. For scatter charts, define a comma-separated string of values. I.e., atLeast=xMin,xMax,yMin,yMax, where each position corresponds to a value that should always be covered by the chart.

Usage: atLeast=10

See: Bar chart, Line chart, Waterfall chart.

atLeastSync

If this UI string is present, then the value specified with atLeast applies to both y-axes.

See: Line/Bar chart.

axisDecimals

Sets the number of decimals to display on the axes of the chart.

Usage: axisDecimals=2

See: Bar chart, Line chart, Line/bar chart, Scatter chart.

background

Sets the background color of an output box.

Usage:

background=gray
background=#ffff00 (hex code)
background=#ffff0050 (hex code with transparency)

See: Output box.

barChart

Specifies that the chart should be a bar chart.

See: Bar chart.

barcode

If you're planning on using a barcode scanner for entering data into the input, specify barcode as the UI string to make the text field automatically select all text upon hitting the ENTER key.

See: Bar chart.

centerzero

Specifies that the values zero should always be centered in the chart.

See: Bar chart.

class

Adds a CSS class to the associated element. For complex elements that are contained in a panel, e.g., a chart, the class is applied to the whole panel body.

Usage: class=my-class. Note that the class name should not contain any ' or " characters.

See: Button group, Date-picker, Dropdown list, File upload, Infotext, Long infotext, Numeric text field, Output box, Records table, Signature, Slider, Text area, Text field, Time-picker, Toggle button, CSS.

color

Sets the text or data color of an output.

See: Output box, People matrix.

columns (Records table)

Specifies the names of the columns to be read from the records table. Do note that the Molnify-managed columns recordId, _molnify_user_email, etc cannot be accessed in this way.

Usage: columns=A,B

See: Records table.

columns (People matrix)

Specifies the number of columns of the output matrix.

Usage: columns=5

See: People matrix.

date

Specifies that the input should be a date-picker.

See: Date-picker.

decimals

Sets the number of decimals to display of the data.

Usage: decimals=2

See: Bar chart, Geo chart, Line chart, Line/Bar chart, Output box, Pie chart, Scatter chart, Table, Waterfall chart.

delta

Sets the size of the steps of the input.

Usage: delta=0.5

See: Slider.

description

Shows a descriptive text next to a toggle input.

Usage: description=This describes this button.

See: Toggle button.

dividerName

Try It Download

Inserts a divider with the specified title above the input. The divider is shown or hidden along with its associated input.

Adds a horizontal divider with the specified title above the input field. The divider is shown and hidden along with the input it's associated with.

	A	B	C
1	Name	John Doe	dividerName=Personal Information

Copy for Excel Copy for Sheets

This example would create an input titled Name with a default value of John Doe. Its UI string is dividerName=Personal Information, which would insert a divider with the title Personal Information above the input.

Usage: dividerName=Title here

See: Button group, Date-picker, Dropdown list, File upload, Infotext, Long infotext, Numeric text field, Output box, Records Table, Signature, Slider, Text area, Text field, Time-picker, Toggle button.

Specifies that the input should be a dropdown list.

See: Dropdown.

fileUpload

Specifies that the input should be a file upload.

See: File upload.

geoChart

Specifies that the chart should be a geo chart.

See: Geo chart.

gridNum

Sets the number of ticks on a slider input.

Usage: gridNum=7

See: Slider.

hidden

Hides the element from the user.

	A	B	C
1	Positive?	=IF(B3>0;"show";"hide")	hidden

Copy for Excel Copy for Sheets

This would create an output with the title Positive?. Because of the UI string, hidden, it would always be hidden.

The hidden element still exists on the page, but is invisible and does not take up any space. This means that javascript can be used to interact with the element, and any formulas in the element's data are still calculated.

hideCopy

Hides the copy-button associated with the element from the user.

See: Slider.

horizontal

If set to true, the chart will be rendered with horizontal bars.

Usage: horizontal=true

See: Bar chart.

html

Specifies that the output should be an HTML panel.

See: HTML panel.

icon

Sets the icon associated with the output or chart. Molnify supports Font Awesome icons.

Usage: icon=fa-money

See: Output box, People matrix.

infotext

Specifies that the element should be an infotext.

See: Infotext.

JSOnChange

Specifies a javascript function or single statement to run whenever the input or output is changed.

The following example would check the character length of an input with variable set to charlimit. If the length exceeds 6 characters, all characters after the sixth character are removed:

variable=charlimit;jsOnChange=if (getValueForVariable("charlimit").length > 6) setValueForVariable("charlimit", getValueForVariable("charlimit").substring(0,6));

In order to run several functions or lines of code, you can define a custom function in the JavaScriptAfterLoad metadata field, and call your custom function with JSOnChange.

leftColumn

Specifies that a panel should be in the left column.

See: HTML panel, People matrix, Bar chart, Geo chart, Line chart, Line/Bar chart, Pie chart, Scatter chart, Table, Waterfall chart.

lineBarChart

Specifies that the chart should be a line/bar chart.

See: Line/Bar chart.

lineChart

Specifies that the chart should be a line chart.

See: Line chart.

longinfotext

Specifies that the input element should be a long infotext.

See: Long infotext.

manager

Specifies that the input cell should contain TRUE or FALSE, depending on if the user is a manager or not.

See: Manager, Superuser, User.

map

Sets the region which the chart will show.

Currently, the following maps are supported:

se_mill - A map of Sweden's counties, with Swedish labels.
world_mill_en - A map of the world's countries, with English labels.

See: Line/Bar chart.

max

Sets the maximum value of the input.

Usage: max=10

See: Numeric text field, Slider.

maxFiles

Sets the maximum number of files that can be uploaded to the input by the current user.

Usage: maxFiles=4

See: File Upload.

min

Sets the minimum value of the input.

Usage: min=-10

See: Numeric text field, Slider.

multiple

Enables multiple selections in a dropdown menu, add multiple to the UI string. The selected values will be concatenated into one semicolon-separated text string. E.g., selecting Sweden and Denmark will result in a value of Sweden;Denmark.

See: Button group, Dropdown list.

Example:

	A	B	C
1	Countries		dropdown;multiple

Copy for Excel Copy for Sheets

This example would create an input titled Countries with no default value. Its UI string is dropdown;multiple, which would instruct Molnify to create a dropdown menu enabled for multiple selections.

To have multiple options selected as default, add JavaScriptAfterLoad to your metadata and set it to $("[cell='Sheet1!B3']").val(["Sweden", "Denmark"]).change(). Exchange Sheet1!B3 for the cell corresponding to your dropdown.

noButtons

Hides the plus and minus buttons that otherwise are shown next to the input.

See: Numeric text field.

NOCALC

Specifies that the input should not be passed along at calculation.

See: Button group, Date-picker, Dropdown-list, File upload, Numeric text field, Signature, Slider, Text area, Text field, Time-picker, Toggle button.

noControls

Hides the grouped/stacked buttons and the series legend buttons in the chart.

See: Bar chart, noGroupedStackedControls.

noGridLines

Hides the grid lines in the chart.

See: Bar chart, Line chart, Line/Bar chart, Scatter chart, Waterfall chart.

noGroupedStackedControls

Hides the grouped/stacked buttons in the chart.

See: Bar chart, noControls.

noWordWrap

Disables word wrapping of the labels for a horizontal bar chart.

See: Bar chart, Waterfall chart.

noTitle

Hides the title of the element, and specifies that it should be shown full width.

See: Button group, Date-picker, Dropdown-list, File upload, HTML panel, Infotext, Long infotext, Numeric text field, Records table, Signature, Slider, Text area, Text field, Time-picker, Toggle button.

panelHidden

Collapses the panel which contains the element.

See: Bar chart, Geo chart, HTML panel, Line chart, Line/Bar chart, People matrix, Pie chart, Scatter chart, Table, Waterfall chart.

peopleMatrix

Specifies that the output should be a people matrix.

See: People matrix.

pieChart

Specifies that the chart should be a pie chart.

See: Pie chart.

placeholder

Shows a grayed text in the input field, intended to guide the user.

Usage: placeholder=This text is helpful.

See: Text area, Text field.

postFix

Adds a short text after the input field.

Usage: postFix=This text is helpful.

See: Numeric text field, Text field.

preFix

Adds a short text before the input field.

Usage: preFix=This text is helpful.

See: Numeric text field, Text field.

recordsTable

Specifies that the input should be a records table.

See: Records table.

regEx

Restricts the possible inputs, so that inputs must not match the specified regular expression.

Usage: regEx=[^a-zA-Z] (restricts input to only accept letters a-z and A-Z.)

See: Numeric text field, Text field.

resetWhenHidden

Resets an input to its default value while it is hidden. On being shown again, the input regains the value it had prior to being hidden.

See: Button group, Date-picker, Dropdown list, Numeric text field, Slider, Text area, Text field, Time picker, Toggle button.

rightColumn

Specifies that a panel should be in the left column.

See: HTML panel, People matrix, Bar chart, Geo chart, Line chart, Line/Bar chart, Pie chart, Scatter chart, Table, Waterfall chart.

rows

Specifies the number of rows of the output matrix.

Usage: rows=4

See: People matrix.

scatterChart

Specifies that the chart should be a scatter chart.

See: Scatter chart.

select

Specifies that the input should be a button group.

See: Button group.

series

Sets options for the specified series of a chart. The series are indexed starting from 0.

The options available are

.color
.showArea
.strokeWidth
.dashedLine

Usage:

series0.color=red
series1.color=#00FF00
series2.color=#FFFF0050
series0.showArea
series0.strokeWidth=4
series0.dashedLine

See: Bar chart, Line chart, Line/Bar chart, Pie chart, Waterfall chart.

seriesInColumns

Specifies that the series used for chart data are ordered in columns.

See: Bar chart, Line chart, Line/Bar chart, Waterfall chart.

seriesInRows

Specifies that the series used for chart data are ordered in rows.

See: Bar chart, Line chart, Line/Bar chart, Waterfall chart.

showIfCell

Try It Download

Hides the associated input or output if the specified cell's value matches the value specified using showIfValue or showIfValueNot.

	A	B	C
1	Name		showIfCell=Sheet1!B3;showIfValue=A

Copy for Excel Copy for Sheets

This would create an input with the title Name. Because of the UI string, showIfCell=Sheet1!B3;showIfValue=A, the input would only be visible when an input or ouput in cell Sheet1!B3 is TRUE.

Usage: showIfCell=cell_address;showIfValue=value_to_match.

See this youtube video for a tutorial on conditionally showing input and output elements in a Molnify app.

showIfVariable

Try It Download

Hides the associated input or output if the specified variable or named range's value matches the value specified using showIfValue or showIfValueNot.

	A	B	C
1	Name		showIfCell=Sheet1!B3;showIfValue=A

Copy for Excel Copy for Sheets

This would create an input with the title Name. Because of the UI string, showIfCell=Sheet1!B3;showIfValue=A, the input would only be visible when an input or ouput in cell Sheet1!B3 is TRUE.

Usage: showIfVariable=variable_name;showIfValue=value_to_match.

See this youtube video for a tutorial on conditionally showing input and output elements in a Molnify app.

showIfValue

Try It Download

Hides the associated input or output if the value of the specified cell (using showIfCell) or variable (using showIfVariable) equals the value specified by this ui-string.

Note that the boolean values for TRUE and FALSE should always be entered in English.

	A	B	C
1	Name		showIfCell=Sheet1!B3;showIfValue=A

Copy for Excel Copy for Sheets

This would create an input with the title Name. Because of the UI string, showIfCell=Sheet1!B3;showIfValue=A, the input would only be visible when an input or ouput in cell Sheet1!B3 is TRUE.

Usage: showIfCell=cell_address;showIfValue=value_to_match.

For more complex conditions, you may use an output box to render, e.g., show or hide. This cell can then be referenced, e.g., showIfCell=Sheet1!B3;showIfValue=show, where Sheet1B3 is the hidden output box. Read more about hidden inputs and outputs.

See this youtube video for a tutorial on conditionally showing input and output elements in a Molnify app.

showIfValueNot

Try It Download

Hides the associated input or output if the value of the specified cell (using showIfCell) or variable (using showIfVariable) does not equal the value specified by this ui-string.

Note that the boolean values for TRUE and FALSE should always be entered in English.

	A	B	C
1	Name		showIfCell=Sheet1!B3;showIfValue=A

Copy for Excel Copy for Sheets

This would create an input with the title Name. Because of the UI string, showIfCell=Sheet1!B3;showIfValue=A, the input would only be visible when an input or ouput in cell Sheet1!B3 is TRUE.

Usage: showIfCell=cell_address;showIfValueNot=value_to_not_match.

See this youtube video for a tutorial on conditionally showing input and output elements in a Molnify app.

showValues

Specifies that data values should be shown directly in the chart.

See: Bar chart, Line/Bar chart, Waterfall chart.

signature

Specifies that the input should be a signature.

See: Signature.

slider

Specifies that the input should be a slider.

See: Slider.

stacked

Renders the chart with bars stacked as default.

See: Bar chart.

staggerLabels

Enables or disables staggering of the x-axis labels. Default behaviour is determined by the number of labels.

Usage: staggerLabels=True

See: Bar chart.

steps

Renders the chart as a step chart.

See: Line chart.

superuser

Specifies that the input cell should contain TRUE or FALSE, depending on if the user is a superuser or not.

See: Superuser, Manager, User.

tab

Try It Download

Renders the input, and all inputs after this, on a new tab with the specified title. Any input defined before the first tab is rendered on all tabs. The title of the currently selected tab will be populated into all input cells where the UI string variable=molnifyCurrentTab is present.

	A	B	C
1	An input		tab=Second tab

Copy for Excel Copy for Sheets

This would create an input field with the title An input. Its UI string, tab=Second tab, tells Molnify to add this input and all following inputs in the tab named Second tab.

A tab is shown and hidden along with the input it is associated with. As such, hiding the associated input with conditional show hides the entire tab.

See: Button group, Date-picker, Dropdown list, File upload, Infotext, Long infotext, Numeric text field, Records table, Signature, Slider, Text area, Text field, Time-picker, Toggle button.

table

Specifies that the data is to be presented as a table.

See: Table.

textarea

Specifies that the input should be a text area.

See: Text area.

time

Specifies that the input should be a time-picker.

See: Time-picker.

user

Specifies that the input cell should be hidden and contain the user's identification. This can either be their email, or their identificationnumber, depending on their method of signing in.

In order to retrieve exactly the user's email or identificationnumber, use user.email or user.identificationnumber, respectively.

See: User, Manager, Superuser.

variable

Assigns a variable name to any associated input or output. By itself, a variable name does serve a function, but it is used by various other functions.

You can initialize inputs by passing parameters in the app's URL. Add a variable name to the inputs you want to initialize. Then append ?variable_name=VALUE to your app URL, e.g., app.molnify.com/app/myForm?firstName=John&lastName=Doe. This would initialize the input with variable name firstName with John and lastName with Doe.

See: addRecord, generateReport, getValueForVariable, EnabledForSave, setValueForVariable, showIfVariable, tab.

waterfallChart

Specifies that the chart should be a waterfall chart.

See: Waterfall chart.

xAxis

Sets the title of the chart's x-axis.

Usage: xAxis=Months

See: Bar chart, Line chart, Line/Bar chart, Scatter chart.

yAxis

Sets the title of the chart's y-axis.

Usage: yAxis=Rate

See: Bar chart, Line chart, Line/Bar chart, Scatter chart.

yAxisTicks

Sets the number of ticks to always display on the chart's y-axis.

Usage: yAxisTicks=3

See: Bar chart, Line chart, Line/Bar chart, Scatter chart.

Actions

Try It Download

If you color a column of cells yellow, you will get an action. An action is a button that the user can click on to execute the specified action. Molnify can perform a wide range of different actions, such as sending emails and adding data to Google Sheets spreadsheets.

Action option: The cells to the left of the yellow cells define the options to apply to the action.
Action option value: The contents of the yellow cells determine the value to apply to the corresponding action option.

Example:

Copy for Excel Copy for Sheets

This example creates an email action, since type is set to email. The action button's title will be Send email. Other options, such as to, from, subject and content, are specified on separate rows.

An action button is shown on all input tabs. In certain cases, you may wish for the button to show on only one tab of inputs. A solution to this is to use hidden to hide the original action button, and then use an HTML panel to create the button such as <a href='javascript:performActionWithName(actionName);' class='btn btn-sm btn-success buttonMargin molnifyActionButton' type='button'>Click me!</a>, where actionName is the name of the action to hide.

Add Record to Database

The add record action stores a "record" or a "snapshot" of the application's variables. The stored record is given a unique ID, which is a non-negative integer. The ID of the saved record is assigned to a variable named recordId, and can be loaded through the URL parameter recordId, e.g. app.molnify.com/app/myApp?recordId=24. You can also access the records from another app by using a records table.

In order for this action to work, you will need to specify the name of the database by using the metadata RecordTableName.

Read more about enabling database connections for your app.

The add record to database action supports the following action options: type (required, addRecord), hidden, name, position, requestHandler, showIfCell, showIfValue, showIfValueNot, skip, successCalculate, successHTMLElementContent, successHTMLElementId, successNewTabURL, successRefreshScenarioList, successSilent, successText, successURL, title.

Add Row to Google Sheets Document

This action creates a button that adds data as a new row to a Google Sheets document. In order for this action to work, you will need to ensure that molnify-librarian@rapidcomputeengine.iam.gserviceaccount.com has write-access to your Google Sheets document.

Use the options id to specify the document's URL, and sheet to specify which sheet to add the row to.

To specify the data to add to the Google Sheets document, add rows to this action with column number and content, e.g.,

1: Content to add in column 1
2: Content to add in column 2
3: Content to add in column 3

For numbers to be correctly treated by Google Sheets, set the locale of your Google Sheets document to United States (File -> Spreadsheet settings... -> Locale: United States).

The add row to Google Sheets action supports the following action options: id (required), type (required, addRow), hidden, name, position, requestHandler, sheet, showIfCell, showIfValue, showIfValueNot, skip, successCalculate, successHTMLElementContent, successHTMLElementId, successNewTabURL, successRefreshScenarioList, successSilent, successText, successURL, title.

Add Row to Database

Use this action to store data in an SQL database.

If this action is present in an app, superusers are able to export all stored data as a spreadsheet alongside with the email and IP address of the user who entered the data, including a timestamp of when the data was saved. Additionally, it is possible to fetch this data via a REST API.

To specify the data to add to the database, add rows to this action with column name (prefixed with a ".") and content, e.g.,

.first_column: Content to add to first_column
.second_column: Content to add in second_column
.third_column: Content to add in third_column

To update a database record, prefix your primary key column with a "k". If any matching record is found it will be updated.

k.primary_key_column: Some contents

Read more about enabling database connections for your app.

The insert row to database action supports the following action options: tableName (required), type (required, insertRow), hidden, name, position, requestHandler, showIfCell, showIfValue, showIfValueNot, skip, successCalculate, successHTMLElementContent, successHTMLElementId, successNewTabURL, successRefreshScenarioList, successSilent, successText, successURL, title.

Download Custom Data

This action enables users to download data in CSV or JSON format, based on a custom query.

Read more about enabling database connections for your app.

The download custom data action supports the following action options: query (required), type (required, downloadQuery), delimiter, format, hidden, name, position, requestHandler, showIfCell, showIfValue, showIfValueNot, skip, successCalculate, successHTMLElementContent, successHTMLElementId, successNewTabURL, successRefreshScenarioList, successSilent, successText, successURL, title.

Download Database Table

This action enables users to download a database table.

Read more about enabling database connections for your app.

The download database table action supports the following action options: tableName (required), type (required, downloadTable), hidden, name, position, requestHandler, showIfCell, showIfValue, showIfValueNot, skip, successCalculate, successHTMLElementContent, successHTMLElementId, successNewTabURL, successRefreshScenarioList, successSilent, successText, successURL, title.

Email

Try It Download

This action creates a button that sends an email.

Example:

Copy for Excel Copy for Sheets

The email action supports the following action options: to (required), type (required, email), content, contenthtml, from, hidden, name, position, requestHandler, showIfCell, showIfValue, showIfValueNot, skip, subject, successCalculate, successHTMLElementContent, successHTMLElementId, successNewTabURL, successRefreshScenarioList, successSilent, successText, successURL, title.

Generate File

This action enables you to generate files from within your app. The generated files may either be PDF or Excel files and are generated and downloaded when the action is executed. This action requires an output file template, which defines the output file.

Copying values. When generating the file, Molnify will copy the contents of any single-cell named ranges into matching single-cell named ranges of the first sheet of the template. E.g. if there are cells in your application sheet named Data1 and NotData1, and there is a named cell on the first sheet in your template file named Data1, then the file generated from the template will have the value from Data1 copied into the template's named cell Data1. But the value of NoteData1 will not be copied, as there is no cell named NoteData1 in the template file.
Additionally, you may use tables to specify values to copy. Molnify will copy the contents of any table from the application sheet into any table on the template's first sheet if the tables have the same name. Note that Google Sheets does not support tables as of April 2024, and so templates using Google Sheets are limited to copying values using named single-cell ranges.

Template. The template can be either an .xlsx-file or a Google spreadsheet. The template may contain images, charts, functions, and any styling you may want.
If your template is an .xlsx-file, name it Template_MyFileName ("MyFileName" can be set to anything you like), and email it to info@molnify.com, and it will be made available.
If your template is in Google Sheets, ensure that molnify-librarian@rapidcomputeengine.iam.gserviceaccount.com is able to read the document.

The generate file action supports the following action options: template (required), type (required, generateFile), fileName, format, hidden, landscape, name, overwriteFormatting, position, protectWorkbook, requestHandler, showIfCell, showIfValue, showIfValueNot, skip, successCalculate, successHTMLElementContent, successHTMLElementId, successNewTabURL, successRefreshScenarioList, successSilent, successText, successURL, title, workbookPassword.

Generate a PDF Report

The generate report action creates a PDF report based on a Mustache HTML template.

The generated report can be sent to an email, by providing to among the UI string options. Other UI-string options corresponding to the Email action, such as content and from are also supported. Include {{urlToReport}} in the content where you want the report URL to be inserted.

Copying values. When generating a report, Molnify will copy any input or output variables to your template. E.g. add variable=myInput to the UI cell of an input in your app, and reference it in your Mustache template using {{inputs.myInput}}.
Additionally, Molnify will copy any named tables to your template.
Elements of your app are referred to in Mustache as follows:

Inputs - referenced by inputs.variableName
Outputs - referenced by outputs.variableName
Charts - referenced by charts.variableName
Named ranges - referenced by namedRanges.name

Template. Email the Mustache HTML template to info@molnify.com. The template's main file must be called index.html.

To view all the data your app provides when running the action, open the Sidebar, and click Debug. Select your Generate Report action from the dropdown menu in the Action section, and click Run Action.

To include charts in your generated PDF, reference them using charts.variableName. This provides the full SVG of the chart. Remember to surround the variable name in your Mustache template with three curly brackets to render the HTML, i.e, {{{charts.myBarChart}}}.

A File Upload input can contain multiple files, which are represented as a value of comma-separated URLs.
If there is only one file, you can reference it as {{myFileUpload}}, to retrieve the file URL.
To iterate over multiple files in a File Upload input, use the {{myFileUpload_array}} property, which provides an array of URLs, e.g., ["https://.../image1.jpg","https://.../image2.jpg"].

To include a signature in your PDF report, follow this guide and use the hidden SVG input in your template. Remember to surround the variable name in your Mustache template with three curly brackets to render the HTML, i.e, {{{inputs.mySignature}}}.

This small example demonstrates a Mustache HTML template with:

A title
An iteration over all inputs in the table named Products (shown in the image above)
An image from a File Upload input

Example:

<html> <body> <h1>{{inputs.title}}</h1> {{#namedRanges.Products}} <p>Quantity: {{Quantity}} {{#Price}}at price: {{Price}}{{/Price}}</p> {{/namedRanges.Products}} <img src="{{inputs.anImage}}" height="400" width="auto" /> </body> </html>

The generate pdf report action supports the following action options: , template (required), type (required, generateReport), content, contenthtml, cssPageSize, fileName, from, hidden, landscape, name, paperSize, position, requestHandler, showIfCell, showIfValue, showIfValueNot, skip, subject, successCalculate, successHTMLElementContent, successHTMLElementId, successNewTabURL, successRefreshScenarioList, successSilent, successText, successURL, suppressDownload, title, to.

Multiple Actions

The multiple action performs several actions in sequence. Note that any options specified for a multiple action will override the options for its component actions while it is performed.

To specify which actions to perform in the sequence, add rows to this action with the name of each action to perform:

1 : The name of the first action to perform.
2 : The name of the second action to perform.
3 : The name of the third action to perform.
... and so on

The multiple action supports the following action options: type (required, multiple), hidden, name, position, requestHandler, showIfCell, showIfValue, showIfValueNot, skip, successCalculate, successHTMLElementContent, successHTMLElementId, successNewTabURL, successRefreshScenarioList, successSilent, successText, successURL, title.

Save Scenario

A scenario is a snapshot of the current state of the app.

This action saves a scenario. If a scenario with the same name already exists, it will be overwritten.

Add an input with the UI string variable=molnifyCurrentScenario to have that input contain the name of the currently selected scenario.

Add an input with the UI string variable=molnifyCurrentScenarioLink to have that input contain a link to the currently selected scenario.

The save scenario action supports the following action options: newName (required), type (required, saveScenario), allowOverwrite, hidden, name, oldName, overwriteCurrentScenario, position, private, requestHandler, showIfCell, showIfValue, showIfValueNot, skip, successCalculate, successHTMLElementContent, successHTMLElementId, successNewTabURL, successRefreshScenarioList, successSilent, successText, successURL, title.

Send an HTTP Request

This action sends an HTTP request to the specified URL. Options for specifying request authorization, method, and payload are available.

The download database table action supports the following action options: type (required, http), url (required), authorizationType, autopayload, hidden, method, name, payload, position, requestHandler, showIfCell, showIfValue, showIfValueNot, skip, successCalculate, successHTMLElementContent, successHTMLElementId, successNewTabURL, successRefreshScenarioList, successSilent, successText, successURL, title, token.

Action options

Molnify supports the following action options.

allowOverwrite

Permit the saved scenario to be overwritten by other users.

The default is FALSE.

Usage: allowOverwrite : TRUE

This action option is supported by the following actions: Save Scenario.

authorizationType

If specified, the header "Authorization" will be send with the value authorizationType + " " + token.

The default value is Bearer.

Usage: authorizationType : Authorization

This action option is supported by the following actions: Send an HTTP Request.

autopayload

Automatically set inputs, outputs or all as the request's payload. This overrides payload.

Usage: autopayload : outputs

This action option is supported by the following actions: Send an HTTP Request.

content

Specifies the contents of the email, as plain-text.

Usage: content : John.

contenthtml

Specifies the contents of the email, as html.

cssPageSize

Specify that page sizes will be interpreted from CSS rather than from other action options.

Usage: cssPageSize : TRUE

This action option is supported by the following actions: Generate File.

delimiter

Specifies the delimiter of the downloaded data, only applicable when format is CSV.

The default delimiter is ;.

Usage: format : JSON

This action option is supported by the following actions: Download Custom Data.

fileName

The name of the output file.

Default is <application ID>-molnify.pdf.

Usage: filename : out.pdf

This action option is supported by the following actions: Generate File.

format

Specifies the format of the downloaded data. Currently, CSV and JSON formats are supported.

The default format is CSV.

Usage: format : JSON

This action option is supported by the following actions: Download Custom Data.

from

Specifies the sender of the email.

Usage: from : John Doe

This action option is supported by the following actions: Email.

hidden

The action button of this action will be hidden.

Usage: hidden : TRUE

This action option is supported by the following actions: Add Record to Database, Add Row to Google Sheets Document, Add Row to Database, Download Custom Data, Download Database Table, Email, Generate File, Generate a PDF Report, Multiple Actions, Save Scenario, Send an HTTP Request.

id

The id or URL of the Google sheet to add the row to.

Usage: id : https://docs.google.com/spreadsheets/d/my_sheet

This action option is supported by the following actions: Add Row to Google Sheets Document.

landscape

Set to TRUE to generate a file in landscape orientation.

Default is FALSE.

Usage: landscape : TRUE

This action option is supported by the following actions: Generate File.

method

Specify whether the URL request's method is GET or POST.

Default is POST

Usage: method : POST

This action option is supported by the following actions: Send an HTTP Request.

name

The action will have this name. The name is generally not visible to the user, but is used to refer to the action from e.g. Multiple Actions.

Usage: name : Foo Bar

newName

Specify the name of the new scenario.

Usage: newName : My_Scenario

This action option is supported by the following actions: Save Scenario.

oldName

If the user has a scenario with the specified name, then the new scenario will overwrite it.

A user may overwrite a scenario of another user if the other user's scenario was created with the allowOverwrite option.

Usage: oldName : my_old_scenario

This action option is supported by the following actions: Save Scenario.

overwriteCurrentScenario

Specify that the currently loaded scenario should be overwritten. If the currently loaded scenario is not enabled for overwrite by other users, then the scenario will be saved under the current user.

The default is FALSE.

Usage: overwriteCurrentScenario : TRUE

This action option is supported by the following actions: Save Scenario.

overwriteFormatting

Set to TRUE to overwrite the format of the template.

Default is TRUE.

Usage: overwriteFormatting : TRUE

This action option is supported by the following actions: Generate File.

paperSize

Specify the size of the paper.

Supported sizes are: A0, A1, A2, A3, A4, A5, A6, Letter (default), Legal, Tabloid, Ledger.

Usage: paperSize : A0

This action option is supported by the following actions: Generate File.

payload

Specify the payload of the URL request.

The default payload is OK.

Usage: payload : '{"foo": "bar"}'

This action option is supported by the following actions: Send an HTTP Request.

position

Specify bottom to display the action button at the bottom of the page. The default position is below all inputs.

Usage: position : bottom

To place an action button among your inputs, for example on a certain tab, you can use an Infotext or HTML Panel to perform the action using performActionWithName. For example, <a href="javascript:performActionWithName('aButton')"><button type="button" class="btn btn-sm btn-success buttonMargin molnifyActionButton">Click this!</button></a> displays a button to click on the action with name "aButton".

private

If set to TRUE, then the scenario cannot be viewed by other users.

The default is TRUE.

Usage: private : FALSE

This action option is supported by the following actions: Save Scenario.

protectWorkbook

Set to TRUE to protect the generated workbook from changes. If workbookPassword has not been set, then anyone can unprotect the generated workbook.

Default is FALSE.

Usage: protectWorkbook : TRUE

This action option is supported by the following actions: Generate File.

query

The MySQL query used to retrieve the data to download.

Usage: query : SELECT * FROM data_myTable

This action option is supported by the following actions: Download Custom Data.

requestHandler

Set this to noModal to hide the modal window that is otherwise shown while the action is being performed.

Usage: requestHandler : noModal

sheet

Specify the name of the sheet in which to add the row.

Usage: sheet : Sheet 1

This action option is supported by the following actions: Add Row to Google Sheets Document.

showIfCell

Specifies the cell to refer to in order to determine whether or not to show the action button. This option requires one of the showIfValue and showIfValueNot options to be set.

Usage:
showIfCell : Sheet1!B1
showIfValue : Val

showIfValue

If the cell specified by the showIfCell option has this value, then the action button will be hidden.

Usage:
showIfCell : Sheet1!B1
showIfValue : Val

showIfValueNot

If the cell specified by the showIfCell option has this value, then the action button will be hidden.

skip

Set to TRUE to disable the action. Commonly used to dynamically skip one or several actions in a multiple action.

Usage: skip : TRUE

subject

Specifies the subject of the email.

Usage: subject : Hello from my app

This action option is supported by the following actions: Email.

successCalculate

Set to TRUE to perform a calculation and update outputs after performing the action.

Usage: successCalculate : TRUE

successHTMLElementContent

Specify the new content of the HTML element to update after performing the action.

Usage:
successHTMLElementId : actionsBtn0
successHTMLElementContent : New text!

successHTMLElementId

Specify the id of the HTML element to update after performing the action.

Usage:
successHTMLElementId : actionsBtn0
successHTMLElementContent : New text!

successNewTabURL

When the action is completed, open a new tab with the specified URL.

Usage: successNewTabURL : app.molnify.com/app/myapp?recordId=10

successRefreshScenarioList

When the action is completed, refresh the list of scenarios.

Usage: successRefreshScenarioList : TRUE

successSilent

Do not show the success modal when an action is completed.

Usage: successSilent : TRUE

successText

Specifies the text content of the modal that is shown when the action is completed.

Usage: successSilent : TRUE

successURL

Redirect the browser to the specified URL when the action is completed.

Usage: successURL : app.molnify.com/myapp?recordId=0

tableName

Specify the name of the database table associated with the action.

Usage: tableName : data_myTable

This action option is supported by the following actions: Add Row to Database, Download Database Table.

template (generateFile)

The name or URL of the template to use to generate the file. Either an xlsx-file or a Google Sheets document can be used as template.

Usage: template : template1.xlsx

This action option is supported by the following actions: Generate File.

template (generateReport)

The name of the Mustache HTML template used to generate the report. The main file of the template must be named index.html.

Usage: template : template-mytemplate

This action option is supported by the following actions: Generate File.

title

Specifies the action's title, which is also the text that is displayed in the action button.

Usage: successURL : app.molnify.com/myapp?recordId=0

to

Specifies the recipient of the email.

Usage: to : recipient@someplace.com

This action option is supported by the following actions: Email.

token

Specify the access token of the URL request.

Usage: token : myaccesstoken123

This action option is supported by the following actions: Send an HTTP Request.

type

Specifies the type of action. See the documentation for specific actions for their corresponding type values.

url

Specify the URL to send the request to.

Usage: url : http://httpbin.org/post

This action option is supported by the following actions: Send an HTTP Request.

workbookPassword

Specify a password for the workbook (if protected).

Usage: workbookPassword : my_password123

This action option is supported by the following actions: Generate File.

Metadata

Metadata cells are colored purple, and define general information about your app, such as the app's name, what users are allowed access the app, and the app's styling. Metadata cells are always key-value pairs, where the left cell is the name of the metadata property, and the right cell is the value to assign to the property.

ActionHandler

You may specify a custom action handler file. An action (and associated button) will then be created. The file needs to implement two functions:

actionHandler(dictionary)
customInit(dictionary)

ActionTitle

Used to specify the title of a custom action handler.

ApiKey

Sets a custom authorization key for the API connection to the app.

Default is an unintelligible string of letters and numbers.

AppleTouchIconURL

Specifies the URL of the icon for iOS devices.

Author

Try It Download

Specifies the app author. The app author is shown in the information menu, in the top-right corner.

Copy for Excel Copy for Sheets

This set of metadata would create an app with the ID myApp, the name My App and set the author to John Doe. Its ID is reflected in the URL of the app. In this case it would be app.molnify.com/app/myApp.

An app author is also shown in the webpage's meta-objects as <meta content="author-name" name="author">, where author-name is the author specified in the metadata.

AutoCalcEnabled

If set to FALSE, automatic calculations are disabled for the app. If an app has disabled automatic calculations, then values in outputs and charts are not dynamically updated. Instead, if inputs have been changed, then a button to perform a calculation is shown below the panel of inputs.

Default is TRUE.

Autofill

Use the metadata option autofill.named_range to populate your app with data from a database table, where named_range is the named range you want to populate with the returned data. Enter your SQL query in the metadata cell to the right. You may then use Excel functions on the returned data.

Copy for Excel Copy for Sheets

Name the range that makes out the table contents (i.e., B2:C3 in this case). Use this reference in your autofill to have the table contents replaced by the data returned from the database table.

Copy for Excel Copy for Sheets

This metadata would run the SQL query (="SELECT * from data_myTable") and populate the named range (data) with the results.

You may set up different autofills for different named ranges. For instance, you may have an output box named count and have an autofill set up like this: autofill.count: ="SELECT count(*) FROM data_myTable" to have the output box show the current number of rows in your database table.

Read more about enabling database connections for your app.

BackgroundImageURL

Specify a background image for the app, by providing an URL.

BodyFont

Specifies the font for the app.

ButtonActiveColor

Specifies color of active (i.e. when clicked on) buttons in the app.

ButtonColor

Specifies color of buttons in the app.

CalculateTitle

Sets the title of the calculate button.

CalcVersion

Use this metadata to suggest that your app should use a particular compute node. Note that the value for this property is, unlike most others, case-sensitive.

Default is PROD.

ChartDownloadBackgroundColor

Sets the background color of charts when the user downloads them as a PNG file, through the button on the chart's panel.

Default is transparent.

ClearClipboardAtCalc

Specifies that the user's clipboard should be cleared each time the calculate button is clicked.

Default is FALSE.

ClearClipboardAtReset

Specifies that the user's clipboard should be cleared each time the app is reset.

Default is FALSE.

CollapseButtonColor

Specifies the color of the "close" buttons in the top-right of each output or charts panel.

CookieConsentPopUp

Molnify stores some cookies (please refer to the Cookie Policy). If you wish to collect cookie consent when users visit your app, set this metadata option to TRUE.

Default is FALSE.

To trigger the cookie consent pop-up at any time, link to your app's URL + ?cookieconsent=popup. E.g., app.molnify.com/app/myApp?cookieconsent=popup.

You may specify a custom cookie consent alert text by adding the following to your JavaScriptAfterLoad: JavaScriptAfterLoad: $("#cookie-consent-modal > .modal-dialog > .modal-content > .modal-body").text("My custom cookie consent text.").

CSS

Specifies custom CSS for the app.

Example: CSS : text { font: 12px sans-serif; }

Most modern web browsers have built-in tools to inspect and find classes and IDs of website elements. You can use these tools to find the ID or class of the element(s) you wish to style with this property.

CopyTitle

Sets the title, i.e. text, of "copy" buttons.

CustomDeleteTooltip

Sets the tooltip of the delete scenario button, shown in the top-right if enabled.

CustomDownloadDataTooltip

Sets the tooltip of the download data button, shown in the top-right if enabled.

CustomInfoTooltip

Sets the tooltip of the app info button, shown in the top-right.

CustomLogOutTooltip

Sets the tooltip of a log-out button to the specified string.

CustomLogOutURL

On logging out of the app with a log-out button, redirect the user to the specified URL.

CustomReferenceTooltip

Sets the tooltip of the app reference button, shown in the top-right if enabled.

CustomResetTooltip

Sets the tooltip of the app reset button, shown in the top-right if enabled.

CustomSaveTooltip

Sets the tooltip of the save scenario button, shown in the top-right if enabled.

CustomUpdateTooltip

Sets the tooltip of the app update button, shown in the top-right if enabled.

CustomPrintTooltip

Sets the tooltip of the print button, shown in the top-right.

DBUsers

If set to TRUE, Molnify will check for users, managers, and superusers in a database table, rather than in the application sheet.

Description

Try It Download

Sets a description of the app. The description is shown in the information menu, in the top-right corner.

EnabledForCalculate

When AutoCalcEnabled is set, a buttom to manually execute calculations is shown. This button is hidden if EnabledForCalculate is set to FALSE.

Default is TRUE.

See also: AutoCalcEnabled, calculateButton.

EnabledForDynamicTitles

By default, Molnify updates the title of an element dynamically. Set this to FALSE to disable this behaviour.

EnabledForLogOut

Shows a button to allow the user to log out of the app and Molnify. The button is shown in the top-right corner of the app.

Default is FALSE.

EnabledForPrint

Set to FALSE to hide the print button for the app.

By default, the print button is shown in the top-right corner of the app.

EnabledForReset

If set to TRUE, a button to reset the app to its initial state is shown in the top-right corner of the app.

EnabledForSameSiteNoneAccessToken

If set to TRUE, enables an app which requires sign-in to be accessed using a SameSite None cookie. This is required for an app to be accessible in an iframe.

Default is FALSE.

EnabledForSave

A scenario is a snapshot of the current state of the app.

Set this metadata to TRUE to show a button to allow the user to save a scenario.

Default is FALSE.

Add an input with the UI string variable=molnifyCurrentScenario to have that input contain the name of the currently selected scenario.
Add an input with the UI string variable=molnifyCurrentScenarioLink to have that input contain a link to the currently selected scenario.

EnabledForUpdate

Ordinarily, only the uploader of an app can update it from its Google Sheets model. If this metadata is set to TRUE, a button to allow a user to cause this update is shown in the top-right corner of the app.

ExpandButtonColor

Specifies the color of the "maximize" buttons in the top-right of each output or charts panel.

HeaderFont

Specifies the font of the header.

Usage: HeaderFont : Arial

HeaderHidden

Hides the header if set to TRUE.

HeaderTextColor

Specifies the color of the header text.

ID

Try It Download

Specifies the app ID. The URL to access any app is of the form app.molnify.com/app/my_id.

If unspecified, the app ID becomes an unintelligible string of letters and numbers. So, it is strongly recommended that you assign an ID to your app as soon as possible.

If you upload an app with the same ID as another one of your apps, then the old app will become updated with the new app.

Copy for Excel Copy for Sheets

InputPanelFixed

Fixes the layout so that the input panel is the only panel on the left, and that scrolls separately from the other panels.

See also: InputPanelSmall, InputPanelTitle.

InputPanelSmall

Reduces the width of the input panel.

Default is FALSE.

See also: InputPanelFixed, InputPanelTitle.

InputPanelTitle

Try It Download

Sets the title of the panel containing the input elements.

See also: InputPanelFixed, InputPanelSmall.

IpRanges

Specifies a comma-separated list of IPv4 ranges which are allowed to access the application.

JavaScript

Adds custom JavaScript code. Functions defined in this cell can be called from other places in your app, e.g. from JSOnChange.

JavaScriptAfterCalc

The javascript specified by this metadata is ran after the app has performed a calculation, i.e. updated its data.

For example, the following will replace the content of an input (referenced as variable myTextInput) with the content of an output box (referenced as variable myOutput):

JavaScriptAfterCalc: setValueForVariable("myTextInput", getValueForVariable("myOutput")).

JavaScriptAfterLoad

The javascript specified by this metadata is ran after the app has finished loading.

LogoURL

Specify the URL of an image to use as the app logo. By default, https://app.molnify.com/assets/img/molnify_logo_green.svg is used as logo.

Alternatively, if no URL has been specified for LogoURL, and the app spreadsheet contains a single image, then the image will be used as the app logo.

Managers

A comma-separated list or range of users that are allowed to view all scenarios and download data added using the add row to database action.

Default is "", i.e. none of the users are managers.

Name

Try It Download

Specifies the app name. Unless overridden, the app name is shown in the upper-left corner of the window, above any inputs, and is used to create the browser's tab's title.

By default, an app's name is "My application".

Copy for Excel Copy for Sheets

OnlyAppNameInPageTitle

Specifies that the title of the web page containing the app should not have the postfix "- Molnify".

Default is FALSE.

OnlyIncludeSheet

Specify a comma-separated list of names of sheets to include.

Default behaviour is to include all sheets.

Molnify never parses a sheet if the value of cell A1 is MolnifyIgnore.

OutputBoxBackgroundColor

Specifies the background color of the output boxes.

OutputBoxPanelHidden

Specifies that the panel containing the output boxes should be collapsed by default.

Default is FALSE.

OutputPanelTitle

Specifies the title of the panel with output boxes.

PanelsFixed

Prevents the user from moving the output and charts panels.

Default is FALSE.

PanelHeaderColor

Try It Download

Specifies the color of the panels' headings.

ParseAllSheets

If set to TRUE, specifies that Molnify should look for inputs, outputs, graphs, actions and metadata in all sheets.

Default behaviour is to assume that all inputs, outputs, graphs, actions and metadata are located on a single sheet.

Molnify never parses a sheet if the value of cell A1 is MolnifyIgnore.

Realms

Sometimes your application is used by multiple of your own customers and you want to split access between certain types of data between the customers. Realms works by adding Realms and specifying which realms you want to use e.g., Alpha,Beta,Gamma. Records and Scenarios can then optionally be accessed and used only within a certain realm. You can have an input populated with the currently selected realm by setting its UI string to currentRealm. The input will not be shown in the app, but its value is accessible by referencing the cell in your spreadsheet.

RecordTableName

Used to specify the name of the table from which to read and write records.

Read more about enabling database connections for your app.

Reference

Try It Download

Creates a reference button in the top right, which shows the specified reference text when clicked on. The intented usage is for in-depth descriptions of the app.

ScenarioNameVariable

Specify a named range or variable which contains the default name when saving a scenario.

ScenarioSavePrivate

Set to TRUE to save scenarios privately by default.

ScenarioSharedUsersCell

Allows sharing the scenario with another user. Specify an input cell, e.g. Sheet1!B10, which contains a comma-separate list of email addresses of users to share the scenario with. Then, any saved scenario becomes available to the specified users, in addition to the user saving the scenario.

The list in the referred-to input cell supports wildcards *, e.g. "*@mydomain.com".

See also: EnabledForSave, Save scenario.

ScenarioTerm

Renames the term for a saved app state from "Scenario" to the specified term, e.g. "Order".

See also: EnabledForSave, Save scenario.

SliderCurrentValueBackgroundColor

Sets the background color of the current value label of sliders.

SliderCurrentValueTextColor

Sets the text color of the current value label of sliders.

SliderMinAndMaxTextColor

Sets the text color of the min- and max-labels of sliders.

SuccessButtonColor

Changes the color of every button of class btn-success.

SuperUsers

A comma-separated list or range of users that have manager privileges, and a more extended access to the application, such as updating it.

Default is "", i.e. none of the users are superusers.

ToggleActiveColor

Specifies the color of active toggle buttons.

TopBannerColor

Try It Download

Sets the color of the top banner.

TopBannerHidden

Hides the top banner if set to TRUE.

TokenAuthentication

If you have token authentication enabled for your app, then you need to use this metadata property to define a few options for your token authentication. The options are set as a semicolon-separated list.

When signing in to an app using token authentication, the URL is: https://app.molnify.com/tokenauthentication/MY_APP_ID?email=name%40domain.com&token=MY_TOKEN.

The available options are:

algorithm: Algorithm name (given to you by Molnify as part of implementation).
salt: Salt (selected by you).
loginPage (optional): Custom login page, if a call to /tokenauthentication/appId fails, instead of the normal Molnify login page.
email (optional): URL parameter name to use instead of 'email'.
token (optional): URL parameter name to use instead of 'token'.

Usage: TokenAuthentication : algorithm=my_algo;salt=my_salt;.

Token authentication sets the metadata EnabledForSameSiteNoneAccessToken to true, due to technical reasons.

See also: EnabledForSave, Save scenario.

Users

A comma-separated list or range of email addresses that are allowed to access the application. Wildcards (*) are supported, e.g. *@mycompany.com.

Default is *@*, i.e. all users are allowed to access to the app.

See also: DBUsers, Managers, SuperUsers.

Version

Try It Download

Specify the version of the app. Note that any app versions that are floating-point numbers are truncated at the first dot (.), i.e. 1.5 becomes 1. The app version is visible in the information menu, in the top-right corner.

Website

Try It Download

Specify the website which the logo should link to. By default, it links to https://www.molnify.com/.

Javascript

Molnify supports any javascript which you are able to run from your web browser's console on the app's page, which includes the following libraries:

jQuery
nvd3

Additionally, Molnify provides some javascript functionality to interact with your application. This section describes those functions.

calculateButton

Call this function to force the app to perform a calculation. Useful e.g. to update data from the database.

Usage: calculateButton(element, showSpinner, clearClipboard), where

element is a button which should be disabled while the calculation is happening
showSpinner is true in order to show a spinner to indicate that the calculation is happening
element is true if the user's clipboard should be cleared

copySVGToTextInput

The default data format for a signature is Base30. To retrieve the SVG code, you need to add a second text input, which can preferably be hidden. In the UI cell of the signature, add jsOnChange=copySVGToTextInput. Ensure that the text input to receive the SVG code is on the next row in the spreadsheet. Once this is set up, you can use the SVG code from the text input in, e.g., HTML panels, to show the actual signature. The example below illustrates how to retrieve the SVG code and display the signature image in an HTML panel.

	A	B	C
1	Sign Here		signature;jsOnChange=copySVGToTextInput
2	SVG		hidden
3	Signature	=B2	html

Copy for Excel Copy for Sheets

extractInputs

Returns an object containing the following useful attributes:

applicationID
changes (an array of changed inputs)
currentRealm (see Realms
dateModified

getValueForCell

Get the value of a specified cell.

Usage: setValueForCell(cell)

getValueForVariable

Get the value of a specified variable.

Usage: setValueForVariable(variable)

performActionWithID

An action, even if hidden, can be called with the performActionWithID function.

performActionWithName

An action, even if hidden, can be called with the performActionWithName function.

performActionWithTitle

An action, even if hidden, can be called with the performActionWithTitle function. Note that the performActionWithTitle performs all actions with corresponding title.

saveSvgAsPng

Save SVG data as a PNG.

setValueForCell

Set the value of a specified cell.

Usage: setValueForCell(cell, value)

setValueForVariable

Set the value of a specified variable.

Usage: setValueForVariable(variable, value)

update

When called, updates the app based on the state of its Google Sheets model. If the current user does not have permission to update the app, refreshes the app instead.

Supported functions

Molnify supports the following Excel- and not-Excel-functions. The usage of a function is the same as the usage of its Excel counterpart. All custom functions are described in the section on custom Excel.

ABS
ACOS
ACOSH
ADDRESS
AND
AREAS
ASIN
ASINH
ATAN
ATAN2
ATANH
AVEDEV
AVERAGE
AVERAGEA
AVERAGEIF (Analysis Toolpak)
AVERAGEIFS (Analysis Toolpak)
BESSELJ (Analysis Toolpak)
BIN2DEC (Analysis Toolpak)
CEILING
CEILING.MATH (Analysis Toolpak)
CEILING.PRECISE (Analysis Toolpak)
CHAR
CHOOSE
CLEAN
CODE
COLUMN
COLUMNS
COMBIN
COMPLEX (Analysis Toolpak)
CONCAT (Analysis Toolpak)
CONCATENATE
CORREL
COS
COSH
COUNT
COUNTA
COUNTBLANK
COUNTIF
COUNTIFS (Analysis Toolpak)
COVAR
COVARIANCE.P (Analysis Toolpak)
COVARIANCE.S (Analysis Toolpak)
CUSTOMSQL (Molnify extension)
DATE
DATEVALUE
DAVERAGE
DAY
DAYS (Analysis Toolpak)
DAYS360
DBLOOKUP (Molnify extension)
DCOUNT
DCOUNTA
DEC2BIN (Analysis Toolpak)
DEC2HEX (Analysis Toolpak)
DEGREES
DELTA (Analysis Toolpak)
DEVSQ
DGET
DMAX
DMIN
DOLLAR
DOLLARDE (Analysis Toolpak)
DOLLARFR (Analysis Toolpak)
DPRODUCT
DSTDEV

DSTDEVP
DSUM
DVAR
DVARP
EDATE (Analysis Toolpak)
EOMONTH (Analysis Toolpak)
ERROR.TYPE
EVEN
EXACT
EXP
FACT
FACTDOUBLE (Analysis Toolpak)
FALSE
FILTERJSON (Molnify extension)
FILTERXML (Molnify extension)
FIND
FIXED
FLOOR
FLOOR.MATH (Analysis Toolpak)
FLOOR.PRECISE (Analysis Toolpak)
FORECAST
FORECAST.LINEAR (Analysis Toolpak)
FREQUENCY
FV
GCD (Analysis Toolpak)
GEOMEAN
HEX2DEC (Analysis Toolpak)
HLOOKUP
HOUR
HYPERLINK
IF
IFERROR (Analysis Toolpak)
IFNA (Analysis Toolpak)
IFS (Analysis Toolpak)
IMAGINARY (Analysis Toolpak)
IMREAL (Analysis Toolpak)
INDEX
INDIRECT
INT
INTERCEPT
IPMT
IRR
ISBLANK
ISERR
ISERROR
ISEVEN (Analysis Toolpak)
ISLOGICAL
ISNA
ISNONTEXT
ISNUMBER
ISODD (Analysis Toolpak)
ISREF
ISTEXT
LARGE
LCM (Analysis Toolpak)
LEFT
LEN
LN
LOG
LOG10
LOOKUP
LOWER
MATCH
MAX
MAXA

MAXIFS (Analysis Toolpak)
MDETERM
MEDIAN
MID
MIN
MINA
MINIFS (Analysis Toolpak)
MINUTE
MINVERSE
MIRR
MMULT
MOD
MODE
MONTH
MROUND (Analysis Toolpak)
NA
NETWORKDAYS (Analysis Toolpak)
NORM.DIST (Analysis Toolpak)
NORM.INV (Analysis Toolpak)
NORM.S.DIST (Analysis Toolpak)
NORM.S.INV (Analysis Toolpak)
NORMDIST
NORMINV
NORMSDIST
NORMSINV
NOT
NOW
NPER
NPV
NUMBERVALUE (Analysis Toolpak)
OCT2DEC (Analysis Toolpak)
ODD
OFFSET
OR
PEARSON
PERCENTILE
PERCENTRANK
PERCENTRANK.EXC (Analysis Toolpak)
PERCENTRANK.INC (Analysis Toolpak)
PI
PMT
POISSON
POISSON.DIST (Analysis Toolpak)
POISSONADVANCED (Molnify extension)
POWER
PPMT
PRODUCT
PROPER
PV
QUOTIENT (Analysis Toolpak)
RADIANS
RAND
RANDBETWEEN (Analysis Toolpak)
RANK
RATE
REPLACE
REPT
RIGHT
ROMAN
ROUND
ROUNDDOWN
ROUNDUP
ROW
ROWS
SEARCH

SECOND
SIGN
SIN
SINGLE (Analysis Toolpak)
SINH
SLOPE
SMALL
SOLVER (Molnify extension)
SOLVERBI (Molnify extension)
SOLVERSTEP (Molnify extension)
SQRT
SQRTPI (Analysis Toolpak)
STANDARDIZE
STDEV
STDEV.P (Analysis Toolpak)
STDEV.S (Analysis Toolpak)
STDEVA
STDEVP
STDEVPA
SUBSTITUTE
SUBTOTAL
SUM
SUMIF
SUMIFS (Analysis Toolpak)
SUMPRODUCT
SUMSQ
SUMX2MY2
SUMX2PY2
SUMXMY2
SWITCH (Analysis Toolpak)
T
T.DIST (Analysis Toolpak)
T.DIST.2T (Analysis Toolpak)
T.DIST.RT (Analysis Toolpak)
TAN
TANH
TDIST
TEXT
TEXTJOIN (Analysis Toolpak)
TIME
TIMEVALUE
TODAY
TRANSPOSE
TREND
TRIM
TRUE
TRUNC
UPPER
VALUE
VAR
VAR.P (Analysis Toolpak)
VAR.S (Analysis Toolpak)
VARA
VARP
VARPA
VLOOKUP
WEEKDAY
WEEKNUM (Analysis Toolpak)
WORKDAY (Analysis Toolpak)
WORKDAY.INTL (Analysis Toolpak)
XLOOKUP (Analysis Toolpak)
XMATCH (Analysis Toolpak)
XMLSERVICE (Molnify extension)
YEAR
YEARFRAC (Analysis Toolpak)

Custom functions and macros

Molnify supports a variety of custom functions and custom Excel macros. They are explained here.

CUSTOMSQL

This feature is depricated. Use autofill instead.

You may run custom, read-only SQL queries in your database table by using the Molnify function CUSTOMSQL().

Note that this function is not available in Excel and will hence report an error in Excel, but work when you upload your application to Molnify.

Read more about enabling database connections for your app.

Usage: CUSTOMSQL("SELECT COUNT(*) FROM mytable WHERE store = 'Stockholm'").

DBLOOKUP

This feature is depricated. Use autofill instead.

Molnify can perform SQL database lookups, the results of which can be used by your Excel functions.

To enable database lookups, you first have to add a macro to your Excel file. This macro also enables you to do database lookups on mock data. So, as you develop your app, you can perform lookups in a sheet locally. Once the app is online, the lookups will be done in your real database. This enables for quick testing in Excel while you're building your app.

There are two main approaches to adding the database lookup macro to your Excel file:

Option 1
1. Download the macro-enabled workbook, dblookup.xlsm, which includes a simple example of a database lookup.
2. Open the file, enabling macros.
3. Modify the file as you like, and upload it as your app.
Option 2
1. Download the actual macro code as a text file, dblookup.txt.
2. Open the downloaded text file and copy the content.
3. Create a new or open an existing Excel file.
4. Open the Visual Basic Editor in Excel. The quickest way is using a keyboard shortcut:
  - Windows: Alt + F11
  - Mac: Fn + Option + F11
5. Paste the copied content.
6. Save and close the Visual Basic Editor.

Read more about enabling database connections for your app.

Usage: =DBLOOKUP(id, id column name, table name, column name), where

id is the value to look for
id column name is the column in which to look for id
table name is the name of the database table (and the mock data sheet in your Excel file)
column name is the column containing the value to be returned

FILTERJSON

The Molnify function FILTERJSON lets you filter out data from a JSON string using the query format JSONPath.

Note that this function is not available in Excel and will hence report an error in Excel, but work when you upload your application to Molnify.

Usage: =FILTERJSON(jsonString; jsonPath), where

jsonString is the JSON string to filter
jsonPath is the JSON filter

Example: =filterJSON(B5;"firstName"), where B5 contains {"firstName": "John"} would give you John.

FILTERXML

The FILTERXML filters data from an XML-formatted string using the query format XPath.

Note that this function is not available in Excel and will hence report an error in Excel, but work when you upload your application to Molnify.

Usage: =FILTERXML(xmlString; xPath), where

xmlString is the XML string to filter
xPath is the XML filter

Example: =FILTERXML(B5;"firstName"), where B5 contains <firstName>John</firstName> would give you John.

POISSONADVANCED

Molnify's interpretations of the POISSON and POISSON.DIST functions are usually good enough, and are optimised to perform quickly. In the case that you need a more exact POISSON function, use the POISSONADVANCED custom function.

Note that this function is not available in Excel and will hence report an error in Excel, but work when you upload your application to Molnify.

Usage: =POISSONADVANCED(x, mean, cumulative), where

x is the number of events
mean is the expected numeric value
cumulative is a boolean to determine if the cumulative probability or the probability mass function should be returned.

Example: =POISSONADVANCED(B5;10;TRUE), where B5 contains 1, would give you John.

SOLVER

SOLVER is a custom Molnify function for goal seeking, using Newton-Rhapson's method.

Note that this function is not available in Excel and will hence report an error in Excel, but work when you upload your application to Molnify.

Usage: =SOLVER(f; v; x; z; zv; step; tolerance) where,

f is a reference (as a string) to the cell that contains the objective/goal function.
v is the value that you want to the objective/goal function to get.
x is a reference (as a string) to the cell that contains the independent variable to vary.
z (optional) is a reference (as a string) to a cell which you can chance the value of before optimization.
zv (optional) is the value which to change z to.
step (optional) defines the step size for the solver.
tolerance (optional) is the tolerance as an absolute measure of deviation from v. Default is 1.

Example: =SOLVER(“Sheet1!H4”; 0; “Sheet1!B4"). This will return the value of B4 (the cell to vary) that will make H4 (the goal function) result in the value 0 (the value to seek for). Let's say H4 has the following function: =B3*7-B4*3+B5 and B3 and B5 are inputs set to 5 and 1. Running SOLVER as defined in this example would result in 12, since 0 = 5*7 - B4*3 + 1 => B4*3 = 36 => B4 is 12.

Example: =SOLVER(“Sheet1!H4”; 0; “Sheet1!B4"; “Sheet1!B6"; 12; 3; 2). This will solve the same function as above, but now move in steps of 3 until the goal function is between -2 and +2 (tolerance of 2). Additionally, it will set Sheet1!B6 to the value 12 before starting the optimization.

Manual step may be used when the goal function e.g., is not differentiable or well behaved.

SOLVERBI

SOLVERBI is a custom Molnify function for goal seeking, using the bisection method. It generally converges slower than Newton-Rhapson's method, but may give better results for your case.

Note that this function is not available in Excel and will hence report an error in Excel, but work when you upload your application to Molnify.

Usage: =SOLVERBI(f; v; x; z; zv; lowerBound; upperBound) where,

f is a reference (as a string) to the cell that contains the objective/goal function

v is the value that you want to the objective/goal function to get

x is a reference (as a string) to the cell that contains the independent variable to vary

z (optional) is a reference (as a string) to a cell which you can chance the value of before optimization.

zv (optional) is the value which to change z to.

lowerBound (optional) is a lower bound on x. Default is -1000.

upperBound (optional) is an upper bound on x. Default is 1000.

The method performs better if you are able to narrow x to a small interval using lowerBound and upperBound.

SOLVERSTEP

SOLVER is a custom Molnify function for goal seeking, using a fixed-step approach. The olver takes a fixed step for x up to maximum number of steps until a boolean function q evaluates to TRUE.

Note that this function is not available in Excel and will hence report an error in Excel, but work when you upload your application to Molnify.

Usage: =SOLVERSTEP(q; TRUE; x; z; zv; stepSize; maxSteps, startingX) where,

q is a reference (as a string) to the cell that contains the objective/goal function
v is the value that you want to the objective/goal function to get
x is a reference (as a string) to the cell that contains the independent variable to vary
z (optional) is a reference (as a string) to a cell which you can chance the value of before optimization.
zv (optional) is the value which to change z to.
stepSize (optional) defines the step size for the solver. Default is 1.
maxSteps (optional) is the maximum number of steps to run the solver for. Default is 200.
startingX (optional) is the initial guess of x. Default is the initial value of the cell x.

XMLSERVICE

The XMLSERVICE function returns data from an URL.

Note that this function is available in some versions of Excel, but not all. If it is not available in your version of Excel, then it will report an error in Excel, but work when you upload your application to Molnify.

Usage: =XMLService(url) where url is the URL of the XML data.