1 Reply Latest reply on May 23, 2012 4:55 AM by Sorbsbuster

    quick find half a value, does that not work?

    microbatteryshop

      Title

      quick find half a value, does that not work?

      Post

      Maybe its a stupid questionEmbarassed. But i use a script to search for products in my table.

      so far so good. It works. However lets asume i search for  "SBCSFCRP1632" when i enter it completely it works. when i enter "SBCSFCRP" i get more results. ok.

      However, when i enter " 1632" i get an error. And i get the same results in the standard search field from filemaker at the top right.

      I tried "*1632" but again not possible.

      Does someone have a solution?

      "snel zoeken uitvoeren" should be "execute fast search" or something in englisch

      this is the script:

      Snel zoeken uitvoeren (PRODUCTS:: search_product) 

      many thanks for your help gues

        • 1. Re: quick find half a value, does that not work?
          Sorbsbuster

          If you use an 'ordinary' Find for 1632 it will not find that in the middle of the text.

          If you use an 'ordinary' Find for *1632 it will find that in the middle of the text.

          If you use QuickFind it will not interpret the *1632 correctly (I only just tested that, so I've learned something new).

          If you script the find and set the search field to be *1632 it will find it.  I assume your field is defined as text.