Skip to main content
Ninox-Website
Ninox-Documentation
How to enable Javascript
Sign Up
Log in
Learn & Share
Get help
Webinars
All topics
Contact
Privacy
Overview
Profile
Alain Fontaine
Alain_Fontaine
400
80
2
Joined: Thu Jun 04 08:38:45 UTC 2020
Follow
My Posts
Latest Posts
Re: Button with script to populate table
@John Halls Did you adapt the definition of the column to be displayed ?
Alain Fontaine
Alain_Fontaine
7 hrs ago
Get help
Reported - view
Re: Button with script to populate table
Or: unique('5. Classes with Assignment'.'2. Classes'.'3. Students per Class'.'1. Students')
Alain Fontaine
Alain_Fontaine
12 hrs ago
Get help
Reported - view
Re: Field of type JSON
I created a small demo database showing a possible solution. It is not fully polished, of course. There are tables fir the Menu items, for the Units and for the Details,…
Attachment
Alain Fontaine
Alain_Fontaine
4 days ago
Get help
Reported - view
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
Alain_Fontaine
5 days 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
Alain_Fontaine
1 mth 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
Alain_Fontaine
1 mth 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
Alain_Fontaine
2 mths ago
4
Learn & 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
Alain_Fontaine
2 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
Alain_Fontaine
2 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
Alain_Fontaine
2 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
Alain_Fontaine
4 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
Alain_Fontaine
5 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
Alain_Fontaine
5 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
Alain_Fontaine
5 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
Alain_Fontaine
5 mths ago
Get help
Reported - view
Re: Search field doesn’t recognise apostrophe…
Which national keyboard are you using?
Alain Fontaine
Alain_Fontaine
5 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
Alain_Fontaine
5 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
Alain_Fontaine
6 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
Alain_Fontaine
6 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
Alain_Fontaine
6 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
Alain_Fontaine
6 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
Alain_Fontaine
6 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
Alain_Fontaine
6 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
Alain_Fontaine
6 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
Alain_Fontaine
6 mths ago
Get help
Reported - view
1
2
3
4
5
16
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics