SIGN UP

lookup an ID and edit 1 field

By: Shawn Fawcett | Asked: 06/17/2022
Forums › Category: How-to › lookup an ID and edit 1 field
0 Vote Up Vote Down
Shawn Fawcett asked 2 years ago
I have a list of entries with a field called QRID. I would like to have a lookup to find that QRID. If it exists show the QRID and if it does not exist show "no records found". Once the record is found I want to just show 1 other field to edit. How could I do that? Hopefully the example will help. Example: I have a QRID of 22 and this entry has a field URL. The value for this field is: https://mysite.com/unassigned. I would like the user to be able to change the URL to their new page: https://mysite.com/newpage.
1 Answers
1 Vote Up Vote Down
Victor Font answered 2 years ago
First yo create a search form: https://formidableforms.com/knowledgebase/create-custom-search-form/ Then you have to decide how to display the field, either by editing it on the form or front end editing in a view. The how varies based on your design requirements.
Shawn Fawcett replied 2 years ago

ok, I have the search part working but it is showing ALL of the records if nothing is entered in the search. I need it to filter everything unless the filter is a match: "QRID is equal to [get param=QRID]"

Shawn Fawcett replied 2 years ago

I added an OR statement QRID is equal to a random text (ie "ditW") and it seems to work. Let me know if there's a better way.

Victor Font replied 2 years ago

Excellent! If it works, leave it alone. Make sure the random text is not anything that could possibly show up in that field in the future.

Shawn Fawcett replied 2 years ago

Haha, I guess right? It just seems to have the opposite behaviour of a database. When one filters in a database the filter is applied (or can be) at all times. The default seems to be show everything until a parameter is entered, then the filter is activated

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