TV-customization (Part 1): Change Value

There are many requests on AppGini forum for customizing Table View columns to your own needs. Especially many of you would like to change the table-cell-style depending on certain values, for example highlight a cell in red under certain conditions. Well, there has been a change recently: AppGini now removes custom style-attributes for security reasons. In this tutorial I am going to show how to reach the goal anyway. I will start with this Part 1 where I am going to show how to just replace values. If you are interested, just search the internet for “Cross Site Scripting (XSS) …

Quickie: Modify Download Button

File-upload fields are one of many great features of AppGini-generated apps. In Table View (TV) and also in tables of children tabs in Detail View (DV) AppGini renders larger download buttons with blue default icon and no text, by default: In one of my projects, I wanted to change the appearance of that download button so that it matches the “Open” button (to the left of it) better, visually, and also add a caption for better usability. Example Default AppGini automatically renders a larger button with blue text-color (depending on your theme). Modified download button Same height as “open” button …

Convert input into Calculator

I often use numeric fields for prices, taxes, etc. And often I use the Windows Calculator for side-calculations, for example, for converting from net to gross, from gross to net, for calculating VAT or for calculating discounts. With my new AppGini Calculator Component I am able to run side-calculations directly in my AppGini Detail View Form. Example Take a look at this part of my Orders Detail View. There is a subtotal field which is just numeric input by default. Parameter subtotal is the name of the field. After reloading the page there is a button now which will will …

Styling a Detail View: a step-by-step example

Today I am going to take you on a trip from a default, generated detail view to a UI-modified detail view using the latest version of our AppGini Helper Javascript Library (which is 2020/10/26). Follow me! Start This is the default generated attachments detail view form (DV) with a couple of fields for uploading PDF files: Schema I’m using the following data model for this attachments table: attachments idprimary key task_idlookup tasks-table filefield for uploading pdf files filenamewill be filled automatically on insert descriptiontextare for descibing or tagging this file created_on created_by modified_on modified_by Create hooks file Create a new …

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 …

Formatting numbers in SQL, PHP, JS

As a web developer, some tasks keep coming up. And every time you look for the solution in the online documentation. This includes converting numbers into different formats. On this page we summarize the elementary number conversions for SQL, PHP and Javascript How to read this page If your have an INPUT like “1234.999” and you’d like to convert in into an OUTPUT like “1.235,00” using language SQL or PHP or Javascript your can use the code shown here as a starting point. Standard number conversion Input 1234.999 MySQL/MariaDB PHP Javascript Output 1,234.999 Attention: Rounding Input 1234.999 MySQL/MariaDB PHP Javascript …