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
389
72
2
Joined: Thu Jun 04 08:38:45 UTC 2020
Follow
My Posts
Latest Posts
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
3 days 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
3 days 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
6 days 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
2 wk ago
Get help
Reported - view
Re: Search field doesn’t recognise apostrophe…
Which national keyboard are you using?
Alain Fontaine
Alain_Fontaine
3 wk 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
3 wk 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
1 mth 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
1 mth 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
1 mth 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
1 mth 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
1 mth 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
1 mth 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
1 mth 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
1 mth 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
Alain_Fontaine
1 mth 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
Alain_Fontaine
1 mth 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
Alain_Fontaine
2 mths ago
1
Get help
Reported - view
Re: create options in choice field from variable/loop
Here is variation, with a better separation of the preparation of the dynamic choice field and its actual use. It also corrects a rather stupid error (a "let" in the wrong place…).
Attachment
Alain Fontaine
Alain_Fontaine
2 mths ago
Get help
Reported - view
Re: create options in choice field from variable/loop
@Rafael First question: the script does not delete any records in the "Choices" table. They are kept for later reuse. One should not intervene in the automatic management of that table.…
Alain Fontaine
Alain_Fontaine
2 mths ago
Get help
Reported - view
Re: How to reset a database?
Up to version 3.9, when duplicating a database, there were options to allow the duplication of the records and the files. Setting those options to "No" allowed one to create a virgin database.…
Alain Fontaine
Alain_Fontaine
2 mths ago
Get help
Reported - view
Re: create options in choice field from variable/loop
@Christoph Sander You don’t need that many records, just the minimum number to hold your set of values. Also, you don’t need to delete and create records,…
Attachment
Alain Fontaine
Alain_Fontaine
2 mths ago
Get help
Reported - view
Re: index with regex
Or maybe: length(replacex(<your input string>, "<your regular expression>[^]*", ""))
Alain Fontaine
Alain_Fontaine
2 mths ago
1
Get help
Reported - view
Re: create options in choice field from variable/loop
A Choice (dynamic) field is defined by an array of records. Any way to build an array of records may be used. Of, course, a "select" statement, or the dereferencing of a table reference are obvious…
Alain Fontaine
Alain_Fontaine
2 mths ago
Get help
Reported - view
Re: Regarding the batch write issue.
item(xx, i).('old code' := item(s, i));
Alain Fontaine
Alain_Fontaine
2 mths ago
1
Get help
Reported - view
Re: How to append values to an array
The only known way, as far as I know, to add something to an array, and get an *array* as the result, is to use the "array()" function. The function takes two arrays as arguments,…
Alain Fontaine
Alain_Fontaine
2 mths ago
1
Get help
Reported - view
1
2
3
4
5
16
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics