Interface search bar cannot return partial match results

[LWelding]

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.

[Zack_S]

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]

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.