-
urlEncode
To convert a given string into a URL-compliant string based on the ASCII character set This function will convert plain text based on the ASCII character set into a URL-compliant format.…
-
urlDecode
To decode a given string from a URL-compliant format into text This function will convert a string from URL-compliant format into plain text based on the ASCII character set.…
-
url
To convert a value to a link With this function, you can display a formula field as an URL field with an internet button. By clicking the button, the URL will open in your local browser.…
-
upper
To output a string in the upper case This function converts lowercase characters in a text to uppercase. Other characters stay untouched. This can be useful for comparing strings or for correction of…
-
unshareView
To unshare a given view of a given table With this function, you stop sharing a previously shared view.
This function doesn't work in a formula field because it's modifying data.… -
unshareFile
To unshare a given file With this function, you can stop sharing a file. Syntax unshareFile(file) unshareFile(nid, string) Return void Examples unshareFile(myFile) To unshare a given file.…
-
Help needed for dynamic print function
Hi, all! I know this has been asked a million times, but I just can't seem to wrap my head around it. We all know Ninox is not the most user-friendly software ever and the help section is extreeeemly…
- Answered
-
Show two tables in one view
Hi there - has any body tried to do this and how will it be done ? The case is that I have a table for purchases (Danish name "Indkøb") An a table for Sales (Danish "Salg"),…
-
Help with this project
Good morning, could you give me some help with this programming. I am working on a project for a body and paint shop and I got stuck on this part. I have a field called Position, it is a consecutive,…
-
Data capacity reduction
My database has too many pictures and the capacity is too large (the pictures are already limited to small sizes). Is there a way to download, decompress,…
-
Formatierung aus Rich-Textfeld in Dynamisches Drucklayout
Hallo in die Runde, ich habe ein Problem bei der Darstellung eines Rich-Textfeldes in einem dynamischen Drucklayout. im Textfeld habe ich eine Aufzählung mit "Bullet-Points" diese werden jedoch im…
-
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.…