-
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",…
-
writable if - otherwise calculate from another field
Hello, I have a numeric field for a measurement in inches, and a second for a measurement in centimetres. When I enter one I would like it to auto-calculate the other.…
- Answered
-
Different results using Checkbox vs Button to update text field with today() using the exact same code
I was having an issue with dates not storing correctly with some of my code. The code was storing dates as the next day instead of current day. While trying to figure out where my problems were…
-
Renaming part of title attachment
I need to assign the rename function to the button "Manuell Nr zuweisen". By clicking on it, an alert field should come out in which you are asked to enter the number you want with a blank field to…
- Answered
-
parseXML: Assign corresponding elements of same hierarchy level
Hi everyone, I am trying to import an XML file (GAEB, German construction industry format) and I want to create a Ninox table from it. The XML file always has some categories and one category can…
-
Global function to work with out all parameters
Is it possible to have a global function that works with out having all parameters defined? Right now I can't see a way, but I'm just diving into global functions.…
- Answered
-
AWESOME response as always
@Jacques TUR How nice is this. Makes a huge difference....the snapshot speaks for itself!!!
-
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.…
- Answered
-
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.…
-
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…
-
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).…
-
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 := [];…
-
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.…
-
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.
-
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,…
- 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.…
-
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?
-
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.…
-
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.…
- 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,…
-
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…
- Answered
-
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.…
- 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,…
-
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,…
-
Array trouble after update
I have some code that creates 2 arrays of records, which I then combine thus:- array(thoseDirect, thoseDupes) The combined array then gets used in a Dynamic Choice field.…