SIGN UP

Formidable Forms - Searchable Database not functioning "No Entries Found"

By: rahcel yang | Asked: 06/10/2024
Forums › Category: General questions › Formidable Forms - Searchable Database not functioning "No Entries Found"
0 Vote Up Vote Down
rahcel yang asked 6 months ago

Dear all, I have a trouble while try to build a search page, which perform a search in the database. I have followed this page https://formidableforms.com/knowledgebase/create-custom-search-form/ ,   https://formidableforms.com/how-to-create-a-custom-search-form-in-wordpress/ 
and this video https://www.youtube.com/watch?v=SgNNACpa2qI&t=295s

  1. build a form that countains data imported from csv
  2. create and display a view base on this form
  3. create a search form, create the bottoms with default settings suchas [get param= cname], also create a response that redirect to the page where view was displayed, with parameter such as ?cname=[36], which is the key of the parameter I want to search in the view.
  4. create a filter on the view, for example COUNTRY contains [get param= cname]

However, after I update all of these the search is not going, it shows '"No Entries Found"'. I don't know where went wrong, please help me! (problems that can be excluded are:

  1. the view is working, because if I replace [get param= cname] to italy, the view works
  2. the parameter can be successfully inputed, because if I input Italy, the url change to ?cname=Italy)
1 Answers
0 Vote Up Vote Down
Rob LeVineRob LeVine answered 6 months ago
I imagine I could debug it in short order if I had access to the pages, but in the absence of that, I suggest you remove the filter from the view and let the view display all its data in this scenario. If nothing is displayed then that tells you something. Otherwise, make note of the data to see exactly how what the database has and then add a hardcoded filter back in and rerun it and see what effect it has.
rahcel yang replied 6 months ago

Thank you Rob for the reply! However, I have tried the method, first I have tried without filtering the view, the search can return the whole view without filter. Then as I mentioned, I filtered the view with 'italy' instead of [get param= cname], it worked on the view. however, when I put the same filter on return url and view filter, it shows no entries found.

Rob LeVineRob LeVine replied 6 months ago

Try [get param="cname"]

rahcel yang replied 6 months ago

Thank you but unfortunately it's still 'no entries found' ,I don't understand, the searching page is intaking the parameter and responding well(for exmaple it can return:"xxxxxx/database-table-view/?cname=italy" when i search italy), and the view is functioning well when i just input italy instead of [get param="cname"], something must be wrong with linking the search form to the view, I'm confused.

Rob LeVineRob LeVine replied 6 months ago

I'm going to have to tap out on this one. If you want to hire me to debug it, I can do that. My rates are very reasonable. I'm sure the issue is simple and wouldn't take more than an hour (minimum time).

Making the Best WordPress Plugin even better - Together

Take on bigger projects with confidence knowing you have access to an entire community of Formidable Experts and Professionals who have your back when the going gets tough. You got this!
Join the community
crossarrow-right