Quickie: Change values in table cells

In a table I have a calculated field that result in either 0 or 1. When scrolling down, because of the mass of data it is hard to see where the differences are. With a small javascript function I can change the values and highlight differences better. I show the result and the javascript code needed for it. Standard Table View Modified with only little code Standard Table View I have blurred out confidential data which is not relevant for this sample Did YOU notice the records having is_expired == 1? Modified Table View Check for yourself if you can …

Highlight: WordPress integration

For an upcoming project we plan to integrate data from an AppGini application into a WordPress page. I am currently creating a prototype to determine the feasibility. Components On the one hand, we need a configurable WordPress plugin that retrieves the data. On the other hand we need a counterpart on AppGini side, which provides the data. WordPress output This is what the first results look like. Please note that I have not made the result list prettier yet. More CSS styling is still required here. It is just the first draft: This is a WordPress installation on localhost. The …

Tip: Additional parameter for Action Buttons

It has been described here how to add additional buttons below a detail view’s action buttons. Today I’m going to explain how to add parameters to action button links. This should work with all versions of AppGini Helper Javascript Library. I’m going to use a few functions which are available sind since version 2020/06. Just as a short reminder and introduction for this how-to: Line 4 will add a new group with header “Kalkulation” and icon “glyphicon-cog” (see Glyphicons). In line 5 I’m declaring the link ULR, stored in href variable. In Line 6 I’m adding a new button named …

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 …