Getting number from table

Hello and thank you in advance My Database has tables called Unit Rentals 1 Unit Rentals 2 Unit Rentals 3 i can't extract the number from a table like you can using a substring in a field any advice…

• Answered

gantt as pdf

Hello, We are trying to use ninox for timetables on our buliding sites. Generally they should look like gantt diagrams, with milestones. Does ninox have a pan for getting gantt on layouts and export…

Functions of Buttons

I have a table that has a button and they duplicate one of the sub tables for the next day. need a formula for this button, for duplicating all the data of the main table.…

Select a field with a button

Is there a way to create a function for a button that will end with selecting a field in the current form so that after clicking the button, the user can just start typing the data for the first…

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