Jacques TUR

Jacques_TUR

Ninox developper

France

Joined: Sat Nov 14 09:45:24 UTC 2020

https://www.umangenius.com

La perfection est atteinte, non pas lorsqu'il n'y a plus rien à ajouter, mais lorsqu'il n'y a plus rien à retirer.

My Posts

Latest Posts

Re: Record create date function
table._cd return création date of record. table._md modification date. table._cu creator rable._mu modifier Formula exemple : “Created on “ + this._cd + “ by “ + this._cu;
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Unique Value Formula
@Mel Charles It is a regular expression (RegExp), a kind of meta language that allows to find elements in a string of characters. The RegExp " \D+ " extracts all non-numeric and consecutive…
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- Learn and Share
- Reported - view
Re: Unique Value Formula
@RoSoft_Steven If I were really smart, I would tell you that this is not true. Thank you all for your sharing intelligence and humility . For the calculation of the name,…
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- Learn and Share
- Reported - view
Re: How to create a unique list of records
Thanks to @Fred for inviting us to look into how to create a function equivalent to group in SQL. It's a good exercise and it can be really useful. My solution looks like this.…
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- 2
- Learn and Share
- Reported - view
Re: Ninext : Native JavaScript
Hello everyone, I improved NativeJS to fix one bug with the date type return value. Now it works fine and you can get any date type like this: #{:date return Date.…
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- 1
- Learn and Share
- Reported - view
Re: Server slowdowns !?
Thank you all, I think the problem is related to the many API calls I make from another server to Ninox. I'll look into it again and let you know what's up.
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- Get help
- Reported - view
Re: Server slowdowns !?
@RoSoft_Steven Thank's to answer. No, my connection works fine for all the others.
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- Get help
- Reported - view
Server slowdowns !?

Am I the only one with big server slowdowns this morning ?
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- 4replies
- 47
- Get help
Re: How to get filtering to work in a reference field that is set to popup and has columns from linked tables.
I had exactly the same problem and searched the code a bit. For some reason, when you type a search keyword in a popup, Ninox calls the server and it only searches the fields in the main table of the…
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- 1
- Learn and Share
- Reported - view
Re: Parameters it is possible to pass to a function
@support The best code is this one with you feel comfortable You can simplify like this : let t := this; if Channel like "abc" then (select table1 where 'order-id' = t.'Channel reference').…
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Extract certain variable numbers from attached file title
@thomas Because the year at the end is each time with 4 digits, and in case the file name contains the number, you could use this RegExp. I modified it so that it returns all parts of the complete…
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Extract certain variable numbers from attached file title
@thomas -[^0-9]*(\d+)[^1-9]*(\d+,?\d*)x[^1-9]*(\d+,?\d*)cm-[^1-9]+(\d+)-?(\d+)? It works for all files. I invite you to try it with this site https://regex101.com/r/Tyz1yY/2. This example is recorded.…
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Extract certain variable numbers from attached file title
@thomas I think this RegExp should recover all cases. Try it with different representative file names -[^0-9]*(\d+)[^1-9]*(\d+,?\d*)x[^1-9]*(\d+,\d*)cm-[\w]*-(\d+)-?(\w+)?
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Extract certain variable numbers from attached file title
@thomasJust add (\d+) at the end of RegExp. But with this new file name example, you have another problem: the file name contains a number and the formula is disturbed.…
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- Get help
- Reported - view
Re: For loop for accessing different fields
@Fred Yes, there are two undocumented functions in Ninox for manipulating fields: get(record, fieldName): returns the value of the fieldName passed for the record ; var rec := first(select Customer);…
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- 1
- Learn and Share
- Reported - view
Re: Line feed/Carriage return in an Alert
You can use also the ASCII code 13 + 10 (Carriage Return + Line Feed) with this code : var CRLF := urlDecode("%0D%0A"); alert("coucou"+CRLF+"les amis"); In line 1,…
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- 3
- Get help
- Reported - view
Re: Extract certain variable numbers from attached file title
@Fred It to convert string number to JSON number... extractx("NOM-Nr001-200x400cm-Backlight-2021", "(\d+)[^0-9]+(\d+)[^0-9]+(\d+)", "", "{""Numero intero"":$1}"), return {"Numero intero":001}.…
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Extract certain variable numbers from attached file title
@thomas try it : [^1-9]+(\d+,?\d+)[^1-9]+(\d+,?\d+)[^1-9]+(\d+,?\d+)
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- 2
- Get help
- Reported - view
Re: Extract certain variable numbers from attached file title
@Fred of course, you're right is better to stay away "-" and "x" . Also, if you replace [^0-9]+ by ^[1-9]+, it's replace my (0*) and it stay only 3 groups (not 6) :…
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Extract certain variable numbers from attached file title
@Fred good job !!! I just add 3 groups to remove the 0 before the significant digit. I also replaced the "[^0-9]+" by "-" and "+" which are signs directly present in the filename structure :…
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Third party formula editor?
@Javier don't know of any such editor because the Ninox language only exists on Ninox. But I think you can set VisualStudioCode to do it : https://learn.microsoft.…
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- Learn and Share
- Reported - view
Re: Is there a 'command' to delete an attachment?
You can also rename a file with similar NativeJS code : var file := file(this, "myFileName.pdf"); "// put here your old file name"; var newFileName := "myNewFileName.…
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- Get help
- Reported - view
Re: Third party formula editor?
Otherwise, I'm not sure I understand what you're looking for? Another script editor that can recognize Ninox syntax, right?
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- Learn and Share
- Reported - view
Re: Third party formula editor?
@Javier said: I'm using functions when possible (they only accept text or number parameters, so not as easy as it could be) There are many more possible types for function parameters.…
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- Learn and Share
- Reported - view
Re: Third party formula editor?
I think Visual Studio Code is a good choice. But when the function grows "too much", the right question is why it is so complex and long and how to reduce it into several simple and easy to…
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- Learn and Share
- Reported - view

1 17 18 19 20 21 33

Welcome to the Ninox community

Jacques TUR

My Posts

Re: Record create date function

Re: Unique Value Formula

Re: Unique Value Formula

Re: How to create a unique list of records

Re: Ninext : Native JavaScript

Re: Server slowdowns !?

Re: Server slowdowns !?

Server slowdowns !?

Re: How to get filtering to work in a reference field that is set to popup and has columns from linked tables.

Re: Parameters it is possible to pass to a function

Re: Extract certain variable numbers from attached file title

Re: Extract certain variable numbers from attached file title

Re: Extract certain variable numbers from attached file title

Re: Extract certain variable numbers from attached file title

Re: For loop for accessing different fields

Re: Line feed/Carriage return in an Alert

Re: Extract certain variable numbers from attached file title

Re: Extract certain variable numbers from attached file title

Re: Extract certain variable numbers from attached file title

Re: Extract certain variable numbers from attached file title

Re: Third party formula editor?

Re: Is there a 'command' to delete an attachment?

Re: Third party formula editor?

Re: Third party formula editor?

Re: Third party formula editor?

Overview