-
Help to create an alert when exiting a record
Buenos dias, me gustaria poder hacer que al hacer click en la parte izquierda de la pantalla (X) si el campo DNI no esta rellenado me de una alerta, he estado probando con esta formula si esta vacio…
-
Clear Relationship Field
Hi Guys, I have a form with date, time and Location. Location in a Relationship Field (N:1) With my Button I can sent everything directly to the table. After that the fields date and time are cleaned.…
-
Join us November 21st at 12:00pm EST for Tricks, Tips & Shortcuts with a new Template
Join us for Tricks, Tips & Shortcuts with an Open Q&A. We will have a brand new template that everyone has been asking about! Thursday, October 10th at 12pm EDT/ 5pm BST/ 6pm CEST FREE REGISTRATION:…
-
unshareAllViews
To unshare all views of a given table This function will stop sharing all views of a table.
This function doesn't work in a formula field because it's modifying data.… -
unique
To return an array with unique elements Filter out duplicates from one or more arrays to get an array with only unique values. This can be helpful to make sure there are no double entries in your…
-
trim
To remove preceding and following spaces Especially when copying & pasting text from another source, it can happen, that you also “import” spaces that are unwanted.…
-
today
To return the current date (without time) Here you can determine the current date, i.e. the respective day on which the function is executed. Therefore,…
-
timestamp
To convert a given time-related value to a timestamp With this function, you will convert a time-related value to a UTC-based timestamp. If you use a value without time,…
-
timeinterval
To convert a given time-related value to a time interval, i.e. a duration To convert a given time-related value to a time interval, i.e. a duration. If the value is a number,…
-
time
To return the current time With this function, you can return the current time or set a time. You can use this function for calculations with other time-related data types.…
-
text
To convert a value to a string and possibly reflect the format options With this function, you can convert almost any data type at Ninox to a text value.…
-
testx
To check if a text has matches with a given regular expression This function does the same as contains(): it checks a text for the occurrence of a certain string.…
-
teamId
To return the ID of the current workspace This function returns the ID of the workspace you are in. You might need this in your REST API. Syntax teamId() Return string Examples teamId() Result:…
-
tan
To calculate the tangent The function returns the tangent of an angle. Syntax tan(number) Return number Examples tan(x) To calculate the tangent of a number x. tan(1) Result: 1.5574077246549023 tan(1.…
-
tableId
To return the ID of a table With this function, you'll find out the internal identifier of the current table. This ID consists of at least 1 capital letter. It starts with A.…
-
sum
To return the total sum of a number array With the function, you can calculate the mathematical sum of numeric values from an array or a table. For example,…
-
substring
To return a new string out of a given text with a given start and a given end This function extracts a part of a text according to your specifications. You need to provide the start position,…
-
substr
To return a new string out of a given text This function extracts a part of a text according to your specifications. You need to provide the start position,…
-
styled
To convert a given string to a styled object With this function, you can style a formula field with colors (for example the background) but also with an additional icon.…
-
Text
An overview of text-related functions capitalize To capitalize the first letter of each word chosen To return Yes (true) if the given value equals a given selection concat To return all items of an…
-
Array
An overview of the array functions array To create a new array by merging 2 arrays of a similar type avg To return the average of a number array chosen To return Yes (true) if the given value equals…
-
Google Maps
Hi everyone, I need your help. I have managed to integrate a Google Maps into Ninox that reads coordinates from a table and displays them as markers on the map.…
-
Multiplу Choice - Hide / Show Buttons
Hello There are three buttons WhatsApp - Viber - Telegram. I use a select Multiplу Choice field so that I can display only those messengers that I can contact the client through.…
- Answered
-
SUBTABLE SHOW AS "FIELD" can't scroll down when it reach it's limit.
Hi, I am doing the Subtable but when I click Show as "field" It can't scroll down when it reach it's max. It is that a bug or have anyone have anyidea how to fix it? Like a formular field,…
-
Click to url on emailed image within sendEmail
I am send out an email to all my customers on job completion via sendEmail. The button has the following script the in the email body a Google review image is displayed. from (xGoogle) field.…