Skip to main content
Forum
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and share
Get help
Updates & status
Plugins
Documentation
Setup
Databases
Automation
My account
Administration
Solutions
Webinars
Overview
Profile
Jacques TUR
Jacques_TUR
Ninox developper
France
www.umangenius.com
Follow
La perfection est atteinte, non pas lorsqu'il n'y a plus rien à ajouter, mais lorsqu'il n'y a plus rien à retirer.
Joined
Sat Nov 14 09:45:24 UTC 2020
943
posts
653
likes received
21
followers
Badges
Latest Posts
Re: Detect list selection
@UKenGB Indeed, I had not received a notification for your message. It's surprising 🤔. At the same time, I'm not very familiar with Github and I'm learning to use it as I go.…
Jacques TUR
Ninox developper
Jacques_TUR
4 yrs ago
Get help
Reported - view
Re: Detect list selection
@Jacques I just saw that I complicated things a little for nothing. It is not useful to pass the record number as a parameter since it is that of the current record (this).…
Jacques TUR
Ninox developper
Jacques_TUR
4 yrs ago
Get help
Reported - view
Re: Detect list selection
@UKenGB I created the function in a new version of Ninext/exViewEvent: It's still only a prototype and we'll have to test it to check that it works well in all cases.…
Jacques TUR
Ninox developper
Jacques_TUR
4 yrs ago
1
Get help
Reported - view
Re: Detect list selection
@UKenGB There is a simple way to do this, just add a tab first in the list of fields: Then you add your code in the Display If trigger Don't forget to put true (or any other formulas) at the end of…
Jacques TUR
Ninox developper
Jacques_TUR
4 yrs ago
Get help
Reported - view
Re: Detect list selection
@UKenGB I think it's possible by inserting the onSelect function into the Visible If trigger of the table. I have to look if it's possible. What would be the use for you?…
Jacques TUR
Ninox developper
Jacques_TUR
4 yrs ago
Get help
Reported - view
Re: Detect list selection
This post might help you: https://forum.ninox.com/t/60hbvbz/add-onselect-event-for-view-field
Jacques TUR
Ninox developper
Jacques_TUR
4 yrs ago
Get help
Reported - view
Re: Field Duration time in second
Duration fields return a value in milliseconds. To get the value of a duration field in seconds, simply divide it by 1000: number(Durata)/1000
Jacques TUR
Ninox developper
Jacques_TUR
4 yrs ago
Learn and share
Reported - view
Re: Track selection of Dynamic Multiple Choice field
@Fred Yes, it is sometimes important to distinguish between the types of variables returned by the Ninox functions : - numbers(dMC); return an array of number record id.…
Jacques TUR
Ninox developper
Jacques_TUR
4 yrs ago
Learn and share
Reported - view
Re: Track selection of Dynamic Multiple Choice field
@Fred said: Just remember to only use one dMC at a time. You have to de-select everything from one dMC before using another. I'm not sure to understand why you would recommend clearing the dMC before…
Jacques TUR
Ninox developper
Jacques_TUR
4 yrs ago
Learn and share
Reported - view
Re: Track selection of Dynamic Multiple Choice field
@Fred said: So I made the change from > to >= on line 2: Dans ce cas, la condition sera toujours vrai, que Count retourne 0 ou plus de 0; La bonne solution est = 0;
Jacques TUR
Ninox developper
Jacques_TUR
4 yrs ago
Learn and share
Reported - view
Re: Track selection of Dynamic Multiple Choice field
@Fred Sorry, I published too fast. After some tests, I modified the code so that it doesn't delete all the children every time. let t := this; "retrieve all selected records from Table4";…
Jacques TUR
Ninox developper
Jacques_TUR
4 yrs ago
Learn and share
Reported - view
Re: Track selection of Dynamic Multiple Choice field
Very interesting code, thanks a lot @Fred ! I had fun modifying it so that it would take into account all the changes that would be made in the table at once and not only an addition or a removal.…
Jacques TUR
Ninox developper
Jacques_TUR
4 yrs ago
1
Learn and share
Reported - view
Re: Creative community and javascript
@Günther On the web, everything seems to work fine. I don't have any problems. The syntax check is modified by the initialization code. If it doesn't work,…
Jacques TUR
Ninox developper
Jacques_TUR
4 yrs ago
Learn and share
Reported - view
Re: acces to array items like with Where fonction
@UKenGB it's just when I post on the forum. Unfortunately, Ninox doesn't allow comments yet.
Jacques TUR
Ninox developper
Jacques_TUR
4 yrs ago
Learn and share
Reported - view
Re: Function parameters - which types are possible
@John Halls The variable "This" corresponds to the current record (RID) when Eval is called from a form function. You can replace it with any Ninox function that returns a RID (one record) like First,…
Jacques TUR
Ninox developper
Jacques_TUR
4 yrs ago
Get help
Reported - view
Re: Function parameters - which types are possible
@Sean said: Maybe something is getting crossed in translation, but yes, you can pass a table object or a record object as an argument to a user defined function No,…
Jacques TUR
Ninox developper
Jacques_TUR
4 yrs ago
Get help
Reported - view
Re: Function parameters - which types are possible
@Sean In NinoxScript, it is not possible to pass a table as a parameter to a function, nor a record (you can pass an array that would be the result of a Select with the any type).…
Jacques TUR
Ninox developper
Jacques_TUR
4 yrs ago
Get help
Reported - view
Re: Function parameters - which types are possible
@Sean Sorry, I misunderstood. Can you send me your code?
Jacques TUR
Ninox developper
Jacques_TUR
4 yrs ago
Get help
Reported - view
Re: Function parameters - which types are possible
@Sean yes, of course "this" does not exist in the console. You have to replace it with another record number, like "first(select Customer)".
Jacques TUR
Ninox developper
Jacques_TUR
4 yrs ago
Get help
Reported - view
Re: Function parameters - which types are possible
@Sean something like that ? function myFunction(tableName : text,fieldName : text,filter : text) do var c := eval("select " + tableName + " where " + fieldName + " like " + filter, this); c end;…
Jacques TUR
Ninox developper
Jacques_TUR
4 yrs ago
Get help
Reported - view
Re: Function parameters - which types are possible
@Sean I'm not sure I understand your question. Can you tell me what you would like to achieve?
Jacques TUR
Ninox developper
Jacques_TUR
4 yrs ago
Get help
Reported - view
Re: New 3.6 Script Editor
@Karen Estrada this code, without second « if » work fine : if 'Summary Block Style' = 1 or 'Summary Block Style' = 3 then true else null end If you put two « if », you must to put also two « then ».
Jacques TUR
Ninox developper
Jacques_TUR
4 yrs ago
2
Get help
Reported - view
Re: New 3.6 Script Editor
@Karen Estrada Could you share your code to try and reproduce and fix the problem?
Jacques TUR
Ninox developper
Jacques_TUR
4 yrs ago
Get help
Reported - view
Re: Make some informations confidential
@John Halls Thanks John. Of course encryption is part of the problem, but I prefer to use something that already exists (I'm lazy 😂). The other big question is how to share the password between…
Jacques TUR
Ninox developper
Jacques_TUR
4 yrs ago
Get help
Reported - view
Re: Suggestions from May 2022
@Mel Charles I think it's a good place to share what we think is impossible on Ninox because sometimes it's possible and others have the solution. Already several solutions have been found and shared…
Jacques TUR
Ninox developper
Jacques_TUR
4 yrs ago
Learn and share
Reported - view
1
28
29
30
31
32
38
Ninox-Website
Overview
Learn and share
Get help
Updates & status
Plugins
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Plugins
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
History
Templates
Use cases
Automation
Performance
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
Solutions
Ninox E-Invoice
View all topics