AppGini 5.82: New Preview function after generation

One of the new features is the Preview function. This allows you to open up the default browser and load the generated app with one click after generation of code. Step 1: Update AppGini If you don’t already have, please update AppGini to version 5.82. After installation, start AppGini and check if you are using the latest version: Close the About-form. Step 2: Configure localhost Now open Preferences in AppGini: Now set the Document root value and the Base URL value. Document root is the directory name of your webserver’s root directory. Base URL ist the base address which is …

How to: Default-value hack for more flexibility (Part 2)

In Part 1 we have seen how to change a value on inserting a new record. Now we are going to change multiple values at once using the same technique. Part 1: Technique + Changing single fields Part 2: Changing multiple fields at once Step 1 and Step 2 Pease follow Step1 and Step 2 from Part 1 of this tutorial. Step 3: Define fieldnames and values A good way for defining multiple fieldname+value tuples in PHP is by using associative arrays: A shorter variant: Please note the assignment operator => between key and value! From my own experience, sometimes …

How to: Default-value hack for more flexibility (Part 1)

AppGini offers several ways for defining static or dynamic default values for new records. Sometimes there is need for more flexibility. In this tutorial I am going to show a small PHP hack which will allow you to define default values on output fields dynamically in a very flexible way. Part 1: Technique + Changing single fields Part 2: Changing multiple fields at once Built in options Static default values If you need static initial values (default values) for new records in AppGini tables you can use the Default property in AppGini when modeling a column. Dynamic default values There …

How to: Optimize layout of detail views by using tabs and inlining

In a new project there is a table for storing tasks. Next to information like “Subject” or “Due date” we store date time values for… When did the creator assign the task to an employee When did the assignee start working on that task When did the assignee finish the task Later on we can use those datetime values for calculating average runtimes. Im showing the steps I took to optimize the user interface by using AppGini Helper JavaScript library functions. Start: Default generated form This is the default tasks detail view form. All fields have been aligned vertically. Step …

Quotes in SQL commands

Have you ever wondered what quotes to use in SQL commands? There is a very short help-block on the topic “Quotes in SQL commands” at the bottom of our Troubleshooting-Guide. ` Backticks enclose table- or column-names ‘ Single Quotes enclose values (like numbers or strings)

Bugfix for “Inline Detail-View” Plugin 2019/12/17

Dear Early Adopters, there is an updated version available for download which fixes a bug in AppGini webserver installations where no other plugins have been installed. If you have installed more plugins than our “Inline Detail-View” Plugin, there is no need to update. The update can be downloaded via the download link that you received in the e-mail after your order. We apologize for the inconvenience! With kind regards,Jan

New Plugin: “Inline Detail-View”

We are happy to introduce a new plugin. With the “Inline Detail-View” plugin you can display data record details directly below the selected row in the table view. Together with the new “calculated fields” function, values can be calculated and displayed immediately after saving the details. After installation, the plugin can be enabled for each table separately by just one click. We hope that with our new plugin you can significantly increase the efficiency of data acquisition.

Daterange picker

Take two datetime fields and link them into an inline date range picker with just a single line of javascript code (+our AppGini Helper JS Library of course). Here is the Documentation and there is an AppGini Forum Post.