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: 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Autonumber a filtered list
I suppose that the purpose of the "Counter" field in the first record of the "Counters" table is to keep the last value between executions of the script.…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Help with sorting on 4 columns
When numbers formatted as text are sorted, the sorting is indeed performed on the numerical values of the ASCII (or Unicode) codes of the characters representing the digits.…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: If a text field has > 30 '#' then show alert
Another possible approach: item(split(text(Location), ", "), 0). This would fail if the string ", " appears anywhere inside the text of the location, which is not impossible,…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Calculating a time duration over midnight
You can add: timeinterval(86400000). The magical number in the argument is the number of milliseconds in a day.
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Automatically link two tables
You don't explain how the "Pricing" table is organized. Let's suppose that it has two fields: "To" is the last age at wich a price is applicable, and "Price" is the corresponding price.…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Help with sorting on 4 columns
If the numbers are integers, you can also format them with an appropriate number of leading zeroes: format(Value1,"000000000") + format(Value2,"000000000") + format(Value3,…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: 2 choices trigger same action
Datefield2 := if Status = 1 or Status = 2 then Datefield1 else null end;Datefield4 := if Status = 1 or Status = 2 then Datefield3 else null end
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
1
8
9
10
11
12
16
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics