Contact Sales to request a demo
Request demo
Product
Platforms
Templates
Security
Customer Reviews
Product Updates
Solutions
Success Stories
Partners
Partners
Become Our Partner
Pricing
Support
Help Center
Webinars
Hero Webinar
Manual
Forum
Tutorial Videos
Blog
Contact us
Search
How to enable Javascript
Sign Up
Log in
Support
Forum
Home
Search the community
Home
Learn & Share
Get help
Webinars
Knowledge Base
Latest Activity
Contact Us
Privacy
Home
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
4
replies
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
7
replies
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
2
replies
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
Home
Learn & Share
Get help
Webinars
View all topics
Tags