Deeper Cooperation Agreed

During two very friendly business meetings in November 2019, a deeper cooperation between BigProf Software bizzworxx was decided. Both parties will work closely together in the further development of AppGini and Plugins.

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. Table of Contents Step 1: Update AppGiniStep 2: Configure localhostXAMPP StandardWAMP StandardStep 3: Test settings 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 …

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 Table of Contents Step 1 and Step 2Step 3: Define fieldnames and valuesStep 4: Change the valuesComplete CodeFinal Result 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 …

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 Table of Contents Built in optionsStatic default valuesDynamic default valuesExampleStep 1: Locate the hook functionStep 2: Only in “Insert” modeStep 3: Fieldname and Default valueStep 4: Change the valueResultNext: Multiple fields Built in options Static default …

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. Table of Contents Start: Default generated formStep 1: Adding tabsStep 2: Readonly fieldsStep 3: Inlining fieldsStep 4: Optimize “broken” …

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.