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: Ninext project
One last thing, most of these add-ons would not have been created without your ideas and proposals. Thanks to all of you for your creativity and for sharing all these good ideas.…
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- 3
- Learn and Share
- Reported - view
Re: Ninext project
I have added a few tools recently. I've listed them here to centralize access and prevent them from getting lost in the abundant history of this forum. QRCode generator :…
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- 1
- Learn and Share
- Reported - view
Re: Child record table with dynamically header
Hello to both of you, Here is a function to change the column title of the display field. Just call the function with the name of the display field, the column number (starts at 0) and the new title…
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- 1
- Learn and Share
- Reported - view
Ninext : Debug Tracer

Hello everyone, For some time, I wanted to offer you a possibility to debug your programs. I am happy to present you a first debugging tool. It's simply a tracer to display the messages coming from…
- Ninox developper
- Jacques_TUR
- updated 2 yrs ago
- 10replies
- 542
- 2
- Learn and Share
Re: Different results using Checkbox vs Button to update text field with today() using the exact same code
@Fred on Mac App, all triggers are executed locally, so the problem does not appear.
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Different results using Checkbox vs Button to update text field with today() using the exact same code
@mass @RoSoft_Steven I confirme, Trigger After Update run on server. The formula of button run on locale. today() on server is align to universal time zone (GTM 0) and it's cause of your issue.…
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Relationship between "Chice" and "Formula" fields
@iliper LTD Oh yes, the Ninox compiler is case sensitive. Just replace "N" by "n" on the number function name. item([0, 0.1, 0.1, 0.15, 0.15, 0.2], number(Category)) Another thing,…
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Renaming part of title attachment
@thomas This is probably because 'Nr zuweisen' is of type number and extractx of type text. Just add "number(extractx(....))" and it should work. 'Nr zuweisen'
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Copy fields definition within a table or across tables
Thank you for your feedback. Yes it should be possible to duplicate a field and its definition in the same or in another table. I will look into this as soon as possible.…
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Relationship between "Chice" and "Formula" fields
You can also use a table with all possible discount rates according to the category number: item([0, 0.1, 0.1, 0.15, 0.15, 0.2],Number(category))
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Multi language solutions best practices
@buy The code I created only modifies the display and in that, it is not dangerous for the data and the application. But, as I don't master the Ninox code,…
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- 2
- Get help
- Reported - view
Re: Two fields sum
@iliper LTD Something like this ?
Attachment
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- Get help
- Reported - view
Re: Multi language solutions best practices
@iliper LTD Download the attached app to this post: https://forum.ninox.com/t/p8hs4hw?r=35hs4w8#35hs4w8 The code can be found in Trigger After Open in the app options.
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Multi language solutions best practices
I redesign it, you could try it now. Use Localization menu in admin mode to translate all captions and tooltips. It work on could and on app. You try it with the app attached on previous post
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Two fields sum
@iliper LTD You talk about all the old credits, but I only see one credit field in your table. You want to add a table with the old credits of the customers and add them up for each of them, right?
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- Get help
- Reported - view
Re: Is it possible to run the script in a button from another script?
@Louis Cornacchia It's a language specific to Ninox. I would say that it looks a bit like Pascale and JavaScript: It is pre-compiled (like Pascale and unlike JavaScript) but some parts can be…
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- Get help
- Reported - view
Re: Two fields sum
@iliper LTD This formula returns the sum of number1 and number2 only if number1 is not zero. In all other cases (including the one where number2 equals 0) this formula returns nothing (void).…
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- Get help
- Reported - view
Re: Two fields sum
What should happen if one of the two is equal to zero?
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- Get help
- Reported - view
Re: Sort table by month name in numerical month order?
@Kent Signorini I had not seen that the table was grouped by month. Indeed, grouping or sorting the table manually cancels the sorting that is done with the select function.…
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Sort table by month name in numerical month order?
@Kent Signorini If you are trying to sort a view field, then you can sort the table source. In the field formula you put this code: select myTable order by month(this.myDdate)
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- Get help
- Reported - view
Re: Renaming part of title attachment
@thomas when you leave the mouse on the red square, an error message appears. What does it say?
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- Get help
- Reported - view
Re: Renaming part of title attachment
@thomas If you put the replacex (as below) in the Trigger After Update of a number field, it will do what you want, right? myFileNameField := replacex(myFileNameField, "(\d+)", "", myNumberField)
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- Get help
- Reported - view
Re: Renaming part of title attachment
@thomas Louis Cornacchia You could try it on your console : "//init fileName"; var FileName := "HAGELSCHUTZ-Nr1082-150x400cm-Backlight-nicht-hinterleuchtet-mit Schlaufe-2021";…
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- Get help
- Reported - view
Re: Renaming part of title attachment
@thomas So what exactly do you need?
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- Get help
- Reported - view
Re: v3.7.11 on MacOS does not like Ninext
@Nick On the cloud, the bug is fixed since version 3.7.11. Did you clear the browser cache? To prevent futur Ninox bug, in this code, I added two parameters on the http function:…
- Ninox developper
- Jacques_TUR
- 2 yrs ago
- Get help
- Reported - view

1 14 15 16 17 18 33

Welcome to the Ninox community

Jacques TUR

My Posts

Re: Ninext project

Re: Ninext project

Re: Child record table with dynamically header

Re: Different results using Checkbox vs Button to update text field with today() using the exact same code

Re: Different results using Checkbox vs Button to update text field with today() using the exact same code

Re: Relationship between "Chice" and "Formula" fields

Re: Renaming part of title attachment

Re: Copy fields definition within a table or across tables

Re: Relationship between "Chice" and "Formula" fields

Re: Multi language solutions best practices

Re: Two fields sum

Re: Multi language solutions best practices

Re: Multi language solutions best practices

Re: Two fields sum

Re: Is it possible to run the script in a button from another script?

Re: Two fields sum

Re: Two fields sum

Re: Sort table by month name in numerical month order?

Re: Sort table by month name in numerical month order?

Re: Renaming part of title attachment

Re: Renaming part of title attachment

Re: Renaming part of title attachment

Re: Renaming part of title attachment

Re: v3.7.11 on MacOS does not like Ninext

Overview