React to input field changes and change page title of Detail View

Here I will briefly show how you can react to <input/> field changes and modify the title of the detail view page. I assume that you have already integrated AppGiniHelper Javascript Library into your project. In an example project I have the following three fields: first_name middle_names last_name The Detail View looks like this by default: First I create a Javascript file for Detail View hooks. Because the table is called contacts, the javascript file must be called contacts-dv.js and must be located in the hooks directory. I need a function for getting the current values of those three fields …

Convert input into Calculator

I often use numeric fields for prices, taxes, etc. And often I use the Windows Calculator for side-calculations, for example, for converting from net to gross, from gross to net, for calculating VAT or for calculating discounts. With my new AppGini Calculator Component I am able to run side-calculations directly in my AppGini Detail View Form. Example Take a look at this part of my Orders Detail View. There is a subtotal field which is just numeric input by default. Parameter subtotal is the name of the field. After reloading the page there is a button now which will will …

Remove buttons (5.9x)

In latest AppGini there are additional features like CSV-Import and keyboard shortcuts. For those there are new buttons in the navbar, which somehow break the inline-buttons user interface. You can get rid of them with a couple of useful new functions

SOLVED: “Remove image”-bug in AppGini > 5.9x – hooks-only solution

For some time there have been problems with deleting uploaded images. The bug seems to be still present in AppGini version 5.97. In this article I show a small help function to fix this problem. In the AppGini Forum a solution is shown which requires the modification of the files TABLENAME_dml.php. However, changes in these files are overwritten the next time they are generated. Here I show a solution that uses only hooks, which remain in place the next time they are generated. Problem In the past, uploaded images could be deleted by clicking the Remove image checkbox and then …

Solved: AppGini Database Backup Error on Windows

Have you also noticed that the database backup feature built into AppGini web applications does not work on Windows? The solution is quite simple, as I found out today. Read this post to see how we can solve this problem. Database Backup Maybe you have already seen the database backup function in the admin area of your AppGini application: Click the Create Backup File button, confirm the prompt and check if it works for you: Problem I don’t get any backup but I get the following error message: This is not only the case on your Windows development computer, but …

How to: Draw attention with flashing badge using pure CSS

In a project, I wanted to make users clearly aware that there are notes on a record. This is possible with a very simple CSS animation. You probably already know the so-called badges for the children tabs, in which the number of records is displayed. Instructions for this are available in the AppGini Udemy course, which many of us have booked and attended to get started. Our AppGini Helper Javascript Library has a function for this (included in compact function), which is described here. Those badges show the number or records. Anyway, if you want to draw a user’s attention …

Protect input fields against accidental overwriting

For the project I have already mentioned here and here, a barcode scanner is used for various tasks. If the input cursor is not in a search field, but in an input field, then the value of the field is overwritten by the scanned value or appended to the existing value. Sometimes this is on purpose, for example when creating a new record and assigning a Barcode to it. Most of the times overwriting an existing value by scanning a Barcode would cause data loss on save. To avoid this I have implemented a write protection for <input />-fields. When …