-
Issue with creating related record from script
I have a Combox that a user can apply "Tasks" to the Client they are working with and normally that occurs from a Triggered Update within a form in the Clients Table.…
-
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…
-
How to clear/null a reference combo box
I've created a combo box/reference that will allow me to create tasks for a record from a list of selections. The field in the main record "Project" has a combo box called "Tasks to Apply" and when a…
- Answered
-
Two condition nested If not working
I am trying to color a field when days overdue (delta_days) is the below however with the below code, I get either red or green, never Yellow. The second else/if should be skipped when the number for…
- Answered
-
Mutually exclusive choices
Hello forum, I have an extremely basic question. Imagine a list where each item should be assigned one and only one value. In my experience this ought to be the use case for a "radio button",…
- Answered
-
Embedded Vimeo videos
Hello everyone, I'm trying to integrate videos from Vimeo on a Ninox form. The problem is that my videos are limited to specific domains so they can't be seen by anyone.…
-
Customized button
Hello everybody, I added the buttonEvent to Ninext. This allows to dynamically change the caption, the color and the help title of a button. Just add the onUpdate function in the "Display field only,…
-
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.…
