Jacques TUR's Profile | Ninox Community

Badges

Latest Posts

Re: Ninext : Fields inspector (evaluate the impact of changing/deleting a field before to do)
@Mel Charles I just updated Ninext to show different shapes depending on the impact level: green circle : display code organge rounded square : calculation code to make another field visible or to…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Learn and share
- Reported - view
Re: Explanations and examples of Ninox functions available in our docs
Thank you Claudia, that's good news. It will be great to have examples on the Order By function: - The different possibilities of sorting dates (in the format text or number),…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- 1
- Learn and share
- Reported - view
Re: add onselect event for view field
@UKenGB Normally if the onclick function returns false or void, then it is the default Ninox code that runs. And in this case, the selection by with the arrow keys works well.…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Learn and share
- Reported - view
Re: Ninext : Fields inspector (evaluate the impact of changing/deleting a field before to do)
@Fred I'm going to test with a large database to reduce the opening time. Moreover I must be able to do it in the background so that it does not penalize the use.…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- 1
- Learn and share
- Reported - view
Re: Ninext : Fields inspector (evaluate the impact of changing/deleting a field before to do)
@Mel Charles Thanks, it's precious to know that. I will see about putting different shapes (round, square, triangle)
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Learn and share
- Reported - view
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 3 yrs ago
- 56replies
- 1093
- 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 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 :=…
- 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
- 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
- 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) :…
- 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.…
- 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
- 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
- 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.…
- 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.
- 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 🤔.
- 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.…
- 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
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Get help
- Reported - view

1 25 26 27 28 29 36

Welcome to the Ninox community

Jacques TUR

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

Re: Explanations and examples of Ninox functions available in our docs

Re: add onselect event for view field

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

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

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

Overview