Jose Monteiro
-
age(some_date) function not working on Console
age(anydate) works when used on a formula field. But does not work on the console!!! I'm getting the following message: Function is not defined: age([date]) at line 2,…
-
Console window suggestions
Console is an outstanding tool Ninox provides users to test code before inserting it anywhere in the DB. Nevertheless there are a few drawbacks that make it less useful that it could be. 1.…
-
Trigger Before Closing a DB
The Options Panel has a Trigger After Open box that is executed whenever we open a Database. Is there is some kind of Trigger Before Closing that would be executed after clicking on any button to…
-
Console Window Input Panel
Is it possible to resize the Console Window Input Panel? I could't find how.
-
Re: This expression returns a total of Rev-Amount from my Revenue subtable until the "where" portion is inserted. Any idea why?
I'm not a expert by I think: Revenue.'Rev-Amount' returns a list of all values in the Rev-Amount field of the Revenue Table. The builtin sum(...) function returns the sum of whatever list you have in… -
Assign RGB color to a choice field
Hello, I am not able to find how to assign a RGB color to a choice field. After assigng values to the RGB palette (attached file F1), clicking anywhere or pressing Return does not assign the chosen…
-
Global script definitions
Hello, What kind of information, commands, ..., can I use in the Global script definitions? I thought I could define there global variables, etc. I tried to do that,…
-
Table Description field
Hello, Often a Table name is not enough to tell us about a table content. As far as I know there is no place where we could keep some information about a Table.…
-
select not working
The following is not working as expected (I think). (select Table1)[Id < 50].Col2; Table1 is a table with a few records, some with Id less than 50. Col2 is a text field, filled with some text.…