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: 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'
Jacques TUR
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.…
Jacques TUR
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))
Jacques TUR
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,…
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
2
Get help
Reported - view
Re: Two fields sum
@iliper LTD Something like this ?
Attachment
Jacques TUR
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.
Jacques TUR
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
Jacques TUR
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?
Jacques TUR
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…
Jacques TUR
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).…
Jacques TUR
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?
Jacques TUR
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.…
Jacques TUR
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)
Jacques TUR
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?
Jacques TUR
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)
Jacques TUR
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";…
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
Get help
Reported - view
Re: Renaming part of title attachment
@thomas So what exactly do you need?
Jacques TUR
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:…
Jacques TUR
Ninox developper
Jacques_TUR
2 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 ?
Jacques TUR
Ninox developper
Jacques_TUR
2 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…
Jacques TUR
Ninox developper
Jacques_TUR
2 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.…
Jacques TUR
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 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…
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
Get help
Reported - view
Re: Multi language solutions best practices
@iliper LTD I'll try to fix it. Are you work with the Mac App or the cloud ?
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
Get help
Reported - view
Re: Global function to work with out all parameters
@Fred Does it work when you call teamAvP with void in the cName parameter?
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
Get help
Reported - view
Re: Global function to work with out all parameters
@Fred Like I said here you must to specify the type of void like this : (rType = text(void) or 'Round Type' = rType). With out it, Ninox try to found record with 'Round Type' = void.
Jacques TUR
Ninox developper
Jacques_TUR
2 yrs ago
Get help
Reported - view
1
16
17
18
19
20
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