+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: General Discussion (https://forums.formtools.org/forumdisplay.php?fid=5)
+--- Thread: Complex searchs (/showthread.php?tid=12279)
Complex searchs - rollinger - Mar 21st, 2016
Hi there. Form tools is a great piece of software, and I am loving to use it. It is really shortening development time.
I have a question about searches. I have read hips of posts but I am still missing something.
Let me tell you my case and if you could help me, I ask to kindly do it.
Last year I became a real estate broker and been collecting homes and companies data to work with. With 300 addresses collected, is becaming ever so hard to manage.
I am also a computer programmer with over 30 ys experience. So I decided to build a database to help my work.
After a few days, it is almost ready. What I miss is a better search. I read lots of posts and the Dev. says to use views and filters.
Could be fine, but every search I do have different parameters.
As examples, see a few searchs I do:
Rows with price between such and such (could also be rent, taxes, and other number fields).
Rows that belong to a specific neighborhood, or many neighborhoods (as in multi select)
Rows that belong to a specific street
Rows with flats built at the max X years ago.
Also, combinations like:
Rows with flat in street X that the rent is between A and B and that have a swimming pool.
And many more searchs and combinations.
Some more info:
The forms and DB are ready. Only this search issue remain.
I am using only internal forms as there is only one client (me).
Would like to avoid but If I cannot find a simple sollution, I may hard code it in file /ft/clients/forms/index.php
If the sollution it in the filters, I am missing the way to send filter parameters on the fly (dinamycally).
Do you (Devs and community) have any advices?
Thanks in advance.