-
html() function
I uploaded a database named HTML Tricks. So far it only has one example, but I've got some other ideas I've been playing with. If you are interested in a blinking formula field you should give this…
-
Order by descending
When selecting records you can't specify descending?
-
Switch Case statement in Ninox
Another great structure in Ninox that can help you in the automatization of your processes is a Switch Case statement. Simple syntax, fewer lines of code, and faster result in your app.…
-
print Ordered
i have: if text(InvoiceItemVendor.'Status Item') = "Ordered" then printRecord(this, "Ordered") end but it doesn't work
-
acces to array items like with Where fonction
Hello to all, This new forum made me want to share something with you . I chose this code which allows to find elements in a table by filtering as we would do with the Where function of Select.…
-
Custom HTML Dashboard
Hello, i was looking to create a custom Dashboard in Ninox to have a clear overview over some important KPIs and also allow controllers to get a quick view at key data.…
-
Set auto completion on Ninox editor
Hello everyone, I was fed up with always having to close the code editor to fetch the name of a field or table, so I set up the Ninox code editor to have an auto-completion function :…
-
add onselect event for view field
In response to @Alain Fontaine & @Fred Christmas wish (https://forum.ninox.com/t/h7hbkmp?r=h7hbvzj), I have added a viewEvent function to Ninext project.…
-
Ninext : Native JavaScript
I start here a new post about the Native JavaScrip to differentiate it from the EvalJS function in which I had previously put it... I discovered one weekago that it was possible to add comments in…
-
Fonts, Colors and Borders
Hello, I uploaded an interactive CSS generator database titled "Theme Helper" in the Webinar EN 2021 team. It is very slow to respond online in the browser,…
-
Ninext : Important information
This message is addressed to all those who use the Ninext project. I regret to announce that the Ninext project will be unusable on Ninox very soon. This should happen at the beginning of February.…
-
Filling Lines of Orders/Articles with Dynamic Multiple Choice Fields And Cascading Dynamic Choice Fields.
In this database you can fill order lines with Dynamic Multiple Choice Fields and Cascading Choice Fields. It is located in the EN Team webinar and is called Cascading DCFields. Steven
-
Creative community and javascript
Hello everyone, For more than a year I have been exploring the Ninox code to better understand how it works. Initially driven by the lack of documentation and the frustration of some limitations,…
-
Auto populate fields with the value from the previous record?
Hi I'm only new to Ninox and setting a database to suit our business. Is it possible to auto populate fields with the value from the previous record? This was a very handy feature in Filemaker.…
-
Carriage Return and Line Feed (CRLF)
Hi there, In Ninox, I want to create a text file for an import into a 3rd party solution. The 3rd party solution requires line breaks to be formatted as carriage return + line feed ("CRLF").…
- Answered
-
Improve performance: Count records from subtable WITHOUT select statement
If you are counting records from a subtable, you can avoid using the 'select' statements... For example: Instead of using the code: let t := this; count(select Invoice where Customer = t and Status…
-
Put comments in the scripts
I discovered that it is possible to easily metre comments in scripts with a notation that was not documented: #{here I can put any text}#; var y := year('Start date'); var m := month('Start date');…
-
Custom Buttons
My contribution for the holidays is this template that allows you to create personalized buttons. Happy Holidays! Download and leave a review here...
-
Generate QRCode to File or Image field
Following a discussion with @CISOFT Sàrl ,I embedded Sangmin Shim's code in a Ninext function to generate a QRCode on Ninox. The QRCode generates a file on the attached files or in the Image field.…
-
Removing duplicate fields (emails as example) solution
for i in select Table_Name.Email_field do while cnt(select Table_Name where Email_field = text(i))!=1 do delete last(select Table_Name where Email_field = text(i)) end end Enjoy!
-
Complex Select statement for View
Summary of what I need to do: I have a table called Actions within which I am trying to create a view of all actions which are compatible with the current action.…
- Answered
-
Pass current viewing record Id to a view element column formula
Hi all - I have a table that has a view element. I'm trying to do formulas in the view element that requires data from the record I'm viewing. As we know,…
-
extractx() “g” flag workaround
Here is a basic UDF for extracting all of the values that match a regex pattern... function extractxg(src : text,regex : text) do let extValue := “”; let idx := 0; let idxLen := 0; while testx(src,…
-
Weird switch issue
I'm using the MacOS app, so if I put this in a formula field: switch Number do case Number < 5: 10 case Number > 5: 20 end with Number being a number field in the same table.…
-
Multi language solutions best practices
Hi again. I don't know if this is the best place for this question, but I will try... Here in Spain, about 70% of our clients sell their products and services in at least 3 languages: Spanish,…
- Answered