Creating custom search or filter

[johnbek]

Hey guys.

I have created a database application that is meant to track inspectors, and their certifications.
Right now, we have 5 certifications we are trying to track, so in the database there are columns for each certification, and a date recorded to each inspector as to when they recieved their certificate.

I would like for employers/users of the database to be able to search for these people based on which certifications they have (users that have a date/data recorded under that particular field).
Right now, the only way to do this is to use the filter, and select the certification, and select "is not empty"...
While this works, its not very user friendly for some of the people who may not be as familiar with using databases.

I would like to create a place on the appgini app, where they can do to a "search by certificate" search form, and check the boxes for which certifications they are looking for.. I would then like the search form to go and look up any inspectors in the database that contain data for the certifications that were checked off in the search form, and display them in a list.

Is this possible?

Thanks
John

[peebee]

This should hopefully help you: https://bigprof.com/appgini/tips-and-tu ... arch-forms

If you are interested in a more in-depth tutorial, AppGini has a premium Udemy course with a specific section on creating customised search forms:

https://www.udemy.com/customizing-appgi ... lications/ (Section 6)

[grimblefritz]

AppGini also sells a Search Page Maker plugin that makes searching much easier for normal, non-technical users.

https://bigprof.com/appgini/application ... ker-plugin