Jose Monteiro

selecting rows on a table using header column filter

I have a table with a few columns and one named MAG that contains text. Some rows in this column are empty. I want to show in the tabular view of this table only the rows that have the MAG column…

• Answered

Dates before Christ - how to type

Are there practical ways to insert dates before Christ?If you enter negative numbers in dates, they will always be considered positive.For example, if you type 17 JAN -0012 in a date field,…

Entering dates into a date field using only digits (and a slash or hífen)

To enter a date into a date field, as far as I know, it is necessary to use the numeric keypad and the alphabetic keyboard.In the case of a date in DD/MMM/YYYY format,…

Formula fields not appearing in the spreadsheet view

Sometimes formula fields do not appear in spreadsheet view.Even when I click the Show Formula button on a column header and select the formula field to show.Is there any reason for that?

Issues with switch statement sintaxe

I'm running NINOX on a Mac.Trying to understand the syntax of switch statment I wrote the following simple Switch which works fine on the console: let Total := 0 ; let x := [1, 2, 3, 4, 5] ;…

Counting records in a child table and storing the value in a field of a master table

I have 2 tables T1 (master) and T2 (child) with the following fields: T1(COD, TOTAL, T2) - here T2 is the reference field for table T2 T2(QTD, T1) - here T1 is the reference field for table T1 On a…