Checkbook

I want to create a simple checkbook with Colums balance, deposit and debit. Each entry will generate a new balance but that balance relies on the balance from the prior record.…

Absolute

The Ninox manual says, "absolute( x ) calculates the absolute amount of x, that is, x without a sign. Example: absolute( -10 ) = absolute( 10 ) = 10." I'm trying to use "absolute" in a formula and…

How can I create a new field based on an existing field?

I'm trying to create a table with many "choice" fields that have the same choice options. Is there anyway to duplicate a field and then modify it to save duplicating entering all the choice options?…

How to affect a value to a multiple choice field by script?

Hello, I try to remove with an action button my initials of the multiple choice field 'ouvert par 2' of all record where my initials are in 'ouvert par 2', keeping the others initials inchanged...…

Change field colour based on multiple if then else

Dear All, Any idea why the following code results in the error: if 'Current Inventory' > 'Total Count' thenstyled("Inventory is SMALLER", "#ddeeff", "green", "dialog");…

Is Ninox compatible with Catalina and iOS 13?

Will upgrading to Mac OS Catalina and iOS 13 cause problems with Ninox? (I generally prefer to use the apps, as I don't always have an internet connection)

Font OCRB in pdf

Hello, For the invoices I create I have to attach a payment slip with. So far it's beautiful because everything works locally, because the institutions requires us to use the OCRB font for the coding…

Change field colour based on sum

I have the following code: let AA := sum('Seamless QTY on Hand (Bags)') + sum('HELP QTY on Hand (Bags)') + sum('Mt Waverley QTY on Hand (Bags)');if AA < sum('Low Stock Level') and AA > sum('Re-Order…

Deleting records

Is anyone having issues deleting records? Basically confirming delete then nothing happens?

How to add View with other layout elements ?

I don't understand how it works and what I can do? It seem a formula is needed but I can't make it worked. Have you example to show I don't find anything in your manuals. regards

Copy a print pdf layout (ex. a letter) form one table to another

Hi! There is a way to copy print pdf layout to one table to another? Thank you

new update

Please let me know when update of ninox will be comes?

Formula for Total Time

What is the proper syntax for adding two time values together? I have table that contains fields for Status, Timestamp and Duration. Status is a text field,…

Integromat - linked records

Hi all Just a quick one. Setting up some notifications from Ninox to Slack via integromat. If I include a linked record, it pulls the record ID - not the name of the record.…

Sending Email

hello, I' wondering why the simplee Email code just as copied pasted in the manual does not work ; whereas the button of the email fields does work ! The base is in the cloud...…

I have a serious problem

Hi ninox users, I don't have the same data in my cloud database beetween the apps application (mac, ipad, iphone) and the http apps (safari,chrome...). This is the first time I've this problem.…

How can I make myself blue with all the resources??

Chart view not loading

I have 2 bar graph views in one of my forms. One is showing the total monthly sales, the other quarterly. The quartley sales displays immediately without issue.…

Linking between databases

Is the ability to link between databases something we can expect to see in the future? I anticipate our database growing quite a bit, and we have offices around the world.…

How to create an attachment based on a new or update record trigger?

When I use: importFile(this, printAndSaveRecord(this, "myForm"), "form.pdf") with a button, an attachment is added to the current record. However, the same line of code does not work with a new or…

Default name for Printing to PDF

I'd like to have the name already specified when I go to Print a record. Ideally it would be Kelly_Invoice70299, and the number comes from the field "InvNumber".…

Email Alerts

Hi Guys I have been investing fair bit of time in understanding the software and also establishing an app. There is a good support by Ninox which is great.…

pls can i copy table from database to other

pls can i copy table from database to other

Need a field formula that inserts a unique and sequential number?

What is the formula to insert or create a unique and sequential number for a record? I need that number to never change by itself, in other words, a customer's account number never changes and is…