Skip to main content

Ninox-Documentation

Alain Fontaine

Alain_Fontaine

409
81
2

Joined: 04 Jun 2020

My Posts

Latest Posts

Re: Selecting Product Items based on Product
@John Halls Indeed. The "select" statement is very powerful, but it is by far the most inefficient tool in Ninox. Going on step further, once you have a "Reference" field,…
Attachment
- Alain_Fontaine
- 11 days ago
- Get help
- Reported - view
Re: Selecting Product Items based on Product
@Vermaji No, that’s not the idea. The actual idea is to use the DCF only as a UI element to select the Product Item, but to store the identity of the selected item in a reference field.…
Attachment
- Alain_Fontaine
- 11 days ago
- 1
- Get help
- Reported - view
Re: Selecting Product Items based on Product
@Vermaji if this kind if "defragmentation" really happens, we can hope that the "Reference" fields are updated accordingly, otherwise the whole database would loose its head.…
- Alain_Fontaine
- 11 days ago
- Get help
- Reported - view
Re: Resolving a bill of materials
@John Halls No recursive functions in Ninox, indeed. So, in the example databases I posted in this Topic, I use iterative scripts with explicit stacks. Filemaker has "Table occurences",…
- Alain_Fontaine
- 12 days ago
- Get help
- Reported - view
Re: Table or Sub-Table?
@John Halls yes, this subject has been discussed several times. See for example: https://forum.ninox.com/t/y4hrt5g?r=q6hrnt9
- Alain_Fontaine
- 12 days ago
- Get help
- Reported - view
Re: Resolving a bill of materials
Here is the latest version of the toy database:
Attachment
- Alain_Fontaine
- 12 days ago
- Get help
- Reported - view
Re: Data in the OrderItems table changes on its own
@Alain Fontaine Arguing with oneself can be seen as the sign of a serious mental disorder, but here it goes anyway… Thinking further, I can’t see how such a "defragmentation" could be made to work…
- Alain_Fontaine
- 2 wk ago
- Get help
- Reported - view
Re: Data in the OrderItems table changes on its own
@Vermaji I have done this - I mean making a backup on one machine and loading it on another - and never observed the so-called "defragmentation", where the records are renumbered with consecutive…
- Alain_Fontaine
- 2 wk ago
- Get help
- Reported - view
Re: Button with script to populate table
@John I took the database you uploaded, changed the formula defining the view, and then the formula in the column. Nothing more, nothing less. Version 3.12 for iPad.
- Alain_Fontaine
- 2 wk ago
- Get help
- Reported - view
Re: Button with script to populate table
@John Halls Did you adapt the definition of the column to be displayed ?
- Alain_Fontaine
- 2 wk 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
- 2 wk 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
- 2 wk 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
- 3 wk 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
- 2 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
- 2 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
- 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
- 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
- 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
- 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
- 5 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
- 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
- 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
- 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
- 6 mths ago
- Get help
- Reported - view
Re: Search field doesn’t recognise apostrophe…
Which national keyboard are you using?
- Alain_Fontaine
- 6 mths ago
- Get help
- Reported - view

1 2 3 4 5 17

Back to top

Ninox-Documentation

Overview

View all topics