Welcome to the Ninox community

Running number issue

Hello everyone. I've setup running numbers for our stock, invoices etc. That does work as intended. However, if any previous record is deleted, the next number created will be a duplicate.…

• Answered

If user has email.....

Darn I cannot find/forgot :-(. How does one stipulate that a table can only be opened by a specific email address or name?

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

chartanalyses

Hello - i have different historic data in my database K(n,t) n index of the chart data; t dates and want to analyse them statistically. That means i have to calculate formulas that are depending on…

How to show all fields at once?

It looks like Ninox only shows the first 7 fields that you add to a table, and hides every field after. From here we have to click the view button and drag each and every field one at a time.…

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

How do make a record creation step precompile a table with "Link from?"

I have a table that contains all the replacement parts used on the machines so that when I go to view the machine from the machine log you can see all the replacement parts used on that machine over…

Insert a line break in mailto body

Hi All, I am using an email field where in the body I have alot of IF statements. Below is an example of an IF statement {if 'Is PPC to be included in report' then 'Google Data Studio Link' + " TEST…

How to export whole database

how do I export all fields; when I chose export, only the first few fields are exported; I can't see a way to set it to export all fields