-
Localization
Hello. I'm from Scandinavia. In Denmark, Norway, Sweden and Finland we have a tradition for localization. When I have delivered a solution in a Swedish company I normally send all UI words and…
-
Speed up a script using Local Binding
I wanted to check my stock position going forward for the next 100 days so I created a table of days and took the daily demand out of stock each day and added in any forward contracts on the day…
-
Old threads occasionally appearing
Why are old topics from a few years ago occasionally popping up when there is no new posts to that thread? - Was just about to launch into great detail to answer one then realised it was from 2…
-
Cross Tab in a Form
I have come up with a way to cross tabulate a table of values in a form This is the table of values And this is the table I use to create the Cross Tab This code do as server delete XTab; let a :…
-
HTML Report
Hi all. There are any way to create on Ninox a HTML report like this, there are some examples here. Thanks.
-
Attachments Selector or also Photo Viewer
Sometimes you have more than one picture of an article. With this template you can choose from the attachments-tab which photo should be displayed. Posted it in the Webinar EN 2020 team :…
-
Passing data from a Text field or MultipleChoice field to a DynamicMultipleChoice field
If you have a MultipleChoice field, and want to pass the same chosen options to a DynamicMultipleChoice field, follow the steps below: - Create a new reference table with the options written exactly…
-
Suggestion List from first crack at Ninox
Hey everyone, i am near completion of my first Ninox app, which is essentially a crypto exchange for my crypto consultancy for my clients worldwide. It is currently isolated to me,…
-
A major step forward.
Ninox is a fantastic database. If you could develop the possibility to LINK tables between databases it would change everything. NOT API. If I have a master database and then link tables from other…
-
Improve performance: Save Calculated values in Static fields
Views of the tables can sometimes take longer to be displayed due to the functions which are calculating the values. Formula fields have to be calculated every time the view is opened.…
-
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.…
-
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 :…
-
Display linked records within the according table view
If you have a main record with several linked records (e.g. record of a contact/customer with a list of linked invoices) and you want to access those directly in the according table view,…
-
Protecting Editable Fields - Best practice
At our school teachers enter a lot of data and we want to protect ourselves from accidentally clicking or tapping and modifying a fields. Here are a few thoughts on how I am thinking of making this…
-
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…
-
Printing Dynamic Field in Ninox App
The video is presenting a little workaround for printing Dynamic fields in Ninox App. In the print layout, we can avoid showing the record ID by simply rapping the field name into text().…
-
Somewhere to share user templates?
Hi everyone at Ninox, Is there or could there be a place on the site to share templates made by users? For example, among other things, I use Ninox to manage the parts library of an amateur orchestra…
-
Targeted deletion of records in tables
Table management is an important task in keeping your database clean and running by avoiding redundancies, accidental double entries, etc. While you could open every record in question and delete…
-
Do graphics of the result of customer survey
Hi, I Created one table for registering all the surveys that we make to all the customers that attend to different tours. The table is related to the tours and to the customer as you can see in the…
-
Auto Backup for iCloud
I have my database in iCloud so that I can use the iOS apps. Problem is the data is hidden, and should something go wrong; then there is no way to recover it from iCloud.…
-
Adding values between values in a (dynamic) choice field...
Ever wanted to add a value between values in a choice field? This is possible with a Dynamic Choice Field : >Formula in the MoveUp button: Number := Number - 1.…
-
Dynamic choice fields
Dynamic choice fields With the new Dynamic single and multiple-choice fields, you can create fully dynamic lists with the flexibility to decide the list items, update parameters, display values,…
-
Operators for searching one/several texts in the field filter (Boolean)
From time to time you need to search for several texts in a table column at the same time or you want to exclude certain texts from the search. To do this,…
-
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!
-
Required fields
May I suggest the following: If a field is set to be "Required", the form should not be close-able until a value is set/chosen - just like on web-site forms:…
Learn how other people are using Ninox, get tips and tricks for your business and purpose