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
Plugin apps
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
907
posts
615
likes received
20
followers
Badges
Latest Posts
Re: Is it possible to delete all PDF file attachments on any given record without having to delete them one at a time?
@Mconneen Yes, with local applications, the only one I know is to use JavaScript.
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
Get help
Reported - view
Re: Write data to file
@UKenGB said: especially as the user manual clearly implies that you can do this. Where ? Can you send me a link ? As far as I know, it is not possible to save a file to the computer's disk from…
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
Get help
Reported - view
Re: Multiple records print with button
@Sébastien Guillet in the formula of a button. You can also create a global function to use it in several places in your database. function printAndDownloadMutiRecord( strNids : text, reportName :…
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
Get help
Reported - view
Re: Multiple records print with button
With Ninext (https://forum.ninox.com/t/p8h78zv?r=g9ha3vf), you can do it : var strThis := string(this.id); var Nids := (select myTable).string(id); var reportName := "myReportName"; var fileName :…
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
2
Get help
Reported - view
Re: New functions
Here is a function that is not new but is not documented. It is the records function that returns multiple records from an array of record numbers. It is the equivalent of the record function,…
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
1
Learn and share
Reported - view
Re: Write data to file
Use createTextFile with importFile : File := createTextFile(this, raw('Rich text'), "MyTextFileExample.html"); importFile(this, File);
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
Get help
Reported - view
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
1
12
13
14
15
16
36
Ninox-Website
Overview
Learn and share
Get help
Service status
Plugin apps
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