Jacques TUR's Profile | Ninox community

Badges

Latest Posts

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
- 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.…
- 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…
- 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;
- 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";…
- 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.…
- 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,…
- 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.
- 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,…
- 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,…
- 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).…
- 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?
- 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)".
- 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;…
- 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?
- 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 ».
- 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?
- 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…
- 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…
- Ninox developper
- Jacques_TUR
- 4 yrs ago
- Learn and share
- Reported - view
Re: add onselect event for view field
@Jacques TUR
- Ninox developper
- Jacques_TUR
- 4 yrs ago
- Learn and share
- Reported - view
Re: add onselect event for view field
After using this function, I noticed a flaw. When a row is already selected and you click on a column different from "selected", nothing happens, the popup does not open because the row was already…
- Ninox developper
- Jacques_TUR
- 4 yrs ago
- Learn and share
- Reported - view
Re: Suggestions from May 2022
@MODA said: Inline editing of tables in forms. Right now, this is only possible in the views but not in the forms. If you click on any row in a form, it just pops up the record.…
- Ninox developper
- Jacques_TUR
- 4 yrs ago
- 1
- Learn and share
- Reported - view
Re: Make some informations confidential
Thank you all for your valuable responses. As @MODA explains, I need to find a solution for data that is encrypted by a person who wants to share it with other people of his choice without having to…
- Ninox developper
- Jacques_TUR
- 4 yrs ago
- 2
- Get help
- Reported - view
Re: Make some informations confidential
@Paul Chappell Thank you very much Paul for these proposals which I could use for other applications. For my current need, it is necessary that even the administrator can not see the data.…
- Ninox developper
- Jacques_TUR
- 4 yrs ago
- Get help
- Reported - view
Re: Ninox REST API for Javascript
Thank you very much for making the Ninox API available in JavaScript. I think it will help a lot of external developers to interact with Ninox 👍
- Ninox developper
- Jacques_TUR
- 4 yrs ago
- Learn and share
- Reported - view

1 28 29 30 31 32 38

Welcome to the Ninox community

Jacques TUR

Re: Field Duration time in second

Re: Track selection of Dynamic Multiple Choice field

Re: Track selection of Dynamic Multiple Choice field

Re: Track selection of Dynamic Multiple Choice field

Re: Track selection of Dynamic Multiple Choice field

Re: Track selection of Dynamic Multiple Choice field

Re: Creative community and javascript

Re: acces to array items like with Where fonction

Re: Function parameters - which types are possible

Re: Function parameters - which types are possible

Re: Function parameters - which types are possible

Re: Function parameters - which types are possible

Re: Function parameters - which types are possible

Re: Function parameters - which types are possible

Re: Function parameters - which types are possible

Re: New 3.6 Script Editor

Re: New 3.6 Script Editor

Re: Make some informations confidential

Re: Suggestions from May 2022

Re: add onselect event for view field

Re: add onselect event for view field

Re: Suggestions from May 2022

Re: Make some informations confidential

Re: Make some informations confidential

Re: Ninox REST API for Javascript

Overview