-
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().…
-
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:…
-
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,…
-
Short Contributors Bio
Hi All I'm pretty new to this forum, and to Ninox. I see the same names contribute their knowledge to us all (thank you) and I wonder if they (you) would be willing to give a bit of background about…
-
PDF with carbone and OCR-recognition
Hi I have used Carbone to create a fillable PDF created from Ninox. You can add values to it and then send it back. (email?). If the PDF is saved in an image field of the corresponding record,…
-
'Ninox for Windows' Version
Hi, Since 'Ninox for Windows' is still not available three years after Ninox announced that this platform-version was in the development pipeline, please could someone kindly inform me what other…
Learn how others are using Ninox, get tips and tricks for your business and purpose