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
Documentation
Solutions
Setup
Databases
Automation
My account
Administration
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
876
posts
568
likes received
20
followers
Latest Posts
Re: Write data to file
And with this code (and NativeJS from Ninext), you can also download it automatically and without the white window: "---------------------------- Download file -----------------------------";…
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
Get help
Reported - view
Re: Write data to file
Do you want to save a file in your Ninox record or on your computer?
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
Get help
Reported - view
Re: Get table info from a dynamic select field
Try to put this code on trigger after update of « Service » field : var s := record(’Produits et services’, number(Service)); ´Durée’:=s.’Durée’; ’Tarif unitaire’ := ‘Tarif HT’;
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
1
Get help
Reported - view
Re: Ninext project
@Icarus - Ralf Becker I make on update just now, perhaps in same time that you made screenshot ? If you wish, you can try the previous version by indicating the desired version number in the call to…
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
2
Learn and share
Reported - view
Re: Ninext project
I published one update, version 2.1.15 with some fixe : - fixed : After hiding or showing the docked popup, the side editor is incorrectly sized. - fixed : in the event of a recurring call,…
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
1
Learn and share
Reported - view
Re: Ninext project
@Icarus - Ralf Becker Thanks for the information Ralf, we'll try to figure out what's going on. From my side, everything seems to work quite well. I have version 2.1.…
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
Learn and share
Reported - view
Re: Ninext project
@Rafael see here : https://forum.ninox.com/t/p8h78zv?r=g9ha3vf
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
Learn and share
Reported - view
Re: Ninext project
I just published the version 2.1.14 of Ninext with this corrections : -fixed: on the Ninext popup, the icon representing the field type is sometimes not the right one.…
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
Learn and share
Reported - view
Re: Compare fields of 2 tables to get result
Try putting this code in the 'Remaining card balance' formula of the 'Payments' table. var t := this sum((select 'Carte-cadeaux' where 'Code de la carte-cadeau' = t.'Code de la carte').…
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
1
Get help
Reported - view
Re: Duration chart
@Sébastien Guillet said: Here's the result : nid(["V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15"]) I don't quite understand what that means...…
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
1
Get help
Reported - view
Re: Timestamp now() minus 3 minutes
I have been looking at the possibilities of subtracting from the now() function. now() is of type timestamp and it accepts subtraction with values of type time, date, timestamp and timeinterval.…
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
2
Learn and share
Reported - view
Re: Update multiple records
Since version 3.7.8, it is called: Bulk edit
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
Get help
Reported - view
Re: Update multiple records
@Alan Cooke Yes, this option was previously called : Update multiple records.
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
Get help
Reported - view
Re: Duration chart
@Sébastien Guillet No problem, everything is understandable. I use DeepL, because I think it is more accurate.
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
Get help
Reported - view
Re: Duration chart
It seems that the Ninox grapher does not accept the time value, only the numbers. I create a function to get the number of hours from the Duration : number('Durée') / (1000 * 60 * 60) Here is view…
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
1
Get help
Reported - view
Re: Timestamp now() minus 3 minutes
On computers, time is a value in milliseconds counted from 1 January 1970. If we want to decrease the current time by 3 minutes, we have to remove 1000ms * 60sec * 3mn .…
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
1
Learn and share
Reported - view
Re: Duration chart
@Sébastien Guillet I use a similar method on my dashboard and it works perfectly. Are you sure that "Duration" is of type number? You can use the debugValueInfo() function to check it.
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
Get help
Reported - view
Re: Duration chart
@Sébastien Guillet Could you post a database with your example to see what happens?
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
Get help
Reported - view
Re: Ninext project
I just put rev 2.1.13 of Ninext on line to correct tow things : - fixed the dock's splitter don't work on Ipad or IPhone. - following a pertinent remark from @Maurice :…
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
1
Learn and share
Reported - view
Re: Ninext project
Hello everyone, I have improved the Ninext popup (rev 2.1.12). Now you can dock it at the bottom or right of Ninox window : The position of the popup (floating, bottom or right),…
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
4
Learn and share
Reported - view
Re: Run python script from Ninox
You can try the html() function and Brython (https://brython.info/static_tutorial/en/index.html). I never use it because I develop with JavaScript. Let me know if it works.
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
Get help
Reported - view
Re: Run python script from Ninox
Why do you want to use Python when you can run JavaScript?
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
Get help
Reported - view
Re: Get count of chosen values from different table
@arisziniatis @arisziniatis said: The last functions works (but not the way I want to use it) @arisziniatis said: let a := "Name"; count(select Timetable where text(a) = "norm") and month(Date) = 4)…
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
2
Get help
Reported - view
Re: Get count of chosen values from different table
Finally, you can use the following function: let a := "text(Jim)"; count((select Timetable)[eval(a, this) = "norm"])
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
Get help
Reported - view
Re: Get count of chosen values from different table
@RoSoft_Steven A solution has been found by @Maria , just use the brackets instead of the where clause: var a := "text(Title)"; count((select Customer)[eval(a, this)="Mrs"])
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
1
Get help
Reported - view
1
11
12
13
14
15
35
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
Solutions
Ninox E-Invoice
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
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
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
View all topics