AppGini Helper

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 …

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 …

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)

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.

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.