Skip to main content

Ninox-Documentation

Alain Fontaine

Alain_Fontaine

353
57
2

Joined: 04 Jun 2020

My Posts

Latest Posts

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
- 3 wk 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
- 3 wk 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
- 3 wk 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
- 3 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
- 3 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
- 3 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
- 4 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
- 4 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
- 4 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
- 5 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
- 5 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
- 5 mths ago
- Get help
- Reported - view
Re: How to Sort Localisation fields properly ?
replacex("000" + trim(text(Localisation)),…
- Alain_Fontaine
- 5 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
- 5 mths ago
- 1
- Get help
- Reported - view
Re: How to Sort Localisation fields properly ?
@Julien First question: extractx("000" + trim(text(Localisation)),…
- Alain_Fontaine
- 5 mths ago
- Get help
- Reported - view
Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?
@Jarno Vande Walle Doing so would also imply some kind of selection, which is probably the operation that takes time. Are you working in a client/server context?…
- Alain_Fontaine
- 6 mths ago
- Get help
- Reported - view
Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?
So, if if the children that have been linked to a parent stay linked with the same parent forever, one only needs to take care of the orphans, which should take less time than processing the whole…
- Alain_Fontaine
- 6 mths ago
- Get help
- Reported - view
Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?
May the value of “field” in either table be changed? To say it otherwise, once a child is linked to a parent, can it become necessary to link it to another parent?
- Alain_Fontaine
- 6 mths ago
- Get help
- Reported - view
Re: Subtotals
From the example given, it was clear that a single "Ingredient" can be referenced by several "Activities" depending on a single ticket. What was not clear was if a given "Ingredient" can be used in…
- Alain_Fontaine
- 7 mths ago
- Learn & Share
- Reported - view
Re: Sub-BOMs Cost Managment
I just reinstalled an example database in this thread, which is only one of those one finds when searching for "recursive":…
- Alain_Fontaine
- 7 mths ago
- Get help
- Reported - view
Re: Resolving a bill of materials
While I did not remove the file, it seems that the link somewhat expired. Since it is now possible to store files as annexes to posts, I am adding it here for reference.
Attachment
- Alain_Fontaine
- 7 mths ago
- Get help
- Reported - view
Re: Sub-BOMs Cost Managment
It seems that you are venturing on the rough seas of recursive structures. Searching the forum for “recursive” will return some food for though.
- Alain_Fontaine
- 7 mths ago
- Get help
- Reported - view
Re: Subtotals
I'll try to explain how it works. As a first step, we put the identity of the chosen record from the "Tickets" table in the "focus" variable, since we will need it at several places: let focus :…
- Alain_Fontaine
- 7 mths ago
- 1
- Learn & Share
- Reported - view
Re: Subtotals
Sometimes, after building a solution to a problem, further study reveals that the first try can by streamlined. In this case, a much simpler solution is indeed possible…
Attachment
- Alain_Fontaine
- 8 mths ago
- 1
- Learn & Share
- Reported - view
Re: Subtotals
In the design of a relational database, one creates tables to model some objects in the real world, and then defines links to represent the relations between those objects.…
Attachment
- Alain_Fontaine
- 8 mths ago
- Learn & Share
- Reported - view

1 2 3 4 5 15

Back to top

Ninox-Documentation

Overview

View all topics