Alain Fontaine

Alain_Fontaine

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

My Posts

Latest Posts

Re: Get a value from parent table
In a table/subtable relation, the N:1 reference field is in the subtable. So you can fill fields of the subtable with data from the fields of the main table.…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Get a value from parent table
The usual reply is that this kind of script must be placed in the "Trigger after update" option of the reference field, which is only available on the "N:1" side of the relation.
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Accidently turned table into subtable
While defining a reference field, did you set the “Composition” field to “Yes”?
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: if statement
This seems to indicate that there is no record from Table1 linked to the current record in Table2. Did you establish a link, for example by using the magnifying glass associated with the reference…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: if statement
It works as expected in my mockup of your database... Could you, in Table2, create a formula field containing: “debugValueInfo(Table1.Code)” and post the result?
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: if statement
It seems that you established a relation between your tables by creating a reference field. But in what direction? I mean, if, in the fields of Table2, you look at the Reference field named Table1,…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: N:M relation in a view
I am not a professional developer, but a just retired ICT guy having fun with a new toy, and trying to give some help by sharing a few tricks... So, with this new year,…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: N:M relation in a view
There should be only one opening parenthesis between “unique” and “Œuvres”.
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: N:M relation in a view
Strange… I have made a local mockup of your database to test the function, and it works. But it may be that I did not correctly understand the structure of your database.…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Timestamp UTC/GMT - formatted in english
Would you mind sharing the solution? Still eager to learn...
- Alain_Fontaine
- 4 yrs ago
- Learn and share
- Reported - view
Re: Timestamp UTC/GMT - formatted in english
The idea was indeed to adapt to the current offset. Maybe the way it is supposed to work is not valid on the Mac version. You may try this alternative formula: let stamp := now();let offs :…
- Alain_Fontaine
- 4 yrs ago
- Learn and share
- Reported - view
Re: Timestamp UTC/GMT - formatted in english
I have used the following formula to get an UTC timestamp in the iOS App. I don“t know if it works in the Mac OS App. Since it is a timestamp value, it can be formatted to your liking.…
- Alain_Fontaine
- 4 yrs ago
- Learn and share
- Reported - view
Re: Two questions
So, you have a “Locations” table, and references (N:1) to it from the two other tables. Do you have a reference (N:1) from the “Components” table to the “Setups” table? If this is the case,…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Two questions
If you create a reference between the “Components” table and the “Setup” table: 1) when a component is part of a setup, the location attached to the setup will be visible from each component (that“s…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: N:M relation in a view
When looking again at an old question, one often sees new options. So please let me first look back at the last july problem. It will help for solving the new one.…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: N:M relation in a view
Cascading select commands on a single line should better be avoided. Reasoning on the context of each evaluation tends to become intractable. What are the relations between the tables “Invoice”,…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: How to add years to a date based on a choice value field
Let“s suppose that your choices are 1, 2, 3, 5 and 10 years. First define a choice field, with as options the texts you want to have displayed, like for example ”1 year“, ”2 years“, etc.…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Referenced tables
Tap on the header of the table. A dialog will appear where you can select the fields to be displayed. If you want your modifications to hold, you should first tap the wrench in the upper right corner…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: How to add years to a date based on a choice value field
The second script should contain “+ 10”, of course...
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: How to add years to a date based on a choice value field
Another possibilty: since you need to add either five or ten years, you could define two buttons. The code for each button would be: let StartDate := max(MfgDate, FirstUseDate);EndDate :…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: make a field read only
If you need to make a field read-only unconditionally, just put “false” in the “Writable if” option.
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Update multiple records in one table with a record from a referenced table?
Very interesting. I just checked, and this trick also works in an assignation in a script. So a record handle is not required, but just the record reference number suffices.…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Update multiple records in one table with a record from a referenced table?
The purpose of the select command is to get a handle to the desired record in table “Location”. Another solution is to look up the ID of the desired record, and to put in the formula filed:…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Update multiple records in one table with a record from a referenced table?
You can do it with “Update multiple records”. - Select and display the records of table “Item” that must be updated; - “Update multiple records”; - select “Assign calculated value” for the reference…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: How to duplicate a record with reference to the original one?
let me := this; d.(“Link to” := me)
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view

1 12 13 14 15 16 17 18

Welcome to the Ninox community

Alain Fontaine

My Posts

Re: Get a value from parent table

Re: Get a value from parent table

Re: Accidently turned table into subtable

Re: if statement

Re: if statement

Re: if statement

Re: N:M relation in a view

Re: N:M relation in a view

Re: N:M relation in a view

Re: Timestamp UTC/GMT - formatted in english

Re: Timestamp UTC/GMT - formatted in english

Re: Timestamp UTC/GMT - formatted in english

Re: Two questions

Re: Two questions

Re: N:M relation in a view

Re: N:M relation in a view

Re: How to add years to a date based on a choice value field

Re: Referenced tables

Re: How to add years to a date based on a choice value field

Re: How to add years to a date based on a choice value field

Re: make a field read only

Re: Update multiple records in one table with a record from a referenced table?

Re: Update multiple records in one table with a record from a referenced table?

Re: Update multiple records in one table with a record from a referenced table?

Re: How to duplicate a record with reference to the original one?

Overview