Tip: Print multiple detail view pages with page-break
Printing multiple custom detail views page by page can cause problems because they are printed continuously by default and not page by page. I show a simple trick to solve this problem.
Category: Webdevelopment
Styling a Table View: a step-by-step example
After we took care of the styling of the Detail View last time, today I will adapt the corresponding Table View. Initial situation Remove links First I would like to remove the links so that the values in the table are shown as text, not as a link. I could and should have done this already during modelling, but I did not. So I have to do it in AppGini – field by field. Then save and regenerate. Except the file link (download) there are now only values in the table. If I want to open a record, I need …
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 …
Quickie: Insert heading above (children-) tabs
Just a short script-fragment. A customer asked for a heading above children tabs. There is not much to do, and nothing complicated. Just add the following code to your hooks/TABLENAME-dv.js file and change the text between <h1> and </h1>. Code Result Tip: do not insert headline in insert-mode If you do not want to see it in insert-mode, just check if we are in insert-mode or not. Using our AppGini Helper Javascript Library there is a useful function isInsert() for this: Note the exclamation mark “!” right before dv.isInsert() function call: The exclamation mark means logical not. If it is …
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: 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: Table View with Open Street Map (OSM)
Showcase: Using Leaflet for interactive maps in AppGini application
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 …