Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Interface search bar cannot return partial match results

cancel
Showing results for 
Search instead for 
Did you mean: 
LWelding
5 - Automation Enthusiast
5 - Automation Enthusiast
Status: New Ideas
What is the proposed idea/solution?

The interface search bar will return 0 results if the beginning of the string is not entered

How does is solve the user problems?

We use airtable to track our jobs.  We have several jobs that start with the same 4 digits (2714XXX).  When we search for a part we typically just enter the last 3 or 4 digits of the part number instead of the whole part number.  For example a part number 27142264 we would just enter 2264 in the search bar.  

How was this validated?

In our base if you enter 2264 in the search bar it returns 0 results, but if you enter 27142264 it returns 2 results.

Who is the target audience?

Anyone that uses the search bar and cannot remember the start of the string they are searching for or anyone that uses part numbers similar to our system.

2 Comments
Zack_S
8 - Airtable Astronomer
8 - Airtable Astronomer

The only recommendation I have is to create a formula that extracts the last 3 digits/characters of the part number. I know it's not perfect but at least that way if the user can remember at least the last 3 digits it should help narrow the search.

If the part number is a number field type use the below formula.

RIGHT(CONCATENATE({Part Number}),3)

 If it's a text field type then you only need this

RIGHT({Part Number},3)
Kirsti_Griffith
5 - Automation Enthusiast
5 - Automation Enthusiast

This is ridiculous. You can perform this search in the database, why not in interface? we need to be able to search for partial serial numbers.