So many users tell us how much they like the hooks feature in AppGini. It allows almost unlimited ways to customize the generated AppGini apps; changing appearance, adding features, pages, rapid workflows, … etc. In fact, users really surprise and amaze me with the very creative things they do using hooks. Due to the power […]
Category Archives: Customizing AppGini Apps
Prevent specific groups from directly accessing a table in AppGini
In some application scenarios, you might meet the usage case where you want one or more user groups to be able to access a table only if it’s displayed as a child table, but not directly as a master table. Let’s take an example from the Northwind demo. Let’s say you have a users group […]
A work-around to implement a multiple choice lookup field in your AppGini apps
AppGini provides a multiple choice option list field, which is a handy way to allow users of your app to select multiple values from a list, for example to add tags/labels for a record. This is how it works: And this is how to configure it in AppGini: There is a problem with the above […]
Using full-text searches with AppGini apps
I recently received a very interesting question from an AppGini user regarding implementing full-text searches in AppGini apps. The user had a table containing millions of records, and normal search operations on a text field took too long (about 1.5 minutes according to the user). When he tried adding a full-text index on that field, […]
How to hide columns in table view based on user group?
I got a question from an AppGini user on how to hide specific columns in the table view based on the user group. This blog post explains how to do this through hooks. As an example, we’ll modify the orders table of the Northwind demo to hide the ‘Customer’ column for ‘Suppliers’ and ‘anonymous’ groups, […]
Overwriting AppGini functions, allowing admin group members to access the admin area
Heads-up! We’ve recently added an option to allow Admins group members to access the admin area (except the admin settings page). So, the code listed here for overriding getLoggedAdmin() is no longer necessary if you’re using AppGini 22.12 or above. The code for overriding generated functions is still applicable though if you need to override […]
Make it mandatory for new users to agree to terms and conditions before signing up
I got a question from an AppGini user on how to make it a requirement for users to check an ‘I agree’ box when they sign up to AppGini — possibly as part of GDPR compliance, or to agree to some other terms and conditions. We do plan to add support for this as part […]
Displaying count of child records on the tab title
AppGini supports displaying a list of child records in the detail view of the parent record. For example, here is the detail view of an employee record from the online Northwind demo: (Ignore the weird cartoons for now!) So … It would be nice if the count of subordinates is displayed on the ‘Subordinates’ tab, […]
Retrieve a list of users who haven’t made any activity in the last x months
I just got an interesting question from an AppGini user: Is there an SQL query that I can run manually in PhpMyAdmin that will show me a list of all users that haven’t logged into AppGini for the last 6 months please? Even if it is using one of the date fields in the membership_users […]
Hiding the nicedit component from a page
AppGini uses nicedit Javascript component for displaying rich text areas, where users can enter formatted input. You might wish to hide/show the rich editor in an AppGini page, or in one of your custom pages. This can be done using JavaScript code. To hide nicedit components in a page:
1 2 3 4 |
$j(function() { $j('.nicEdit-panelContain').parent().addClass('hidden'); $j('.nicEdit-main').parent().addClass('hidden'); }) |
To show nicedit components:
1 2 3 4 |
$j(function() { $j('.nicEdit-panelContain').parent().removeClass('hidden'); $j('.nicEdit-main').parent().removeClass('hidden'); }) |
[…]