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: How to Iteratively Add Items to a New Array
And yet another way to produce a typed empty array: let finalArray := slice([""],0,0);
Alain Fontaine
Alain_Fontaine
3 mths ago
Learn & Share
Reported - view
Re: Account flows
@Erik Ivan Bech Your dabase is (moderately) complex, and seems to contain loads of data. So it is difficult to understand the cause of a subtle problem with just a few screen captures.…
Alain Fontaine
Alain_Fontaine
3 mths ago
Get help
Reported - view
Re: Does the 'page' feaure work on tablet devices?
Same issue on an iPad. Oh, and it is not possible to create an empty copy of a database anymore…
Alain Fontaine
Alain_Fontaine
3 mths ago
Get help
Reported - view
Re: Account flows
@Erik Ivan Bech So the actual data are such that the same ledger can sometimes be viewed more than once. We need to forbid this: let myact := this; unique(Ledger.Journal.Ledger[Accounts != myact])
Alain Fontaine
Alain_Fontaine
3 mths ago
1
Get help
Reported - view
Re: Account flows
@Erik Ivan Bech "Journal.Ledger" returns all the records in table "Ledger" that refers to a record in the table "Journal", which in turn refers to the current record in table "Contacts".…
Alain Fontaine
Alain_Fontaine
3 mths ago
Get help
Reported - view
Re: Account flows
@Erik Ivan Bech Would this give the desired result? let myfin := this; Accounts.Ledger.Journal.Ledger[Accounts.Financials != myfin]
Alain Fontaine
Alain_Fontaine
3 mths ago
Get help
Reported - view
Re: Account flows
What about: let myact := this; Ledger.Journal.Ledger[Accounts != myact]
Alain Fontaine
Alain_Fontaine
3 mths ago
2
Get help
Reported - view
Re: There must be a better way...
@Fred Is it supposed to be a surprise? Using the same technique should give the same kind of result. Try replacing the loop by: let x := Table2[Text != rider and contains(rndJmp, 'Text 2')];
Alain Fontaine
Alain_Fontaine
3 mths ago
Get help
Reported - view
Re: There must be a better way...
@Sean Just the minimum to show the concept…
Attachment
Alain Fontaine
Alain_Fontaine
3 mths ago
Get help
Reported - view
Re: There must be a better way...
I don’t have a copy of your database to fully verify this, but could not: AllResultRecIDs[RiderID != curRider and contains(rndJmp,'Round Type')] replace the explicit loop ?
Alain Fontaine
Alain_Fontaine
3 mths ago
Get help
Reported - view
Re: There must be a better way...
The fact that a "for" loop can magically create an array is very useful in many situations, but sometimes, as in this case, it can not give the desired result.…
Alain Fontaine
Alain_Fontaine
3 mths ago
1
Get help
Reported - view
Re: How to Update in Batch?need your Help.
@我是我的我 This code, placed in a button in "table1", sets the field "选项" to "woman" in all the records of "table3" linked, via "table2", to the current record in "table1".…
Alain Fontaine
Alain_Fontaine
4 mths ago
Get help
Reported - view
Re: How to Update in Batch?need your Help.
If I understand the request correctly, this should do the trick: table2.Table3.('选项' := 1)
Alain Fontaine
Alain_Fontaine
4 mths ago
Get help
Reported - view
Re: Get the hours from an appointment as an Array
let ast := start(Appointment); let aen := endof(Appointment); if day(ast) = day(aen) then range(number(format(ast, "H")), number(format(aen, "H")) + number(format(aen, "m") != "0")) end
Alain Fontaine
Alain_Fontaine
4 mths ago
2
Get help
Reported - view
Re: Join without empty lines
@Sébastien Guillet Since the options are already in an array, just add the filter after the definition of the array: [!=""]
Alain Fontaine
Alain_Fontaine
8 mths ago
Get help
Reported - view
Re: Automated Multiple Choice: Is it possible?
For the record: I did just build a better mousetrap (for the "reset" function): 'Multiple choice' := numbers('Multiple choice')[!= Number] Yet another one-liner!
Alain Fontaine
Alain_Fontaine
8 mths ago
2
Get help
Reported - view
Re: Automated Multiple Choice: Is it possible?
@Ram Vidanes Does this in "Table 3" do what you need: if Choice != null then 'Table1 (Multiple Choice)'.('Progress Status' := array(numbers('Progress Status'), [2])) else 'Table1 (Multiple Choice)'.…
Alain Fontaine
Alain_Fontaine
8 mths ago
1
Get help
Reported - view
Re: Automated Multiple Choice: Is it possible?
To set the option identified by "Number" without touching the state of the other options: 'Multiple choice' := array(numbers('Multiple choice'), [Number]) To clear the option identified by…
Alain Fontaine
Alain_Fontaine
8 mths ago
2
Get help
Reported - view
Re: Avoid spaces in a sum function when a variable is empty/void
Or even simpler: let a := [article,Color,more stuff,kg,lt]; let b:= join(a[!=""]," ")
Alain Fontaine
Alain_Fontaine
8 mths ago
2
Get help
Reported - view
Re: Using a Dynamic multiple choice field to filter a dynamic choice list
While the formula works in most cases, it can lead to false positives in certain cases. For example, if the list of countries includes “Guinea” and “New Guinea”,…
Alain Fontaine
Alain_Fontaine
9 mths ago
1
Get help
Reported - view
Re: Using a Dynamic multiple choice field to filter a dynamic choice list
In this formula: let c := numbers(Country); select tHotels where cnt(numbers(tCountry)[contains(c, this)]) > 0 I supposed that the table “tHotels” contains a DMC field “tCountry” indicating in which…
Alain Fontaine
Alain_Fontaine
9 mths ago
Get help
Reported - view
Re: Dynamic combobox/dropdown list
@Kruna I have zero experience with printing, but I understand that the function is severely rotten. So one should not try to print a DMC field, even if it has been correctly sorted,…
Alain Fontaine
Alain_Fontaine
9 mths ago
Get help
Reported - view
Re: How to Sort Localisation fields properly ?
@Sean One word of caution: on the iOS version, strangely, it works with replacex, but NOT with extractx. Go figure…
Alain Fontaine
Alain_Fontaine
9 mths ago
Get help
Reported - view
Re: How to Sort Localisation fields properly ?
replacex("000" + trim(text(Localisation)),…
Alain Fontaine
Alain_Fontaine
9 mths ago
1
Get help
Reported - view
Re: Dynamic combobox/dropdown list
Another possibility: let t := this; ((select Subcategory)[contains(numbers(t.Category), number(Category))] order by Subcategory) order by Category.Category The trick is to order by the least…
Alain Fontaine
Alain_Fontaine
9 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