Alain Fontaine

Alain_Fontaine

Joined: Thu Jun 04 08:38:45 UTC 2020

My Posts

Latest Posts

Re: Creating a dependent Child record. Use of 'this' statement.
Indeed. When creating a reference, Ninox, by default, gives to the field created in each table the name of the other table. I like to rename the fields to avoid any confusion.…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Creating a dependent Child record. Use of 'this' statement.
Two things. This statement: let a := last(select Timesheet where Volunteer = this.Id).'Work Date'; is too complicated. Since there is a reference between the tables, it can be simplified:…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Button Code Help Please
One would think that writing the value "null" into the field would do the trick. Not so: to set a reference to empty, one must put the value "0" into the field.
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Importing fields with carriage returns
In addition to a record separator — usually "Carriage Return", and a field separator — usually the comma, but can be set to something else, the .csv format also includes the concept of a "Text…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: How do I format this field?
If you make the field, for instance, a Combo box, its content is determined by the columns selected in "Edit columns" since it is not a Popup. You can always add a "formula" column,…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: How do I format this field?
"Show as" is indeed a formula field. But it has an effect on the "Popup" "Show as" option only - yep, two "Show as" fields on the same panel. If you select another option,…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Dynamic Multiple Choice Field - How to Programmatically Assign
The fact that numbers() is accepted, but not chosen(), for dynamic multiple choice fields, does not make sense. Oversight? Another peculiarity of the feature: after selecting some options,…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Table Links
It seems that you have created a 1:N relation between "Sites" and "Contacts". By definition of such a relation, a contact can only be in relation with one site,…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: How to access parent record?
Let's say that the subtable is named "Table2". In the context of the parent table, for example in a button, execute: let myId := Id;(create Table2).(Table1 :…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: How to access parent record?
In you are in a subtable, you must have a reference field, whose name is by default identical to the name of the parent table (but you may rename it if you want).…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Dynamic Multiple Choice Field - How to Programmatically Assign
More detailed information about the coding. 1- divide the Ids in groups of four: 1-4, 5-8, 9-12, etc. Note that if some records have been deleted, you will have holes in the Ids actually present,…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Dynamic Multiple Choice Field - How to Programmatically Assign
Is it really random? It seems that the internal representation of a dynamic multiple choice field (as seen with debugValueInfo) is the hexadecimal encoding of a string of bits,…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Do I need a Join Table?
You could send a mail to support@ninox.com, asking to be invited to the "Webinar DE 2021" and "Webinar EN 2021" teams. You will discover a lot of example databases.…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Filtering subtables
Just a hint without analysing the complete database structure. In your formula, what does "Product-shipping-weight" stand for? If it is the name of a field from another table than the one linked by…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: DOB > Age > Child, Adult or Senior
It seems that the proposed formula would not return a value when the age is exactly 65. The third test (Age > 65) is not needed: if the age is not < 65 (second test), it is of course >= 65.
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Field Binding - Global variable in memory (Browser)
The 3.3.0 version of the iPad app has been released a few hours ago. The "Binding" option is available, but I wonder if it is fully baked yet. One can define a field as "Global variable in memory…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Refining a selection to use in a loop.
I don't know if this would help you. Anyway: once you have put a set of records in an array, you can refine the content of the array with the regular restriction syntax.…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Display last 3 records in a table
If the reference to the linked table is called "LinkedTable", and if you need to show the three last records when sorted by a field called "Date", create a view and populate it by putting this script…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: How to relate everything to everything ?
Sorry, it seems that I did not post not the right url. Try this one: https://app.box.com/s/9yf66bccf8m3flpjhdqb6mscfmk4wag8
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: How to relate everything to everything ?
You do indeed need to represent a matrix. You already have a table containing the countries. In order to represent the asymetrical peace/war relations between the countries, a second table is needed.…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: How to relate everything to everything ?
To clarify: do you want to record, for each country, how much it is at peace or at war with each other country? If it is the case, do you expect this relation to be symmetrical or asymmetrical?
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Is it possible to have a filter expression for character count?
Did you try to put: ="marketing manager" into the filter field?
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: If a text field has > 30 '#' then show alert
Do you mean something like: concat(slice(split(text(Location), ", "), 0, 2))
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Autonumber a filtered list
For your field named "Number", there are two options: 1- define it as a true number field. Ninox will store the numbers using its internal way to code numbers (this sentence would be fit for the…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Autonumber a filtered list
"Number" being a text field, the way it sorts is normal. I just happened to explain it in detail in another thread this morning. Either make it a number field,…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view

1 9 10 11 12 13 17

Welcome to the Ninox community

Alain Fontaine

My Posts

Re: Creating a dependent Child record. Use of 'this' statement.

Re: Creating a dependent Child record. Use of 'this' statement.

Re: Button Code Help Please

Re: Importing fields with carriage returns

Re: How do I format this field?

Re: How do I format this field?

Re: Dynamic Multiple Choice Field - How to Programmatically Assign

Re: Table Links

Re: How to access parent record?

Re: How to access parent record?

Re: Dynamic Multiple Choice Field - How to Programmatically Assign

Re: Dynamic Multiple Choice Field - How to Programmatically Assign

Re: Do I need a Join Table?

Re: Filtering subtables

Re: DOB > Age > Child, Adult or Senior

Re: Field Binding - Global variable in memory (Browser)

Re: Refining a selection to use in a loop.

Re: Display last 3 records in a table

Re: How to relate everything to everything ?

Re: How to relate everything to everything ?

Re: How to relate everything to everything ?

Re: Is it possible to have a filter expression for character count?

Re: If a text field has > 30 '#' then show alert

Re: Autonumber a filtered list

Re: Autonumber a filtered list

Overview