How to enable Javascript

Latest Posts

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,…
- Jose Monteiro
- JGM
- Jose_Monteiro
- 1 yr ago
- 91
- Get help
Re: Entering dates into a date field using only digits (and a slash or hífen) After all, it wasn't as complicated as I initially thought.The following code on the Trigger After Update of "DataTXT" field solves the situation with a few lines.…
- Jose Monteiro
- JGM
- Jose_Monteiro
- 1 yr ago
- Get help
- Reported - view
Re: Entering dates into a date field using only digits (and a slash or hífen) Hello, I tried your suggestion typing 0712 and return. What I get is 7 Jan 2012 and not 07/12/21. If I type only the day, I get the current month and year automatically.…
- Jose Monteiro
- JGM
- Jose_Monteiro
- 1 yr ago
- Get help
- Reported - view
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,…
- Jose Monteiro
- JGM
- Jose_Monteiro
- 1 yr ago
- 4replies
- 351
- 1
- Get help
Re: COMPARAR SI HAY OTRO VALOR IGUAL EN UN CAMPO DE UNA TABLA Em Português:Ou mais simples ainda, é retirar o comando alert();Se depois de digitar um CIF o campo ficar em branco é porque o número entrado é um duplicado.…
- Jose Monteiro
- JGM
- Jose_Monteiro
- 1 yr ago
- Get help
- Reported - view
Re: COMPARAR SI HAY OTRO VALOR IGUAL EN UN CAMPO DE UNA TABLA I wasn't aware of this particular feature of the triggers and buttons.I don't use Ninox on the Cloud but on my Mac.Thanks for the clarification. Another way to solve the problem so that you don't…
- Jose Monteiro
- JGM
- Jose_Monteiro
- 1 yr ago
- Get help
- Reported - view
Re: COMPARAR SI HAY OTRO VALOR IGUAL EN UN CAMPO DE UNA TABLA Hola, Suponiendo que su tabla se llama Tabela3 y el campo CIF, el siguiente código le advierte si ya hay un número igual en la tabla y borra el campo en este caso: let x := CIF;let n :…
- Jose Monteiro
- JGM
- Jose_Monteiro
- 1 yr ago
- Get help
- Reported - view
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?
- Jose Monteiro
- JGM
- Jose_Monteiro
- 1 yr ago
- 106
- Get help
Re: Issues with switch statement sintaxe I'm running Ninox version 3.5.8 I tried to follow your suggestion but couldn't get the parentheses inserted automatically.By the way, if in a case you insert more than one command line without…
- Jose Monteiro
- JGM
- Jose_Monteiro
- 1 yr ago
- Get help
- Reported - view
Re: Issues with switch statement sintaxe Well, it seems that not including the closing parenthesis doesn't always work. So it's best to follow Fabio's advice to enclose a block of code in parentheses.
- Jose Monteiro
- JGM
- Jose_Monteiro
- 1 yr ago
- Get help
- Reported - view
Re: Issues with switch statement sintaxe Looks like we just need the opening parenthesis. At least NINOX does not complain if we don't include the closing parenthesis. The following code worked fine: let x := [1, 2, 3, 4, 5] ;…
- Jose Monteiro
- JGM
- Jose_Monteiro
- 1 yr ago
- Get help
- Reported - view
Re: Issues with switch statement sintaxe Worked fine. Thanks for your help.
- Jose Monteiro
- JGM
- Jose_Monteiro
- 1 yr ago
- Get help
- Reported - view
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] ;…
- Jose Monteiro
- JGM
- Jose_Monteiro
- 1 yr ago
- 7replies
- 410
- Get help
Re: Counting records in a child table and storing the value in a field of a master table Thank you very much for your explanation. You were quite clear.
- Jose Monteiro
- JGM
- Jose_Monteiro
- 1 yr ago
- Get help
- Reported - view
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…
- Jose Monteiro
- JGM
- Jose_Monteiro
- 1 yr ago
- 2replies
- 181
- Get help
languages supported by Ninox - Suggestion
Coudn't you make portuguese one of the Ninox supported Languages? As you probably know portuguese is the 6th most spoken language. More than French, Italian, Japanese, Russian,…
- Jose Monteiro
- JGM
- Jose_Monteiro
- 1 yr ago
- 127
- Learn & Share
Re: Searching again - Using REGEX (Regular Expressions) Hello, I'm very sorry for the late reply.I have been really busy lately with some projects and have not had time to try the proposed solution.Thank you very much for your help Jacques and Sean.
- Jose Monteiro
- JGM
- Jose_Monteiro
- 2 yrs ago
- Get help
- Reported - view
Re: Searching again - Using REGEX (Regular Expressions) xx
- Jose Monteiro
- JGM
- Jose_Monteiro
- 2 yrs ago
- Get help
- Reported - view
Re: Do functions support the use of comments? We can also comment several lines like: "comment line 1comment line 2comment line 3" ; But //, or ///, or /* are a must. When debugging if we need to block more than a few lines of code,…
- Jose Monteiro
- JGM
- Jose_Monteiro
- 2 yrs ago
- Get help
- Reported - view
Re: In For - Where - Do Script - Add a loop @Sean, I never thought this could happen in Forums where people are looking for help.Learning every day. :)Thanks!
- Jose Monteiro
- JGM
- Jose_Monteiro
- 2 yrs ago
- Get help
- Reported - view
Re: In For - Where - Do Script - Add a loop Hello, I am not an expert on Ninox.But you are not saying much about your problem. If you could describe it in more detail, maybe someone could get a better idea of the problem and help you solve it.…
- Jose Monteiro
- JGM
- Jose_Monteiro
- 2 yrs ago
- Get help
- Reported - view
Re: Formula to add 5 days to a date @KS Have you solved the remaining DueDate calculations? I've been thinking of some ways that could solve your problem, including testing holidays, but I haven't tested them yet.…
- Jose Monteiro
- JGM
- Jose_Monteiro
- 3 yrs ago
- Get help
- Reported - view
Re: Formula to add 5 days to a date @KS, It only seems. :) Mconneen is an expert; I'm still learning Ninox. :) What you want makes sense but will not be easy to solve as calculating ChaseDate.…
- Jose Monteiro
- JGM
- Jose_Monteiro
- 3 yrs ago
- Get help
- Reported - view
Re: I'm looking for a way to filter and delete records after import I'm not an expert but I'll do my best. I created a simple table TABLE1 with the following fields:N - type numberName - Type textFlag - Type Yes/Nofilled with the following records:…
- Jose Monteiro
- JGM
- Jose_Monteiro
- 3 yrs ago
- Get help
- Reported - view
Re: In For - Where - Do Script - Add a loop You should use first let number := 1 ;to set number variable and its initial value. then use only number := number + 1 ; For instance the following code:let arr := ["a", "b", "c"];let number := 1;…
- Jose Monteiro
- JGM
- Jose_Monteiro
- 3 yrs ago
- Get help
- Reported - view

1 2 3 Next

Jose Monteiro

Jose_Monteiro

JGM

74
2
0

Joined: 15 Jan 2020

Follow