Alain Fontaine

Alain_Fontaine

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

My Posts

Latest Posts

Re: copy one record from a table to another table and also and copy/link the existing link to the same client
If “Acc Link” is the name of the N:1 reference field (your image is not visible), then: let xAccLink := “Acc Link” ; i.(“Acc Link” := xAccLink)
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Simple lookup script for returning a price on a table
Mmmmm, the third line is not exactly what I sent, so I am not suprised that it does not work correctly. Anyway, that third line should be replaced by the simpler version below,…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Simple lookup script for returning a price on a table
It would be better to replace the two occurences of “>” by “>=”...
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Simple lookup script for returning a price on a table
Let“s suppose that the table containing the prices is called ”Measures“. The script below is intended to be the ”On click“ item of a button located in another table,…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Duplicate a record and killing related records etc.(oh and jumping to that new record)
After the “duplicate” command, you can address the fields of the new record with the notation: newRecord.field1 := .... newRecord.field2 := ... The openRecord command opens the specified record,…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Trigger YES/NO formula if value already present in DB
Just remove “ > 1”.
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Duplicate a record and killing related records etc.(oh and jumping to that new record)
let newRecord := duplicate(this); openRecord(newRecord)
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Trigger YES/NO formula if value already present in DB
Let“s that your table is named ”myTable“, and that the field containing the phone number is named, well, ”Phone“. A formula to detect if the same number exists would be something like: let zPhone :…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: I need to copy one date field to another but only the first time the source field is populated... how / is this possible?
Would this, as “Trigger on update” of field “Listing Date”, lead to the result you want: if “Original Listing Date” = null then “Original Listing Date” := “Listing Date”end
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Sequential numbering
Something similar has been discussed here:…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Show filtered table records in a view in different table
Altering the quotes seems to be a new vagary here. Go figure...
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Show filtered table records in a view in different table
it seems that you are using the wrong set of quotes, and two different names for the same variable. let schuelerEmail := “E-Mail”;(select Emails)[“Absender Email” = schuelerEmail];
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Multiple Dialog Threads On One Button
Did you try something like: switch text(Choice) docase “A”: ( let Zresp := dialog(“A”, “Option for case A”, [“A1”, “A2”]); alert(“You choose ” + Zresp) )case “B”: ( let Zresp := dialog(“A”,…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Time Interval wrong calculation
If you cannot upload the image, you could just copy and paste the values of the two Date / Time fields involved, and mention the expected result and actual results.
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Triggering Record Creation on another Table
“Trigger on create” in the “items” table indeed: let Zitem := this;for Zclient in select clients do let Zdesc := (create descriptions); Zdesc.(clients := Zclient); Zdesc.(items := Zitem)end
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Time Interval wrong calculation
Could you provide an example showing the values of two Date / Time and their incorrect difference?
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Time Interval wrong calculation
It depends on the result you need: days rounded, complete days, commenced days... In general terms: compute the difference between number() of each value,…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Multiple Dialog Threads On One Button
You don't give an example of code that you tried and that did not work, so it is rather difficult for anyone to propose an improvement... Pie in the sky:…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Time Interval wrong calculation
When saving a Date or a Date/Time, Ninox records the epoch as a number of milliseconds since January 1, 1970, 00:00 UTC, and keeps notice of the current time zone (in iOS,…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Time Interval wrong calculation
Have the dropoff and checkout times been recorded in the same time zone, including the DST status?
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Show Sub-Table IF choice field is equal to... Not working!
Did you try this: Edit fields... ; select the reference field, named by default "iTasks" ; toggle "More options" ; in "Display field only, if:" insert: text('Project Type') = "Implementation".
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Copying data from one table to another with conditions attached
Is a second table really necessary? When importing csv data, you can designate a field as a key. Ninox then automatically does the job of using that key field to find the the corresponding records in…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Expiration date in colour
For more in this subject, see: https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/remaining-to-a-date-and-style-5f68df84468c96426db36c70?post=5f6b718af6b8c07e9cae3def&page=2
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: illusion of Inserting new lines into middle of child table ((invoice/order/quote) lines)
In the "Quotes" table, you should have a reference field (1:N) named "QuoteLines". In the "QuoteLines" table, you should have a reference field (N:1) named "Quotes" (if you did not rename those…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: incrementation
Sorry. The field that should be a "Number" is if course 'Order No.'. Should not write anything before the morning's coffee.
- 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: copy one record from a table to another table and also and copy/link the existing link to the same client

Re: Simple lookup script for returning a price on a table

Re: Simple lookup script for returning a price on a table

Re: Simple lookup script for returning a price on a table

Re: Duplicate a record and killing related records etc.(oh and jumping to that new record)

Re: Trigger YES/NO formula if value already present in DB

Re: Duplicate a record and killing related records etc.(oh and jumping to that new record)

Re: Trigger YES/NO formula if value already present in DB

Re: I need to copy one date field to another but only the first time the source field is populated... how / is this possible?

Re: Sequential numbering

Re: Show filtered table records in a view in different table

Re: Show filtered table records in a view in different table

Re: Multiple Dialog Threads On One Button

Re: Time Interval wrong calculation

Re: Triggering Record Creation on another Table

Re: Time Interval wrong calculation

Re: Time Interval wrong calculation

Re: Multiple Dialog Threads On One Button

Re: Time Interval wrong calculation

Re: Time Interval wrong calculation

Re: Show Sub-Table IF choice field is equal to... Not working!

Re: Copying data from one table to another with conditions attached

Re: Expiration date in colour

Re: illusion of Inserting new lines into middle of child table ((invoice/order/quote) lines)

Re: incrementation

Overview