The following warnings occurred: | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.31 (Linux)
|
![]() |
Form Tool Admin Search Empty Field - Printable Version +- 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: Form Tool Admin Search Empty Field (/showthread.php?tid=558) |
Form Tool Admin Search Empty Field - Johhhn - Mar 8th, 2010 First off-- GREAT Product!!! ![]() My question is-- is there a way to search for blank or empty fields in the Forms Admin Backend? or Exact phrases? thanks for making a great tool! John RE: Form Tool Admin Search Empty Field - Ben - Mar 11th, 2010 Hi John, Eesh, unfortunately the existing search feature isn't terribly strong, so you're rather out of luck. Searching for blank fields can't be done, because the search tools requires you to enter a search string. All you could really do is create a View for each search that you'd like to do. That would allow you to limit the results in that View to only show results that had empty values for a particular field or fields. Not ideal, but it's at least a workaround. And searching for exact phrases isn't exactly possible either. :-( The SQL SELECT statement that's generated for the searches wraps the string in "%" characters so that ANY results that have that entire string in it will be returned. You could again try getting around this with Views, but I'm not sure that would work... still, worth a shot. Providing a better search tool is definitely a priority. Once I finish up work on the translations and I can start getting back to main Form Tools development I'll definitely keep this in mind. Sorry I couldn't be more help! - Ben RE: Form Tool Admin Search Empty Field - Johhhn - Mar 11th, 2010 (Mar 11th, 2010, 8:12 PM)Ben Wrote: All you could really do is create a View for each search that you'd like to do I'm not quite following you-- how would this help exactly? RE: Form Tool Admin Search Empty Field - Ben - Mar 11th, 2010 Ah sorry, I wasn't very clear. My point was that Views let you add one more filters. You could create a View with a filter that returns all results where Field A == "" (empty). That would let you bypass the search tool and instead pick a View to "search" that subset of data. The View filter settings provide a little more control than the search. Depending on your data set this may not be feasible (e.g. if you had to create 100 Views), but it's still an option. - Ben RE: Form Tool Admin Search Empty Field - gazoobajp - Jun 7th, 2020 Do you need group insurance springfield il? RE: Form Tool Admin Search Empty Field - saeed20 - Jun 16th, 2020 online healing courses |