A way to find out where a specific field is referenced anywhere in your tables?

So, one thing that I find would be helpful, is if there was a way to search for everyplace where a field is referenced or another formula is dependent upon in your tables.…

Ninox will not open on my Mac

I installed and reinstalled Ninox and it still won't open. Is there something else I can do to get it working?

show only relevant table columns based on two criteria

Objective Map relevant terms, people, and institutions to respective slides. Hurdles Show appropriate table columns based on source/target language. Hey Ninox Experts, Hey@Fred /@Jacques TUR ,…

Delayed emails

Recently when I send an email using the sendEmail, there is a big delay (upto 24 hours) before the message is actually sent. It used to work fine. Any ideas? I have a public cloud account.

Automatically link record from one table to open record in another table using a button

In Audits Plan I have the field 'Audit Code' and need to open on 'Non Conformity' field the same 'Audit Code' on the 'Non Conformity' table the 'Audio Code' is a N1.

• Answered

This code works erratically sometimes it works and other times it doesn't

This code works erratically sometimes it works and other times it doesn't. delete (select 'Evaluation table'); let myY := year('Evaluation Date'); let myYM := yearmonth('Evaluation Date');…

• Answered

Formula returning specific values depending on multiple choice selection

Hi all, I have a multiple choice field with around 40 options and I would like to set up a formula that returns a certain text depending on the options selected.…

• Answered

Invoice in XML (structured format)

Hi all, Do you have a tip : how to export invoices in XML structured format ?

Type error: i.updateUI is not a function. (In '.updateUI()', 'i.updateUI' is undefined)

Hey, When I add an image (PDF, JPEG or JPG) to the Ninox database I get this message: Type error: i.updateUI is not a function. (In '.updateUI()', 'i.updateUI' is undefined).…

• Answered

Local, iCloud or Public Cloud ?

The ninoxApp() function allows you to determine, for example, whether the database is used from a browser (web) or from the native Ninox app (mac, iPhone, iPad, Android, etc.).…

CALLBACK POST API

Hi, this is an example of api code POST (OPENAPI) to receive information according to the call indicated in the code. Could someone explain to me how to integrate it into Ninox?…

API RESULT

Hello, the result of an API request is this {"data":[{"pec":"test@pec.it","history":[]}],"success":true,"message":"","error":null} I would like only the value test@pec.…

Expression to extract text in a string to the right after a dash character

I need to extract text in strings (product labels) after a dash character. An example string: Pavé Nameplate Necklace - "ADHD". Ideally, the result would be ADHD, but "ADHD" works as well,…

• Answered

Dashboard Help to Compare This Years Data to Last years Data to same date.

So I am in the process of creating an Insights Dashboard. I am needing help in putting together the right syntax to compare this year to present vs last years data to today, but 2023.…

Is it possible to convert Chinese characters into the initials of their corresponding Pinyin using code?

I would like to convert '你好' into 'nh' (the Pinyin for '你好' is 'nihao'). Can this be achieved through code? Thank you for your response.

Error to send Email

let check := dialog(" Audits Report ", " Confirm the sending of this email...> ", ["Do Not Send", "Yes Send"]); if check = "Yes Send" then sendEmail({ from: userEmail(user()), to: "ruben.leal@vepica.…

• Answered

Creating Chart with Multiple Series

I've searched around to see if Ninox supports this, but can't find anything. Can I create multiple series for 1 Ninox line chart?

Edit PDF

After editing a PDF contained in an image-field using the new editor, if you click on the image-field that contains the PDF, Ninox displays the PDF only in the PDF editor.…

Have a Page number on the Print document

Hello :), I'm working on the template for my invoices. Is there a way/ formula do add on the Print document the Page number? I'd like to have on my document:…

Return JSON

Hello, I have this JSON data that is returned from a SQL select statement: {"result":{"recordsets":[[{"status":"Enabled"}]],"recordset":[{"status":"Enabled"}],"output":{},"rowsAffected":…

Optimize this Code is to large

let s1 := if Status = 1 then 1 else 0 end; let s2 := if Status = 2 then 2 else 0 end; let s3 := if Status = 3 then 3 else 0 end; if s1 then let reply := dialog(" 🟢 Audit To History",…

• Answered

Share view no longer works

I have used the "Share view" for a couple of months now and after having worked flawlessly, the link does not work any longer for two particular views. As a result,…

Help with Button that inputs Date into parent record

Chronos is a subtable of Leads. When creating a Chrono, I have made an option that allows a user to push the button to create an "Active Date" that matches with the Date of the Record in the chrono…

Page Break

Hello, In order to keep my invoices tidy, I need to insert a page break. For example if I add more than 10 items on my invoice, my invoice form gets all messed up.…

duplicate table problem

I duplcated a table. Not many fields, maybe 10. I didn't change the field names etc. When I try to open the new table I just get a twisting circle in the middle and cannot stop it.…