Extension: Keep column names when joining table view columns
When joining columns in Table View of AppGini views, keep the names for better readbility
Category: Highlights of the day
Showcase of things which can be done using AppGini, AppGini Helper, PHP, SQL, JQuery, Javascript, HTML and CSS + a lot of time and sweat
Highlight: Join columns in Table View
Sometimes the number of visible columns in a table view becomes too large. I show here how I merge the contents of several columns into one column.
Highlight: TV-integrated drag & drop KANBAN board
Description An integrated drag & drop KANBAN board for table views which changes status and modified by/on columns of records just by dropping into a different slot. Showcase Example Table calculations contains a column named state_id which is a lookup, referencing states-table. There are four different states in states-table. Every state has been rendered as slot and therefore is available as drop-target. Additional states can be added, of course. When dropping an item into a different slot, there is an AJAX call from client (browser) to server. The serverside PHP script validates the passed data and checks for edit-permission on …
Highlight: Additional HTML content in Table View
Description You will know this from your E-Mail software: Preview of the message right inside in the list of emails. Wouldn’t it be great to have it in AppGini lists, too? For a tasks-table I wanted to show the task-subject and -description inside the table view. And this is the first draft: Next to a few additional buttons (see showcase here) there is a custom HTML text below every row. Showcase Code I have wrapped everything into an easy-to-use function which I am going to use in more tables in the future. Just by initializing the onEveryRow function (so called …
Highlight: Link to parent in Table View
Links to parent (master) tables in table view of AppGini applications
Highlight: Embedded PDF Viewer in Detail View (DV)
Description Integrated PDF viewer based on pdf.js which automatically loads and displays the uploaded pdf file. Showcase Screen Recording Details Components https://mozilla.github.io/pdf.js/
Highlight: Office-look-alike Navbar
Showcase Description Customized Bootstrap 3 stylesheet that mimics the look of office applications. Note that all changes have been coded without touching generated files. This means after re-generation of the app there are no template changes required. All has been done using Javascript/JQuery and CSS Details
Highlight: Table View with Open Street Map (OSM)
Showcase: Using Leaflet for interactive maps in AppGini application