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: What is the current scope for formulas in View fields
Trying to answer the question about the scope in the original post.As far as I understand the subject, the scope for the evaluation of the logical expression following the "where" clause is, in turn,…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Same field to appear multiple times with same name
If you are not afraid to cheat, you can put something invisible after the name. I have had some success with the unicode character U+2062, INVISIBLE TIMES.…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Multilingual - Function Reference in German Webinar Team
Please count me in, thanks.
Alain Fontaine
Alain_Fontaine
3 yrs ago
Learn & Share
Reported - view
Re: Search text in table
="T" or ="C"
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Checking array for valid substrings from active directory
Hi, It seems that the original code contained a small error. This corrected version should work: let b := this.'App UID';let x := 0;let y := 0;let ARY := [".dpe.protected", ".dpesit.protected", ".dse.…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: I can’t change the height of the rows…
This feature does indeed work on the iPad. Touch the leftmost column, the one with the line count. It may be a little tricky to find the exact place to put your finger to grasp the dividing line.
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Lock a cell ?
This may be the answer: https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/relation-11-5cb70ac97e84541e903e0130
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: N:M relation in a view
Following on my own post, sorry. I mentioned the possibility to work with unique identifiers, without giving a possible formula. It goes like this: let zCompId := ", " + text(Id) + ", ";…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: N:M relation in a view
The reason why you don't get the expected result lies in the formula "Occurrences.Oeuvres.Compositeur.Name", wich does not do what you seem to expect. When a record in the "Média" table is pointed at…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Query to update a specific value in a record on click/on trigger
>It did work, only I had to change Value to status. I did not know the name of the field containing the status values (now I know it is "status"), so I did put "Value" as a place holder.…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: question on n:m relationships - using events template
If you look carefully, you will notice that all the "Members" with a single enrollment are unavailable. Only the members with no or several enrollments are available for selection.…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Query to update a specific value in a record on click/on trigger
Would this help you: let r := first((select Status)[Value = "Closed"]);this.(status := r)
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: linking tables only using a numeric field
Trying to end with a useful summary. When creating a relation, Ninox adds "Reference" fields to the formular view of both tables. The way to tailor the appearance of those fields is explained,…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: linking tables only using a numeric field
Maybe I was not clear enough. At the last step, one should be looking at a panel labeled "Reference from ... to ... (N : 1). After activating the "More options" part of the panel,…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: linking tables only using a numeric field
Maybe I don't understand your question fully, but it seems that this could work: - in the "One" table, while in administration mode, select the field showing the link to the "Many" table;…
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