Mar 21st, 2016, 6:54 AM
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.
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.