How to enable Javascript

Scripting and Functions

Show "1" instead UNDEFINED
Good morning everyone, I am writing because I need "Field1" to show the result "1" when the result of the formula is "undefined". Otherwise it must show the correct number, extracted by the formula.…
- thomas
- thomas.4
- updated 15 hrs ago
- 7replies
- 28
- Last replyFred9 hrs ago
- Get help
How to create a unique list of records

Let us say I have a table, Table1, with records that store years in a field called Number. Now I want to create a dynamic Choice field in Table2 that shows the unique years that are in Table1.…
- Fred
- Fred
- 1 mth ago
- 4replies
- 91
- 1
- Last replyFred5 days ago
- Learn & Share
Ninext : Native JavaScript

I start here a new post about the Native JavaScrip to differentiate it from the EvalJS function in which I had previously put it... I discovered one weekago that it was possible to add comments in…
- Jacques TUR
- Jacques_TUR
- 2 mths ago
- 7replies
- 250
- 1
- Last replyJacques TUR7 days ago
- Learn & Share
Third party formula editor?
Hi there. I'm writing more and more complex/longer formulas, and I wonder if there is any third party text editor (like Microsoft Visual Studio Code) that works well for this kind of formulas.…
- Javier Gómez
- Consultant and developer
- Javier
- 2 wk ago
- 6replies
- 70
- Last replyJacques TUR2 wk ago
- Learn & Share
Create records from dynamic multiple choice
Hi guys, I hit a bump trying something new: I have a dynamic multiple choice field called 'Keuze kritieke fases' I have a subtable 'Kritieke fases'. I have a button that I gave following code on…
- Joren Brouillard
- Joren_Brouillard
- 6 mths ago
- 14replies
- 158
- Last replyRafael3 wk ago
- Get help
Special syntax of the for loop
Hello to all, this morning I discovered a new type of use of the for loop. My first exploration leads me to think that it is a possibility to enumerate a JSON structure (complex).…
- Jacques TUR
- Jacques_TUR
- 3 wk ago
- 1reply
- 42
- 2
- Last replyJacques TUR3 wk ago
- Learn & Share
Numeric array variable initialization
Hello there. I'm stuck with a somehow simple problem. I can't create a variable type array and initialize it unless I enter a number. Take a look at this code: let myArray := [];…
- Javier Gómez
- Consultant and developer
- Javier
- 3 wk ago
- 9replies
- 55
- 1
- Last replyJacques TUR3 wk ago
- Get help
Generate QRCode to File or Image field

