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.

Preview: (Auto-) Hiding table columns in children tabs of DV

In this preview of the next version of AppGini Helper Javascript Library I show the new function “autoHide” for columns of children tabs. Please note that the functions shown here will be available by the end of 2020, probably The problem with too many columns As you may already know a master record may have detail records in a different table. AppGini can generate tabs for each detail table and will show the tabs below the master record’s data. You can see there may be many columns in the children tab table. There are a few CSS tricks to hide …

How to: Redirect to requested page after login

Sometimes, in our AppGini applications we’d like to share data with co-workers or other users by sending a link via email, for example. Unfortunately, this does not work as expected, by default. I am going to show a very simple, solution, based on our AppGini Helper Javascript Library. AppGini default behaviour By default, if we are not logged in already, AppGini redirects us to the login-page first, then to the homepage (index.php) after login. This means the user will not see the requested page unless he/she clicks the link again (or copies the url into the browser’s address bar). AppGini …

AppGini Helper PACK: New Version 1.2

New version with custom blacklist option and another option for copying required files without compressing. Compress vs. Copy When “Compress” is checked, this is the already known zip-compression: Necessary files will be compressed and stored as zip-file in a subdirectory of .release. If you unckeck “compress”, the required files will just be copied “as is” into a new subdirectory of .release. This option can be helpful for FTP upload of project files. Blacklist Now you can add custom folders and search-patterns. Folders/Files matching the blacklist will be excluded. Version 1.2 is available for download now.

BUG: display of dropdowns/lookups in tabs

There is a display bug for the add-/view- buttons next to dropdowns when applying field.dropdown().fix() on fields placed in tabs. The reason is that select2 dropdown container returns height = 0 in certain scenarios when applying the fix. Additionally there is an inheited css style for overflow-x which may hide the add-/view- buttons in certain sizing-scenarios. This bug will be fixed in next version which will be released probably in July 2020. We are sorry for any inconvenience! Refers to:

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 …

How to add a button for adding subitems to every row of table view

Adding buttons and adding links to a table view has been described in the docs. By using the %ID% placeholer you can use the record’s primary key as parameter for links. For example for opening the record in detail view. In this article we are going to use the %ID% parameter for adding a sub-item (child record / detail record) to the row. The Online Clinical Management System (OCMS), which I’m using in many examples, contains patients and appointments. Appointments are stored in a table named events. And the column name_patient has been configured as lookup field refering patients table. …

How to: re-use multi-row Batch Actions for single table rows

With Batch Actions you can execute a javascript function for all selected rows in a Table View. In this step-by-step guide I am going to show, how add a button to every table view row and execute an existing batch action on button click for that specific row. The following video show the possibilities you have with Batch Actions and additional buttons per row: Illustration If you already have a working batch action script integrated in your TABLENAME-tv.js file, you can skip steps 1 and 2 and directly head over to step 3. Step 1: Create Batch Action javascript function …