Skip to main content
Ninox-Website
Ninox-Documentation
How to enable Javascript
Sign Up
Log in
Learn & Share
Get help
Webinars
All topics
Contact
Privacy
Overview
Profile
Alain Fontaine
Alain_Fontaine
390
72
2
Joined: Thu Jun 04 08:38:45 UTC 2020
Follow
My Posts
Latest Posts
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
Alain_Fontaine
3 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
Alain_Fontaine
3 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
Alain_Fontaine
3 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
Alain_Fontaine
3 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
Alain_Fontaine
3 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
Alain_Fontaine
3 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
Alain_Fontaine
3 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
Alain_Fontaine
3 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
Alain_Fontaine
3 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
Alain_Fontaine
3 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
Alain_Fontaine
3 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
Alain_Fontaine
3 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
Alain_Fontaine
3 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
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: incrementation
Is not the "numcommanda" field defined as a "Text" field? If you need a field to hold numbers, it should be defined as a "Number" field.
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Advice on how to make Field List of Dates
I am sure to fully understand your request, but maybe the concat() function could be a step towards the solution.
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Formula Field for Date Calculation showing time as well
There is a "days()" (with "s") for this very purpose.
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Help with filtering and sum between tables
I suppose that you just replaced the date(...) function by the name of your variable. It does not work because, inside a "select" statement, the context is not the current record of the table you are…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: illusion of Inserting new lines into middle of child table ((invoice/order/quote) lines)
Hint: This: max((select QuoteLines).QLnum) gives the largest value of QLnum in the entire QuiteLines file. This: max(QuoteLines.QLnum) should give the largest value of QLnum among the records linked…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Custom maxId reset after 200
Solutions based on the Ninox Id are robust, since it is guaranteed to be unique and never reused. But if you delete a record, its number is of course lost forever, per the non-reuse.…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Custom maxId reset after 200
It should work in the same place, Trigger on create. Another possibility would be to make "ID Pratica n." a formula field, defined as: let n := number(Id) - 1;1 + n - floor(n / 200) * 200
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Common field in many-to-many relationship
That's why I suggested to put the attribute as a field inside the Bridge table. Nothing prevents you from adding data fields in the Bridge table in addition to the two reference fields,…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Common field in many-to-many relationship
How to set up? Since the "unique attribute" is a characteristic of the relation between the Keyword and the Article, it must be stored as a field in the bridging table.…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Are the numbers of fields limited ?
Just another idea: you can start by moving the last field listed in the right column, and proceed from bottom to top. So, once that last field is in place,…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Custom maxId reset after 200
One option could be to build the needed serial number by using the record reference number, the numeric part of the automatically created record identifier.…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
1
10
11
12
13
14
15
16
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics