Skip to main content
Ninox-Website
Ninox-Documentation
How to enable Javascript
Sign Up
Log in
Learn and share
Get help
Webinars
Service status
Documentation
All topics
Contact
Privacy
Overview
Profile
Alain Fontaine
Alain_Fontaine
422
87
2
Joined: Thu Jun 04 08:38:45 UTC 2020
Follow
My Posts
Latest Posts
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
Alain_Fontaine
3 wk 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
Alain_Fontaine
4 wk 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
Alain_Fontaine
4 wk 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
Alain_Fontaine
1 mth 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
Alain_Fontaine
1 mth ago
Get help
Reported - view
Re: format phone number after update
replacex(Phone,"^00","+")
Alain Fontaine
Alain_Fontaine
1 mth 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
Alain_Fontaine
2 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
Alain_Fontaine
2 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
Alain_Fontaine
2 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
Alain_Fontaine
2 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
Alain_Fontaine
2 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
Alain_Fontaine
3 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
Alain_Fontaine
3 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
Alain_Fontaine
3 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
Alain_Fontaine
3 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
Alain_Fontaine
3 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
Alain_Fontaine
3 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
Alain_Fontaine
3 mths ago
Get help
Reported - view
Re: Resolving a bill of materials
Here is the latest version of the toy database:
Attachment
Alain Fontaine
Alain_Fontaine
3 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
Alain_Fontaine
3 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
Alain_Fontaine
3 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
Alain_Fontaine
3 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
Alain_Fontaine
3 mths 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
3 mths 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
3 mths ago
Get help
Reported - view
1
2
3
4
5
17
Ninox-Website
Ninox-Documentation
Overview
Learn and share
Get help
Webinars
Service status
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Usage overview
Process monitor
View all topics