Alain Fontaine

Alain_Fontaine

Joined: 04 Jun 2020

My Posts

Latest Posts

Re: Exporting all data
At the top level of a database, when no table is open, you should see an "Export data" option. It allows one to select a table and export all fields - but not the formulas.
- Alain_Fontaine
- 3 wk ago
- Get help
- Reported - view
Re: Is there a more handy way to convert a text with special characters to be safe to be used as a filename?
As far as I know, a regexp engine does not include a general "translate with table" (TRT for veteran IBM programmers), so one must use some kind of iteration.…
- Alain_Fontaine
- 3 wk ago
- 1
- Get help
- Reported - view
Re: How can I calculate which week of the month a specific day falls into in Ninox?
This formula sometimes returns an incorrect result in january or in december. For the record, here is a better one: floor((day(InputDate) + weekday(InputDate - day(InputDate) + 1) + 6) / 7)
- Alain_Fontaine
- 3 mths ago
- Get help
- Reported - view
Re: How can I calculate which week of the month a specific day falls into in Ninox?
@Fred Exactly. The formula I proposed returns "1" for the first date, and "6" for the last one, as expected.
- Alain_Fontaine
- 3 mths ago
- Get help
- Reported - view
Re: How can I calculate which week of the month a specific day falls into in Ninox?
To calculate which week of the month a specific day falls into: week(InputDate) - week(date(year(InputDate), month(InputDate), 1)) + 1
- Alain_Fontaine
- 3 mths ago
- 3
- Get help
- Reported - view
Re: Sort and display all times in order.
@Julian Kirkness The blank row comes from: let times := [text(void)]; This initializes the array with a single element containing an empty string. To produce an empty array,…
- Alain_Fontaine
- 4 mths ago
- 1
- Get help
- Reported - view
Re: format phone number after update
@Valerio There are several ways to make use of this formula: 1- putting it in a formula field; 2- defining a button with the action: Phone := replacex(Phone, "^00", "+");…
- Alain_Fontaine
- 4 mths ago
- Get help
- Reported - view
Re: format phone number after update
replacex(Phone,"^00","+")
- Alain_Fontaine
- 4 mths ago
- Get help
- Reported - view
Re: Formula returning a record causes type mismatch
In such a case, it seems that adding ".Id" on the result of the dererencing of the reference field , but not on the result of the "select" - which already returns a nid,…
- Alain_Fontaine
- 5 mths ago
- Get help
- Reported - view
Re: How to create a column in a view with a sequential row number
The necessity to use a "select" depends on the structure of your database. To add a row counter, in a context where a "select" is unavoidable, I use: let myt := Text;…
- Alain_Fontaine
- 5 mths ago
- 1
- Get help
- Reported - view
Re: adding eg 7 days to a date+time field
Or simply: 'Date + Time' + 7 * 24 * 3600000
- Alain_Fontaine
- 5 mths ago
- Get help
- Reported - view
Re: set values in a child
@John Halls It works with any array of records. Deferencing a 1:N reference field or executing a select instruction are the two most evident ways to produce an array of records.…
- Alain_Fontaine
- 5 mths ago
- Get help
- Reported - view
Re: set values in a child
@John Halls Maybe hard to believe, but you can simply do: if 'open / closed' = 2 then Child.Choice := 1 end
- Alain_Fontaine
- 5 mths ago
- Get help
- Reported - view
Re: Ninox APP update problem
Some additional problems (3.13.3 iOs): • one cannot import an archive. After selecting the archive file, the home screen is displayed again without importing the archive.…
- Alain_Fontaine
- 6 mths ago
- Get help
- Reported - view
Re: how can I make the options in HOME not include the items that have already been selected..
In the "Constraints" option of the "Products" reference field, put "cnt(b.Home) = 0".
- Alain_Fontaine
- 6 mths ago
- 1
- Get help
- Reported - view
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
- 6 mths 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
- 6 mths 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
- 6 mths 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
- 6 mths 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
- 6 mths ago
- Get help
- Reported - view
Re: Resolving a bill of materials
Here is the latest version of the toy database:
Attachment
- Alain_Fontaine
- 6 mths 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
- 6 mths 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
- 6 mths 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
- 6 mths 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
- 6 mths ago
- Get help
- Reported - view

1 2 3 4 5 17

Welcome to the Ninox community

Alain Fontaine

My Posts

Re: Exporting all data

Re: Is there a more handy way to convert a text with special characters to be safe to be used as a filename?

Re: How can I calculate which week of the month a specific day falls into in Ninox?

Re: How can I calculate which week of the month a specific day falls into in Ninox?

Re: How can I calculate which week of the month a specific day falls into in Ninox?

Re: Sort and display all times in order.

Re: format phone number after update

Re: format phone number after update

Re: Formula returning a record causes type mismatch

Re: How to create a column in a view with a sequential row number

Re: adding eg 7 days to a date+time field

Re: set values in a child

Re: set values in a child

Re: Ninox APP update problem

Re: how can I make the options in HOME not include the items that have already been selected..

Re: Selecting Product Items based on Product

Re: Selecting Product Items based on Product

Re: Selecting Product Items based on Product

Re: Resolving a bill of materials

Re: Table or Sub-Table?

Re: Resolving a bill of materials

Re: Data in the OrderItems table changes on its own

Re: Data in the OrderItems table changes on its own

Re: Button with script to populate table

Re: Button with script to populate table

Overview