Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago

Search bar - increase character limit past 250?

I am often searching in my app among thousands of records to provide coworkers with product info. These searches are based on a list (either csv or text). There is unfortunately no way to filter, since the request-for-info lists arrive without context.  

My product codes are 10 characters. I've been able to use the "OR" function to string together around 23 codes but I can't pass the 250 character limit. This doesn't help me when I'm trying to locate info on 200-500 codes. 

I've resorted to downloading spreadsheets and VLOOKUP-ing. Is there some way, or an existing add-on that allows a solution to this "cut and paste" search challenge? 

Thanks in advance. 

16 Replies

  • I have updated my filter and am much closer to success!

    My report works now, with semi-colon delimited values. It also supports 500+ search terms.

    The only catch is: it does not display when embedded. If I enter the search terms and navigate to the report on the target table, I get the results I need. If I try to view the report embedded on the search form, it says no records are found. I've checked, and they are both the same report (or so it seems). 

    If you have a suggestion for getting the embedded report to display, I'd love to hear it. If not, this is a pretty fantastic method for searching hundreds of items and I hope others find it. 

    THANK YOU
  • OK, good progress then.

    Can you tell me the setup for the report link field?  What is on the left and what is on the right.
  • I took a look at this and - success! 

    I had it set up to match values from [Text ID#1, aka search terms] to the values in [product code field, aka target field]

    I corrected it to match [Text ID#1] to the field [Master Table: Search Table - Text ID#1] 

    This was your initial suggestion. I had assumed this was a suggestion for the table relationship and was confused. Now I understand this is the field relationship between two already related tables. 

    I am now able to search for hundreds of items at a time in a user friendly way .Thank you very much for the help. This will save me time and drive user adoption. 
  • I should clarify - I have a table called "Master Table." It is the child in this relationship, which is a little confusing.