Skip to main content

Ninox-Documentation

Alain Fontaine

Alain_Fontaine

422
87
2

Joined: Thu Jun 04 08:38:45 UTC 2020

My Posts

Latest Posts

Re: Field of type JSON
Maybe something like: https://forum.ninox.com/t/g9hrzlf/filling-lines-of-ordersarticles-with-dynamic-multiple-choice-fields-and-cascading-dynamic-choice-fields
- Alain_Fontaine
- 4 mths ago
- Get help
- Reported - view
Re: Questions about loop code...
Maybe a good time to use the fact that "for" loops can automagically build arrays: let sommes := for i from 1 to 12 do sum((select inventory)[format(time, "MM") = i and format(time, "YY") = format(aa.…
- Alain_Fontaine
- 5 mths ago
- Get help
- Reported - view
Re: If condition not working with comparison operators
@Vermaji Your feeling about using "or" is indeed correct, but it applies like this: overdueDays > 0 and not (currentInvoiceStatus = 3 or currentInvoiceStatus = 5) Following the rules of Boole algebra,…
- Alain_Fontaine
- 5 mths ago
- 1
- Get help
- Reported - view
Re: Time to create more work for myself...
Once again, an illustration of the fact that, when designing a database, one should not hesitate to create more tables as soon as they make sense. That is,…
- Alain_Fontaine
- 5 mths ago
- 4
- Learn and share
- Reported - view
Re: Help with code to create non-repeating set of 10 numbers
@Fred Righty so… It is the easiest way known to humanity to produce infinite loops .
- Alain_Fontaine
- 6 mths ago
- 1
- Get help
- Reported - view
Re: Help with code to create non-repeating set of 10 numbers
@Fred According to the definition of the "slice" function, "slice(array,0,0)" produces a slice that starts with the first element, and ends BEFORE the first element, which means an empty array.…
- Alain_Fontaine
- 6 mths ago
- 2
- Get help
- Reported - view
Re: Help with code to create non-repeating set of 10 numbers
let x := slice([0], 0, 0); while length(x) < 10 do let newItem := floor(random() * 10); if not contains(x, newItem) then x := array(x, [newItem]) end end ; debugValueInfo(x)
- Alain_Fontaine
- 6 mths ago
- Get help
- Reported - view
Re: Bulk edit yes/no
@Fred Just one little thing: if you don’t want the field to start with a null value, you can define a default value in the field definition. This will of course only work for the records created…
- Alain_Fontaine
- 8 mths ago
- Get help
- Reported - view
Re: Formula returning specific values depending on multiple choice selection
This toy database contains four possible solutions. The last one is completely different, since the multichoice has been made dynamic. This means that an auxiliary data table is needed.…
Attachment
- Alain_Fontaine
- 9 mths ago
- 1
- Get help
- Reported - view
Re: Formula returning specific values depending on multiple choice selection
There are about 40 primary choices, you said. But how many "X", "Y", etc do you have?
- Alain_Fontaine
- 9 mths ago
- Get help
- Reported - view
Re: Confirm whether all multi-choice in the subtable are selected
In the sample database provided with the question, the multiple choice field is indeed static, not dynamic. In this context, the following formula computes the percentage of options selected.…
- Alain_Fontaine
- 9 mths ago
- 2
- Get help
- Reported - view
Re: Search field doesn’t recognise apostrophe…
I asked so I could reproduce exactly what happens on your side. When entering a title in a "Text" field, to insert a quote, you either swipe down on the "k" key,…
- Alain_Fontaine
- 9 mths ago
- Get help
- Reported - view
Re: Search field doesn’t recognise apostrophe…
Which national keyboard are you using?
- Alain_Fontaine
- 9 mths ago
- Get help
- Reported - view
Re: Find the minimum value in a group of records
The proposed solution works perfectly if there is one winner only. If, by chance, two (or more) suppliers quote the same best price, only one of them will be flagged - the one that happens the get in…
- Alain_Fontaine
- 9 mths ago
- 1
- Get help
- Reported - view
Re: How to use code to edit out unique non-repeating random numbers?
let done := false; let i := randomId(); while not done do if count(select 'Orders' where 'Random letters and numbers' = i) = 0 then 'Order Number' := "H" + i + "B"; done := true else i :…
- Alain_Fontaine
- 9 mths ago
- Get help
- Reported - view
Re: Pop-up field showing wrong columns
This is not new. The subject has been discussed almost three years ago: https://forum.ninox.com/t/60hrt04?r=h7hr7lx
- Alain_Fontaine
- 10 mths ago
- Get help
- Reported - view
Re: How to use code to calculate the number of days in this year or next year?
@我是我的我 I suppose that you mean 365 or 366… let y := year(today()); days(date(y, 1, 1), date(y, 12, 31)) + 1
- Alain_Fontaine
- 10 mths ago
- Get help
- Reported - view
Re: loop in query for view -- how to aggregate?
Arrays of arrays are strange objects in Ninox. They sort of exist, since they can be produced by loops, but they act strangely when one tries to manage them by the usual functions.…
- Alain_Fontaine
- 10 mths ago
- 1
- Get help
- Reported - view
Re: loop in query for view -- how to aggregate?
If you want to see what the script really returns, put it in a formula field, and put the "for" loop inside a "debugValueInfo()" function. You will see that it does not return an array,…
- Alain_Fontaine
- 10 mths ago
- 1
- Get help
- Reported - view
Re: Importing Data into a Dynamic Choice Field
@Dave Irving Here is a bare bones illustrating the process. Since one cannot record a bulk edit, I did include a button that does the operation on the current report.…
Attachment
- Alain_Fontaine
- 10 mths ago
- Get help
- Reported - view
Re: Importing Data into a Dynamic Choice Field
@Dave Irving No, the idea is to create, in the same table containing the dynamic choice, a (temporary) text field, and to import the text values of the choice in this field.…
- Alain_Fontaine
- 10 mths ago
- Get help
- Reported - view
Re: Importing Data into a Dynamic Choice Field
Did you try this: https://forum.ninox.com/t/p8hrznt?r=60hbqxz
- Alain_Fontaine
- 10 mths ago
- Get help
- Reported - view
Re: conditional unique() in column
@Christoph Sander maybe: for f in unique(t.(label + text_c)) do first(t[label + text_c = f]) end order by text_c
- Alain_Fontaine
- 10 mths ago
- 1
- Get help
- Reported - view
Re: conditional unique() in column
Is it not similar to this: https://forum.ninox.com/t/m1y3v59?r=y4yxqwa
- Alain_Fontaine
- 10 mths ago
- Get help
- Reported - view
Re: How to reset a database?
@M_ichel Nice finding, congratulations. I did verify on a rather complex database that everything is as it should be in the empty copy. When I contacted Ninox support to signal that the options had…
- Alain_Fontaine
- 10 mths ago
- 1
- Get help
- Reported - view

1 2 3 4 5 17

Back to top

Ninox-Documentation

Overview

View all topics