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

Ninext : Fields inspector (evaluate the impact of changing/deleting a field before to do)

Hello everyone, Have you ever had a cold sweat before deleting a field in a table ? I always wonder what will happen. And the more my database is important,…
- Ninox developper
- Jacques_TUR
- updated 2 yrs ago
- 56replies
- 1020
- 10
- Learn and Share
Re: MultiLine Text field with multiple rows alongside in form
@Bernd Krell Ok, indeed, when the window is opened in second (popup of the first form), the formula does not work anymore. I found the origin of the problem and I corrected the code: var params :…
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- 3
- Get help
- Reported - view
Re: MultiLine Text field with multiple rows alongside in form
@Bernd Krell At home, it works well.Can you try with the database as an attachment?
Attachment
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- Get help
- Reported - view
Re: MultiLine Text field with multiple rows alongside in form
@Bernd Krell Please let me see your code to help you.
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- Get help
- Reported - view
Re: The number of days in each month of the day period and its total
@Jacques TUR There was a defect in the calculation of the dates. Because of a bad rounding of the dates and the independent time zone option, I end up with an aberrant calculation when I add days to…
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- Get help
- Reported - view
Re: The number of days in each month of the day period and its total
@張良仲 Something like that? Here is the formula I used: // create a table that contains all the dates var t := for i from 0 to days('Start date', 'End date') do { year: year('Start date' + i), month:…
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- Get help
- Reported - view
Re: MultiLine Text field with multiple rows alongside in form
@Fred thank you for these very useful details
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- Get help
- Reported - view
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" };…
- Ninox developper
- Jacques_TUR
- 2 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 :=…
- Ninox developper
- Jacques_TUR
- 2 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
- Ninox developper
- Jacques_TUR
- 2 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
- Ninox developper
- Jacques_TUR
- 2 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) :…
- Ninox developper
- Jacques_TUR
- 2 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.…
- Ninox developper
- Jacques_TUR
- 2 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
- Ninox developper
- Jacques_TUR
- 2 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
- Ninox developper
- Jacques_TUR
- 2 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.…
- Ninox developper
- Jacques_TUR
- 2 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.
- Ninox developper
- Jacques_TUR
- 2 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 .
- Ninox developper
- Jacques_TUR
- 2 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.…
- Ninox developper
- Jacques_TUR
- 2 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
- Ninox developper
- Jacques_TUR
- 2 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.…
- Ninox developper
- Jacques_TUR
- 2 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' ?
- Ninox developper
- Jacques_TUR
- 2 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;…
- Ninox developper
- Jacques_TUR
- 2 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.…
- Ninox developper
- Jacques_TUR
- 2 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.
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- Get help
- Reported - view

1 22 23 24 25 26 33

Welcome to the Ninox community

Jacques TUR

My Posts

Re: MultiLine Text field with multiple rows alongside in form

Re: MultiLine Text field with multiple rows alongside in form

Re: MultiLine Text field with multiple rows alongside in form

Re: The number of days in each month of the day period and its total

Re: The number of days in each month of the day period and its total

Re: MultiLine Text field with multiple rows alongside in form

Re: MultiLine Text field with multiple rows alongside in form

Re: Carriage Return and Line Feed (CRLF)

Re: Carriage Return and Line Feed (CRLF)

Re: Wish List or can the great Jacques pull one out of the hat

Re: Carriage Return and Line Feed (CRLF)

Re: Carriage Return and Line Feed (CRLF)

Re: Wish List or can the great Jacques pull one out of the hat

Re: Wish List or can the great Jacques pull one out of the hat

Re: Track selection of Dynamic Multiple Choice field

Re: Text value from dynamic choice field

Re: Text value from dynamic choice field

Re: Detect list selection

Re: Detect list selection

Re: Detect list selection

Re: Detect list selection

Re: acces to array items like with Where fonction

Re: acces to array items like with Where fonction

Re: Detect list selection

Overview