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)

Showroom

All examples shown here are using our Javascript Library. Some examples require our Inline Detail-View Plugin additionally. Table View Additional links and buttons Read more Inline Detail-View Read more Detail View Custom tabs Read more Additional links and buttons Read more Date picker Read more Collapsible groups of fields Read more

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.

Inline Detail-View Plugin

Using this straight-forward plugin you are able to show the selected record’s details view right inside the table view. Increase the efficiency when collecting data especially in combination with the new “calculated fields” functionality of AppGini 5.8.

Step-By-Step Example

Moved here, please update your bookmarks In this full example we will explain changing a certain detail view step by step. 1. Prerequisites Library file Table: patients If your tablename is patients there will be a file named hooks/patients.php. Make sure your application has been generated and you can see all patients in the table view. Table view:patients_view.php Detail view:patients_view.php?SelectedID=2 Open one record to enter the detail-view mode. 2. Include script & apply common changes Edit hooks/header-extras.php Open hooks/header-extras.php in your code-editor. Line-by-line explanation Now reload the page in your browser and verify that three changes have been applied: I recommend to clean your browser’s …

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.