Jacques TUR's Profile | Ninox community

Badges

Latest Posts

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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 yrs ago
- 2
- Get help
- Reported - view
Re: Two fields sum
@iliper LTD Something like this ?
Attachment
- Ninox developper
- Jacques_TUR
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 yrs ago
- Get help
- Reported - view
Re: Renaming part of title attachment
@thomas So what exactly do you need?
- Ninox developper
- Jacques_TUR
- 3 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
- 3 yrs ago
- Get help
- Reported - view
Re: Global function to work with out all parameters
@Fred You are so patient with others, I think it is the least I can do. Thank you for the help you bring to this forum 🙏. It work right now ?
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Get help
- Reported - view
Re: Multi language solutions best practices
@Nick Yes, as I said, this version of Ninext Language is not stable. I realized after I posted it that I didn't go about it the right way. I'm going to rework it soon and send you a stable and safe…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Get help
- Reported - view
Re: v3.7.11 on MacOS does not like Ninext
This bug is fixed and it doesn't concern Ninext exactly, but just the call to the http function with two parameters. Unfortunately the bug happened before Ninext was executed and I could not fix it.…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Get help
- Reported - view
Re: Is it possible to run the script in a button from another script?
@Louis Cornacchia It is standard Ninox script, see here : https://docs.ninox.com/en/legacy-manual/calculations/reference-of-ninox-scripting-functions#calling-functions You never use functions in…
- Ninox developper
- Jacques_TUR
- 3 yrs ago
- Get help
- Reported - view

1 18 19 20 21 22 37

Welcome to the Ninox community

Jacques TUR

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

Re: Global function to work with out all parameters

Re: Multi language solutions best practices

Re: v3.7.11 on MacOS does not like Ninext

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

Overview