-
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
-
A new version and no release notes, again.
Just got informed from the Mac App store that there is a new version of Ninox for Mac. It has been upgraded to 3.7.8. But, of course, there is no info about what has changed.…
-
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.…