-
parseJSON
To convert a JSON string to a JSON object This function converts a string to a JSON object.
The string needs to be written as a valid JSON object. Otherwise,… -
openURL
To convert a string to a link and open it in the standard web browser With this function, you can open a website in your default browser. You can pass any string,…
-
number
To convert a given value to a number It returns the values of different data types as a number. You can imagine this is needed quite often. The result depends on the data type.…
-
now
To return the current timestamp This function gives you the exact date and time from the exact moment when the function is executed. You are creating an exact timestamp.…
-
ninoxApp
To identify the type of environment that is currently being used This function lets you know in which environment Ninox is currently executed. Your return values could be web (on Ninox cloud) mac (on…
-
monthName
To return the full month name of a given date value This function will display the month’s name. This might be helpful if you want to group dates within a year by month.…
-
monthIndex
To return a given month as a number out of a string With this function you extract the number of the month from a string, for example, March will be 3. This is helpful if the month is only available…
-
month
To return the month from a date value as a number Use this function to return the month from a date value. This will be a number between 1 and 12, with January = 1, February = 2, … December = 12.…
-
min
To return the lowest or earliest value of an array Use this function to find the lowest value or the earliest value in an array.
The function works only with an array of numbers or time-related… -
Text Input Popup
Is there a formula that when a button is clicked, I will get a popup (similar to alert("text") ) to type in my value to copy over to a field? I am trying to insert a comment on a record,…
-
Use Tooltip to echo contents of a field.
Probably for the JS/HTML/CSS geniuses @Jacques TUR :-). I have formula field which fetches a note field contents from another table. Because I have to keep the formula field as small as possible the…
- Answered
-
Tooltip Formula
Need a formula to do something like the image. Click over a Field and give me some information, this is posible. Thanks
-
Tooltip functionality (or lack of)
What can be used as value in a Tooltip? Obviously simple text, but is it possible to use other column data, perhaps modified with some string functions? I tried entering another field,…
-
Refer to a field inside a tooltip @Jacques TUR
@Jacques TUR Is it possible/doable to refer to a field in a tooltip? Cannot be done currently but if it were one could have a kind of trigger. Not sure how well this will work but I am thinking of…
-
Failed to _syncInit message and what to do about it?
Hello, Not sure why but one of my databases on cloud subscription will not open anymore with the error message: Unable to open database syncInit: Failed to _syncInit What has gone wrong and what can…
-
Open a Table using the TableID
Is there a way to open a table using the TableID? Such a simple function, there must be a way to do this.
-
Need Transfer only the last Date.
I'm trying to modify this script so that it only transfer the last of the three Rev Date. In this example it transfers doc with Rev B, not transfer Rev A, or is I have Rev 0 no transfer neither Rev A,…
- Answered
-
RoleGrabber – Tool DB for Cloud Developers
The following text was translated using a translation program. Please excuse this. Here I present a small tool database that is intended to support the documentation and development of cloud…
-
AI and spreadsheets
The AI Spreadsheet We've All Been Waiting For
-
max
To return the highest or latest value of an array Use this function to find the highest value or the latest value in an array.
The function works only with an array of numbers or time-related… -
lpad
To fill up a given length with given padding at the beginning With this function, you fill a text at the beginning, i.e. to the left of the text, with one or more given characters up to the desired…
-
lower
To output a string in lowercase This function converts uppercase characters in a text to lowercase. Other characters stay untouched. This can be useful for comparing strings or for correcting…
-
longitude
To return the longitude of a given location value This function will extract the longitude of an address in a location field as a decimal number. Syntax longitude(location) Return number Examples…
-
log
To calculate the logarithm The function returns the logarithm of a number to a base. If no parameter is specified for the base, it is 10. In the case of 0, the result is -∞ (minus infinity).…
-
location
To return a location value with a given title, latitude, and longitude This function returns a location value based on a given latitude and longitude, which can have a random title.…