Following a discussion with @CISOFT Sàrl ,I embedded Sangmin Shim's code in a Ninext function to generate a QRCode on Ninox. The QRCode generates a file on the attached files or in the Image field.…
- Jacques TUR
- Jacques_TUR
- updated 3 wk ago
- 56
- 1
- Learn & Share
add onselect event for view field
In response to @Alain Fontaine & @Fred Christmas wish (https://forum.ninox.com/t/h7hbkmp?r=h7hbvzj), I have added a viewEvent function to Ninext project.…
- Jacques TUR
- Jacques_TUR
- 7 mths ago
- 43replies
- 467
- 4
- Last replyMaurice3 wk ago
- Learn & Share
Now also in German. Explanations and examples of Ninox functions available.
To our community of German speakers : There is now a separate page for each function in our documentation that includes explanations, illustrations, and tips in German.…
- Claudia B. Reschke (Ninox)Ninox
- Product (Senior UX Writer)
- Claudia_b_reschke_ninox
- 4 wk ago
- 1reply
- 48
- Last replyUmberto3 wk ago
- Learn & Share
header in HTTP function response
Hi, Is there a way to get headers values of a "http" function response ? I need to know the value of a specific header in the response sent by an app when I send a http request.
- Dominique DAVID
- Dominique_DAVID
- 1 mth ago
- 21
- Get help
Filter an array based on a Multichoice using another Multichoice

So I was wondering how to filter an array that will keep NId and then compare a basic multichoice with another basic multichoice. If you open the attached DB,…
- Fred
- Fred
- 1 mth ago
- 3replies
- 50
- Last replyFred1 mth ago
- Get help
- Answered
- Answered
Formula with calculation between two different times
I want to make a different text for each hour, and then make the text coloured red when the hour (now) is in between a chosen time. What is wrong with this example? Example: if time(now()) > time(9.…
- Jan Inge Iversen
- Jan_Inge_Iversen
- 1 mth ago
- 6replies
- 78
- Last replyJan Inge Iversen1 mth ago
- Get help
Is it possible to split the Location field to several address formula fields in Ninox?
I want the Location filed to split and copy the address to several fields like Street, ZIP, City etc, is that possible?
- Jan Inge Iversen
- Jan_Inge_Iversen
- 1 mth ago
- 6replies
- 57
- Last replyJan Inge Iversen1 mth ago
- Get help
How to create a field that displays all gigs worked within a range of dates?
I have the following tables Event Details, Staff, and a join called Event_Staff_Join. My payroll person would like to pull a list of staff that have worked any event between a date range.…
- James
- Firefly Team Events
- James.3
- 1 mth ago
- 7replies
- 65
- Last replyRafael1 mth ago
- Get help
Show form of combined select (or array) logic
Hello, I want to show something in a form which is a combination of multiple wheres and conditions. I want the entries from table_A which have no value in the field bakery.…
- Thomas
- Thomas.3
- updated 1 mth ago
- 5replies
- 54
- Last replyFred1 mth ago
- Get help
- Answered
- Answered
Creative community and javascript
Hello everyone, For more than a year I have been exploring the Ninox code to better understand how it works. Initially driven by the lack of documentation and the frustration of some limitations,…
- Jacques TUR
- Jacques_TUR
- updated 8 mths ago
- 9replies
- 521
- 9
- Last replyJacques TUR1 mth ago
- Learn & Share
Fix to resize Console window
I don't know how it all works. I just figured out how to implement the code that Jacques posted here. Thank you very much Jacques. This code can be entered in "Trigger after open",…
- Sean
- Sean
- 2 mths ago
- 2replies
- 55
- Last replySean1 mth ago
- Learn & Share
Newbie Formula Question
I think this is quite basic, but I'm new to all this and still learning! I have a table of contacts and one of the fields is a choice field that lists about 50 or so electoral ridings and I have…
- Carol Austin
- Carol_Austin
- 2 mths ago
- 5replies
- 90
- Last replyCarol Austin2 mths ago
- Get help
- Answered
- Answered
Custom HTML Dashboard
Hello, i was looking to create a custom Dashboard in Ninox to have a clear overview over some important KPIs and also allow controllers to get a quick view at key data.…
- Alex
- aMAZiNgjin
- 3 mths ago
- 35replies
- 424
- 4
- Last replyRafael2 mths ago
- Learn & Share
Script to confirm date-time availability
I'm an "intermediate" MacOS app user, with a database to track short-term house-rentals. I need a script to confirm availability or flag date-time conflicts as I enter new bookings.…
- bflack
- bflack
- 2 mths ago
- 2replies
- 32
- Last replybflack2 mths ago
- Get help
- Answered
- Answered
Button for create a new record which has a connection to a record
I have a table, where in every record, i have a connection of records from a different table showing up. (1:N) when want to get a new record, normally click "+ Neuer Datensatz" at the 1:N,…
- Michael Blechinger
- Michael_Blechinger.1
- 2 mths ago
- 4replies
- 106
- 1
- Last replyMichael Blechinger2 mths ago
- Get help
- Answered
- Answered
Fonts, Colors and Borders
Hello, I uploaded an interactive CSS generator database titled "Theme Helper" in the Webinar EN 2021 team. It is very slow to respond online in the browser,…
- Sean
- Sean
- updated 7 mths ago
- 15replies
- 828
- 1
- Last replySean2 mths ago
- Learn & Share
Ninext loading modules not requested
Hi @Jacques TUR I just saw that my DBs are now loading all modules even when I specify only specific ones. Here is what I have in my formula: var configLoadModules := { badges: true, evalJS: true,…
- Fred
- Fred
- 2 mths ago
- 2replies
- 28
- Last replyFred2 mths ago
- Get help
Put comments in the scripts
I discovered that it is possible to easily metre comments in scripts with a notation that was not documented: #{here I can put any text}#; var y := year('Start date'); var m := month('Start date');…
- Jacques TUR
- Jacques_TUR
- 2 mths ago
- 17replies
- 225
- 4
- Last replyJacques TUR2 mths ago
- Learn & Share

1 2 3 4 Next

Tags

Top contributors

View all members

Recent activity