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
-
@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 ?????
-
@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