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
870
posts
559
likes received
20
followers
Latest Posts
Re: MultiLine Text field with multiple rows alongside in form
Hello everyone, I found a simple workaround to align a field on the left or right. You just have to put this code in a formula on the window : var options := { fieldName: "myText", align: "left" };…
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
5
Get help
Reported - view
Re: Carriage Return and Line Feed (CRLF)
I put here a complementary function that allows you to convert a character into a decimal (or hexadecimal) value: function ord(t : text) do var ascii :=…
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
Get help
Reported - view
Re: Carriage Return and Line Feed (CRLF)
@Fabian Wieland Don't worry, I still spent time and sweat on it. I had already tried to create a "chr" function before but I couldn't do it. So your request also helped me to look at the problem…
Attachment
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
Get help
Reported - view
Re: Wish List or can the great Jacques pull one out of the hat
@Alan Cooke Alan Cooke's request, I have added the possibility to set the background color of the tab independently from the form. Just add item formBackgroundColor in onUpdate event function inside…
Attachment
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
Learn and share
Reported - view
Re: Carriage Return and Line Feed (CRLF)
Another more elegant and reusable solution is to create the equivalent of the "chr" function in JavaScript. By adding these two functions in the global functions (Options->Global functions) :…
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
1
Get help
Reported - view
Re: Carriage Return and Line Feed (CRLF)
Indeed, replace(text,"\n","\r\n") replaces \n by \\r\\n. This comes from the fact that Ninox does not allow to enter special characters, that is to say those which are not alphanumeric, in its script.…
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
1
Get help
Reported - view
Re: Wish List or can the great Jacques pull one out of the hat
@Alan Cooke You're welcome. Currently, the sources in JavaScript are here : https://github.com/JacquesTur/Ninext
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
Learn and share
Reported - view
Re: Wish List or can the great Jacques pull one out of the hat
Dear @Alan Cooke Alan Cooke, impossible for me not to answer to such a title 😂. I updated the Ninext project and now it is possible to add an event function in the "Display field only if" trigger to…
Attachment
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
2
Learn and share
Reported - view
Re: Track selection of Dynamic Multiple Choice field
@Fred I feel like you used the first code I posted. Indeed it deleted all the records systematically and therefore had to recreate all those who were selected.…
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
Learn and share
Reported - view
Re: Text value from dynamic choice field
@UKenGB Usually I use the web and everything works fine. This is what I did my first test with. But here I just did a test on my iPhone and I confirm that it does not work on this platform.
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
Get help
Reported - view
Re: Text value from dynamic choice field
@UKenGB When I type : Text := text('Choice (dynamic)') In the Trigger after update of 'Choice (dynamic)', it works fine. I can't reproduce the problem 🤔.
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
Get help
Reported - view
Re: Detect list selection
@UKenGB With your indications, I could reproduce the problem and find the bug. Indeed, the hooking procedure that sends the onselect event was not set up.…
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
Get help
Reported - view
Re: Detect list selection
@UKenGB The code checks if the loading has already been done. If it has, it writes : exModules version 1.02 beta already loaded
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
Get help
Reported - view
Re: Detect list selection
@UKenGB Everything you are doing seems to be correct. It's a problem that seems random, and just this morning I found a random module loading error in my code.…
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
1
Get help
Reported - view
Re: Detect list selection
@UKenGB I understand that it is too long for you to do all these tests. Can you just send me the code you had put in the 'Trigger after open' ?
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
Get help
Reported - view
Re: acces to array items like with Where fonction
@Matthias S. Simply replace the code with this one: var a := numbers('Select characteristics'); select Contact where (var b := numbers('list of characteristics'); count(a[var v := this;…
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
1
Learn and share
Reported - view
Re: acces to array items like with Where fonction
@Fred @Fred Lines 4 and 5 creates a variable "c" that consists of numbers that are in both variable "a" and "b". On line 4 and 5, the variable C contains the numbers common to A and B.…
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
Learn and share
Reported - view
Re: Detect list selection
@UKenGB Ok, let me know because, I'm interested in eliminating a bug in my Ninext code. Thanks in advance.
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
Get help
Reported - view
Re: acces to array items like with Where fonction
@Fred said: To me the Select Contact where (count(c) = count(a)) says, count the number of items in variable c and check if it is equal to the number of items in variable a.…
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
Learn and share
Reported - view
Re: Detect list selection
@UKenGB I can't seem to reproduce the problem. In the attached example, I put an onselected in all tables and it seems to work fine. Can you send me an example that does not work?
Attachment
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
Get help
Reported - view
Re: acces to array items like with Where fonction
I was inspired by the code published by @John Halls below. The idea is to do a boolean AND operation between the DMC of the filter (named Select characteristics) and the DMC of each record (named…
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
1
Learn and share
Reported - view
Re: Detect list selection
@UKenGB The EvalJS app work or not ? Could you send me one application to test it ?
Jacques TUR
Ninox developper
Jacques_TUR
3 yrs ago
Get help
Reported - view
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
1
24
25
26
27
28
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