Exporting Records, Importing Into a New Database and Linking Them with Their Parents

Exporting Records, Importing Into a New Database and Linking Them with Their Parents By David Gyenes, Director of IT This task is not as complicated as it seems. It has three parts:  Exporting the tables with the correct information, importing the records with the crucial information into a couple of new fields and then linking […]

Diffferent Table View Functions

Diffferent Table View Functions By David Gyenes, Director of IT Many of you have asked the question, “How do I make a table visible or different for multiple users?” The answer is that you cannot change the table view itself, but you can create your own table view. If you create a form view and […]

Single and Multi-Dynamic Choices

Single and Multi-Dynamic Choices By David Gyenes, Director of IT With the launch of the new Ninox v3.3.0, we now have an excellent feature where we can finally create dynamic choices. Andy has covered parts of this topic already, but I would like to discuss specifically how to handle them and how to refer to […]

API Basics

API Basics By David Gyenes, Director of IT So many people ask us what APIs are and want to know how they work. API is controlled communication between two programs. Let’s start with some basics. API stands for Application Protocol Interface. API does not automatically exist in a program. It is enabled so that we […]

Ninox Emails

Ninox Emails By David Gyenes, Director of IT We get a lot of questions about sending auto emails from Ninox and I thought it would be a good topic to talk about. Andy has created a video about this topic on our YouTube channel as well, feel free to check it out (600.05 Email Integration […]

Reiniger-Code V.2

Cleaner Code Vol. 2 By David Gyenes, Director of IT Last week we saw an example of what kinds of code can be used for creating a new record in a table. But how can I return different values from it? In this first example I show how to return a single value – the […]

ID als Feldname

ID as Field Name By David Gyenes, Director of Information Technology  – ID as Field Name – I have seen people creating their own ID field in Ninox. They simply create a text or number type field and name it ID. DON’T DO THAT! 🙂 Ninox uses a hidden internal ID that is not visible […]

Reiniger-Code

Cleaner Code By David Gyenes, Director of Information Technology – Cleaner Code – There are many different ways to write a coding block- some clearer than others. One way that I’ve found improves readability is by not using a variable in my table records. Both codes work, but I find the latter to be cleaner. […]

Date / Time Issue

Date / Time Issue By David Gyenes, Director of Information Technology It looks like using an ISO (YYYY-MM-DDTHH:MM:SSZ) format to pass Date / Time information between our local computer and server is working well for me so far. How can you create this? Well we know the format() function. It can be used for Date, […]

Table Relations

Table Relations By David Gyenes, Senior Consultant Many people ask the same question about table relations (Parent – Child, know as “inner join” or equivalent, also called “outer join”) but they don’t seem to have the right answer. They wonder when or why we see a “plus” with a “search” or just the “search” sign […]