0

Searching records - no results for partial text

I have an products table with an SKU field, eg PSB-C-0107

 

When I go to add a product from my order line items, and select to add a record from products, I have to type in the full SKU - PSB-C-017. If I type in just 0107, no results are returned.

 

Any way around this? I have a feeling I'm going to have to create a field for SKU prefix, then a field for the unique product number?

2 replies

null
    • Mconneen
    • 5 yrs ago
    • Reported - view

    @Sarah... Interesting.. I never really paid attention to how Ninox did a record search.   It appears to be "word" boundry oriented.. as PSB-C-0107 is "one word" (aka no spaces) Ninox will not find the substring "0107".  That said.. it appears your SKU numbers have some reason to them.  PSB C 0107....  A few strategies...

    1.  Break them up into three fields... and a formula display field. 

    2.  Create a formula search field that replaces the "-" with a " " 

    3 ????? 

    • SECOS Group
    • quartz_cap
    • 5 yrs ago
    • Reported - view

    @Mconneen 

     

    Thanks for replying :) Yeah, we have PSB-C-#, PSB-H-#... some of our product doesn't have the same structure but honestly I can give it a prefix for this case

     

    I like your formula search field idea though!

Content aside

  • 5 yrs agoLast active
  • 2Replies
  • 1364Views