The AppGini Blog
A few tips and tricks to make your coding life a tiny bit better.

Calculated expiry date field (given production date and validity period)

Calculate the expiry date of an item based on its production date and validity period via an SQL query in a calculated field.

Calculated expiry date field (given production date and validity period)

Highlight a table row if a checkbox field is unchecked

Highlight a table row in the table view of your AppGini app if a checkbox field is unchecked.

Highlight a table row if a checkbox field is unchecked

Dramatically reduce server load with a single firewall trick

Learn how to dramatically reduce server load by configuring a simple firewall rule to allow SSH access from a single IP address.

Dramatically reduce server load with a single firewall trick

New features in AppGini 5.80: An in-depth look

AppGini 5.80 includes some exciting new features that will add more power to your apps and save you more time. This post takes a thorough look into those new features.

New features in AppGini 5.80: An in-depth look

Prevent specific groups from directly accessing a table in AppGini

In this post, we’ll show how to prevent specific user groups from directly accessing a table in AppGini, while still allowing them to access it as a child table.

Prevent specific groups from directly accessing a table in AppGini

A work-around to implement a multiple-choice lookup field in your AppGini apps

AppGini provides a multiple choice option list field, which is a handy way to allow users of your app to select multiple values from a list. We’re going to populate it dynamically from a table, allowing users to add, edit, and delete options without needing to edit the project in AppGini, or upload any files, or manually edit any files.

A work-around to implement a multiple-choice lookup field in your AppGini apps

How to handle many-to-many relations in AppGini

Many-to-many relations (also known as N:M relations) is a way of describing the relationship between two entities/tables where each one could have, or own, or be related to, many items of the other. This article explains how to handle many-to-many relations in AppGini.

How to handle many-to-many relations in AppGini

Using full-text searches in AppGini apps

This article shows you how to implement full-text searches in AppGini apps using hooks.

Using full-text searches in AppGini apps

Fixing issues when trying to import CSV data to your AppGini app

If you’re having issues importing CSV data to your AppGini app, this article shows you how to validate your CSV file using CSVLint and suggests a fix for any issues found.

Fixing issues when trying to import CSV data to your AppGini app

How to hide columns in the table view based on user group in AppGini

This blog post explains how to hide specific columns in the table view based on the user group in AppGini, which is useful for showing different columns to different user groups.

How to hide columns in the table view based on user group in AppGini

Overwriting AppGini functions: Allowing Admin group members to access the admin area

Learn how to override AppGini functions to allow Admin group members to access the admin area.

Overwriting AppGini functions: Allowing Admin group members to access the admin area

Moving an AppGini application to a new server

This is a simple checklist of the steps you should follow to move an AppGini-generated application to a new server.

Moving an AppGini application to a new server

Trying to detect your application URI using DOCUMENT_ROOT? Read this first!

If you’re trying to detect your application URI using DOCUMENT_ROOT, you might be doing it wrong! Read this article to learn why and how to do it right.

Trying to detect your application URI using DOCUMENT_ROOT? Read this first!

How to make a checkbox mandatory in AppGini signup form

This article shows you how to make a checkbox mandatory in the AppGini signup form. This is useful for GDPR compliance or to enforce terms and conditions.

How to make a checkbox mandatory in AppGini signup form

Automatically be notified of any errors on your server

Learn how to automatically check your server logs for any errors and get notified by email if any are found.

Automatically be notified of any errors on your server

Displaying count of child records on the tab title

AppGini supports displaying a list of child records in the detail view of the parent record. We’ll show you how to display the count of these child records on the tab title via JavaScript.

Displaying count of child records on the tab title

How to find non-active users in AppGini

This article shows you how to find non-active users in AppGini by running an SQL query in PhpMyAdmin.

How to find non-active users in AppGini

Hiding the nicedit component from a page

AppGini uses nicedit Javascript component for displaying rich text areas, where users can enter formatted input. You might wish to hide/show the rich editor in an AppGini page, or in one of your custom pages. This can be done using JavaScript code.

Hiding the nicedit component from a page

How to hide a field in child table view

This article shows you how to hide a field in a child table view in AppGini using CSS.

How to hide a field in child table view

Which files are changed when you add a new table to your AppGini project?

Many users wonder which files should they upload to their web server after adding a new table to AppGini and generating the app. This article lists all files changed when you add a new table to your AppGini project.

Which files are changed when you add a new table to your AppGini project?