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,…

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

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!…

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

What3Words

Has anyone used What3Words in any way shape or form with Ninox.

Managing a database

Is there a form I can place on a website that will allow users of the website to search the database for information about a member? If yes, are the individuals using the website considered…

Membership database

I need to write a database for the Guild membership. My question is: If the individual members of the guild can search the database for their information or information about another member are they…

scheduled task

Hi Is there a way to run a script every day at 10 am? I know how to run a script when you open the database, but the DB is not opened every day, and i need a script to run 1 time every day.. Henrik

Auto link to N:2 root table

Hi, I'm doing a table to keep track of the successive persons at a certain Function in companies. Therefore, I have a Company table, linked to a Function table, linked itself to a Contact table.…

Display fields from a linked record

Hi, This is most certainly basic features, but how to display certains fields (i.e. text or picture) from an upper linked/rooted record, directly in the sub record, please ?…

Location database

Hi, Due to privacy laws I have to run my database from an external hard disk. I can make the app run from the HD but the database is placed in the hidden files on my Mac.…