For the back end views, we would want to be able to search / filter the results based on the date inputted for pickup, search by User ID (or something else that can be used as a reservation number) and to search by a few other fields. can i be able to add those three options to the search?
There are no limits to what you can do with searching Formidable data. If you understand Formidable's database schema, you can even write your own custom SQL to generate a results set for your views. This example is a customized search solution that searches multiple data points: https://formidable-masterminds.com/developers-directory/