Calculating hours from Appointment

I bet there's a better way of doing this: if text(duration(Appointment)) > "2:00" then "More than two hours" else if text(duration(Appointment)) > "1:00" then "Two hours" else if…

Database corrupted - Local database

The local disk was full and iCloud got confused and was trying to upload and download at the same time. After this, Ninox opens with a corrupted database. Only some data showing in tables.…

create a new record in subtable

Hello,I have an invoice table and a sub-table for the invoice items. I'd like with a button to reproduce the same behavior as when I create a new item when I'm on a record of the sub-table.…

Run python script from Ninox

Hi to all. I don't know if running a python sfript from Ninox is not possible and just for fun i asked to the AI. Here's the response: To launch a Python executable from Ninox,…

How to pop up a dialog if a record in a table meets a criteria.

I have a table with three records each with a specific date in a field called next date. I am trying to use the trigger after open function to allow a dialog to pop up when the date in the next date…

attachments: Add from another table

I have a child table in which I have an email button. This is the script: sendEmail({ from: "alan@blah blah", to: EMAIL, cc: " ", bcc: userEmail(), subject: "A new Task has been added for:…

• Answered

Ninext not closing in spite of "True"

Just started happening in the last couple of tries. When I open a database the Ninext loads but the dialog which is set to close (true) does not. Anyone else have this happening? Cheers

• Answered

Rest Api filtering documentation

Hi forum, I'm missing the filter docs? I see examples of how to filter and I get a sense of what is possible. But where is it described? Or am i just not that bright :…

Keyboard shortcut to close a record ?

Hi, Whereas CMD + N creates a new record correctly, the shortcut CMD + W close the whole DB, not only the active record. (I work on a mac). Is there a proper shortcut to do so, please ? Regards

Display a maximum number of data

Hi! I use a formula field to display text data which is itself from another formula field which contacts data. I would like to find a solution to display only the last 5 lines and not all of them as…

• Answered

Forum Notifications Not Occurring When Someone Answers/Replies

I've checked my "My Profile" settings and I have notifications checked, but I never get notified when someone posts a reply. Does that setting refer to something else and there's another forum…

Replace array of items

Is it possible to utilize the replace() function with an array of options to check? Something like: replace('My Text', [ "Hello", "Goodbye", "Welcome" ], "Custom Message")

Stack fields next to Multiline Text?

Is there really no way to stack up fields next to a tall multiline text field? I would really like to stack the Email and two Phone fields. I can stack them next to an Image field,…

Duplicate multiple records to another table

Hi I would like to succeed in creating a button allowing me to transform quotes into invoices. In Ninox, my quotes are built like this: When I create an estimate,…

• Answered

Sending emails - ChatGPT example

Can anyone confirm if this would indeed work in Ninox? I'm guessing not. do you have an example of code for sending emails using Ninox ChatGPT Certainly!…

Avoid spaces in a sum function when a variable is empty/void

Hello, the product name in my products database is a sum of 9 text and number fields, like this article + " " + Color + " " + more stuffs + " " +kg + " " lt" it works for normal use but in print view,…

• Answered

About the side-column width adjustment in the fx window

Hi everyone Any idea to open the width adjustment function for the side-column in the fx window? Current table fields were fine, but if I try to go deep into a few more layers,…

• Answered

Spinning wheels

When I move from table to table, I sometimes get spinning wheels I can go on for 20 for 30 seconds. When I move from table to table, I sometimes get spinning wheels I can go on for 20 or 30 seconds.…

• Answered

Trigger after change

I have a Products table.I would like to add a trigger after the change that:if TOTAL = 0 then AVAIBILTY: = "NO"But this code doesn't work!The AVAIBILITY field becomes NO only if I,…

How To View a subtable from a different Table

Hi There, I have a table (Table 1) where all information is edited (with a sub table). I then have another table (Table 2) that draws the information from Table 1 and puts them in formulae fields so…

Interesting scripting problem?

In a table of employees, I have a dynamic, multiple choice field where managers can select from a list of tasks that the employee is trained to complete.…

• Answered