Form Tools
Advanced or Multiple Search - Printable Version

+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: Feature Suggestions (https://forums.formtools.org/forumdisplay.php?fid=7)
+--- Thread: Advanced or Multiple Search (/showthread.php?tid=91)



Advanced or Multiple Search - harmony - Mar 27th, 2009

Does anyone know how easy it would be to add a custom search option to the API so that users could search by more than one criteria?

Example: Search by field 1 and field 2 but not field 5

or: search by field 1 or field 2

or: search by field 1 and field 2 and field 3 (every field in the form)

etc?


RE: Advanced or Multiple Search - Ben - Mar 30th, 2009

Hey Harmony,

This is a great idea. It's definitely do-able, but it would still take a couple of hours to puzzle through.

The ft_api_show_submissions function which lists submissions from the FT database currently allows a number of different option parameters; it would just be a matter of adding a search option to allow for this.

But I'm afraid it's going to have to wait! I have a lot of other stuff to focus on first.

Sorry, Harmony. Bug me about this again sometime in the future.

- Ben


RE: Advanced or Multiple Search - harmony - Mar 30th, 2009

Thanks very much for the reply Ben! You guys are amazing!


RE: Advanced or Multiple Search - ggaffield - Feb 9th, 2015

(Mar 30th, 2009, 10:45 AM)Ben Wrote: Hey Harmony,

This is a great idea. It's definitely do-able, but it would still take a couple of hours to puzzle through.

The ft_api_show_submissions function which lists submissions from the FT database currently allows a number of different option parameters; it would just be a matter of adding a search option to allow for this.

But I'm afraid it's going to have to wait! I have a lot of other stuff to focus on first.

Sorry, Harmony. Bug me about this again sometime in the future.

- Ben

I sure could use this kind functionality. I'm currently rolling this out to my users, and it's the first thing they noticed and said was going to be a problem.

Not only would they need to able to say Field A contains "X" AND Field B contains "Y". They would also like to specify value ranges. equal to, less than, greater than, between.

-Glenn


RE: Advanced or Multiple Search - haneeya - Mar 23rd, 2015

I'd like to see a date filter option for the standard view filter. I would like to filter out results with entires that are prior to current date.


RE: Advanced or Multiple Search - nelsondcosta - Dec 24th, 2017

Any news?


RE: Advanced or Multiple Search - weems085 - Dec 30th, 2017

I would like to filter out results with entires that are prior to current date.


RE: Advanced or Multiple Search - nelsondcosta - Jan 2nd, 2018

Maybe FT4 can hold this feature Smile