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: Use Update Trigger to Chnage the value in Linked Record
In the "Products" table, is the reference to the "Features" table 1:N or N:1?
Alain Fontaine
Alain_Fontaine
2 yrs ago
Get help
Reported - view
Re: Round to nearest $5?
Maybe a formula like: round(Number / 5) * 5
Alain Fontaine
Alain_Fontaine
2 yrs ago
Get help
Reported - view
Re: Automatic record creation
Since Table2 is a subtable of Table1, there is no need to use a Select statement to find the records of Table2 linked to the current record of Table1. You can simply peruse the existing relation.…
Alain Fontaine
Alain_Fontaine
2 yrs ago
Get help
Reported - view
Re: Odd Database behavior
I would say that using "this" directly is not really disallowed, but that it is generally useless. "this" represents the record that is current in the active context.…
Alain Fontaine
Alain_Fontaine
2 yrs ago
Get help
Reported - view
Re: Link record n:1
The original script can also be reduced to: let myID := Id;(create SecondTable).(FirstTable := myID) Now, if some fields of the newly created record must receive a value,…
Alain Fontaine
Alain_Fontaine
2 yrs ago
Get help
Reported - view
Re: Link record n:1
I have an immoderate love for one-liners: FirstTable := (create FirstTable) If there is already a linked record, it will be replaced by the newly created one.
Alain Fontaine
Alain_Fontaine
2 yrs ago
Get help
Reported - view
Re: Struggling to get Display Field Only If to work with null values
Strange... I tested it and it worked (at least on the iPad version). Another approach would be to insert the test in the formula itself: if 'Competitor Price' = null thennullelse>>>> insert your…
Alain Fontaine
Alain_Fontaine
2 yrs ago
Get help
Reported - view
Re: Relationship between a table and itself
There is no barrier in Ninox preventing the creation of multiple relations between the same set of tables, or even between a table and itself. While it is always a good idea to rename the reference…
Alain Fontaine
Alain_Fontaine
2 yrs ago
Get help
Reported - view
Re: VLOOKUP formula between 2 tables
Mmmmm... Seems I did not read your description correctly. The formula shoud actually be: let zSelected := "," + text(numbers('Employé')) + ","; concat((select Collaborateurs where contains(zSelected,…
Alain Fontaine
Alain_Fontaine
2 yrs ago
Get help
Reported - view
Re: VLOOKUP formula between 2 tables
Indeed, "chosen()" does not work for dynamic multiple choice (DMC) fields. If you think about it, it does somewhat make sense: a DMC field is "populated" by submitting a function that returns an…
Alain Fontaine
Alain_Fontaine
2 yrs ago
Get help
Reported - view
Re: VLOOKUP formula between 2 tables
How is your dynamic multiple choice field filled? I mean, what is the formula in "Dynamic value"?
Alain Fontaine
Alain_Fontaine
2 yrs ago
Get help
Reported - view
Re: Bundled Product Circular Reference
A similar problem has been treated here: https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/resolving-a-bill-of-materials-60099f17f3f37f54ab80cc7c
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Searching in a n:1:n table not working
Not exactly what you are asking, but maybe a way to make the problem manageable. In the "family structure" table, create a button, named "Add payment", with the script: let lastpay :…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Counting the number of
I did use the select statement in numerous formula fields without apparent problems. I mean that I did not notice missing or spurious records. Maybe I just overlooked them...…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Counting the number of
While we are at it... An expression like: if Status = "Done" then 1 else 0 end can be replaced by: number(Status = "Done")
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Counting the number of
Strange, it works in the iPad app.
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Counting the number of
It is indeed possible to impose a condition while following a reference. The trick is to use the "square bracket" syntax: cnt(TASKS[STATUS = 1])
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Formula randomly displays date+hour instead of only date
This subject has been discussed several times. See for example:…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
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
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
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
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
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
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
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
Alain_Fontaine
3 yrs ago
Get help
Reported - view
1
7
8
9
10
11
16
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics