Shawn Fawcett asked 3 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.
Victor Font Staff answered 3 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 3 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 3 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.
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 3 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
Please login or Register to submit your answer
