AutoNumber increase when importing records

I have a "Trigger on new record" auto Increasing a number (the trigger I use): 'Cont-ID' := max((select CONTACTS).'Cont-ID') + 1 works fine - except when importing records from a CSV file,…

Combine or add Pdf

would it be possible to combine Pdf file when printing? or add a Pdf file after a file created in Ninox? Thanks

Formula for adding

Hello everyone There are several numbers that need to be added, but the fact is that they need to be added if they differ from a certain amount. For example,…

Accumulated by Staff Problem

I have a Problem on Accumulated by Staff fórmula. Example Marianela have 110 hours (104 normal + 6 overtime) but only sum 104 on the Accumulated by Staff. Some help

• Answered

Auto Number by ComboBox

Hi in my item invoice, I have an auto number and it is good. in the table of "Invoice items," I have one comboBox that I have filed with "Ordered". I need when I choose the "Ordered" auto number to…

Hyperlink in PDF

I am trying to set up in a layout a hyperlink It is defined in an included table column formula. A first result is obtained by simply displaying the content of a URL field: https://drive.google.…

header in HTTP function response

Hi, Is there a way to get headers values of a "http" function response ? I need to know the value of a specific header in the response sent by an app when I send a http request.

multilevel bullet list

Hi, what is the trick to format a multilevel bullet list in a textarea. Just using tab on the keyboard seems not to work to get a second level in a bullet list.…

Create a new record from a table directed to a specific TAB

This script works just fine but I cannot figure out how I can to add a TAB name in the script so the table/form opens to that TAB. The TAB name is INPUT.…

Print Charts?

How can a chart be printed?

ANOTACION EN PDF

Hola, soy nuevo y poco a poco voy creando mi base de control de obras, he visto que la nueva actualización incluye PREVISUALIZACION Y ANOTACIONES EN PDF,…

• Answered

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

Search in formula field

Hi colleagues, I have a table that consists of 3 different text fields (lets say A,B,C). These fields are joint in a separate formula field to show them concatenated, too:…

Locale backup has no data

Hello, when I download a backup and click on import archive locally on my Mac Ninox Database App, the locale backup has no data. Everything else seems to work, but the tables are all empty.

• Answered

Is it possible to split the Location field to several address formula fields in Ninox?

I want the Location filed to split and copy the address to several fields like Street, ZIP, City etc, is that possible?

How to create a field that displays all gigs worked within a range of dates?

I have the following tables Event Details, Staff, and a join called Event_Staff_Join. My payroll person would like to pull a list of staff that have worked any event between a date range.…