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
Service 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
923
posts
631
likes received
21
followers
Badges
Latest Posts
Re: acces to array items like with Where fonction
@Matthias S. Something like that ?
Attachment
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
1
Learn and share
Reported - view
Re: acces to array items like with Where fonction
@Matthias S. Could you send me one exemple or tell me more ?
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
Learn and share
Reported - view
Re: Detect list selection
@Jacques TUR said: In the end, for the user it is very inconvenient and it can also be an opportunity to display a welcome message. I wanted to say : In the end,…
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
Get help
Reported - view
Re: Detect list selection
@UKenGB if you run the init script in the console it will return the html but it won't run it. To install the code of Ninext, it is necessary to execute JavaScript.…
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
Get help
Reported - view
Re: Detect list selection
@UKenGB Here is an example of initializing Ninext using the after open trigger.
Attachment
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
Get help
Reported - view
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
3 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
3 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
3 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
3 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
3 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
3 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
3 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
3 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
3 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
3 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
3 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
3 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
3 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
3 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
3 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
3 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
3 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
3 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
3 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
3 yrs ago
Get help
Reported - view
1
27
28
29
30
31
37
Ninox-Website
Overview
Learn and share
Get help
Service 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
Templates
Use cases
Automation
Performance
Scripting
Functions
API
My account
Subscriptions
Administration
Private Cloud Administration
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
Solutions
Ninox E-Invoice
View all topics