2 Replies Latest reply on Oct 29, 2015 2:24 PM by rtolliver

    Find Script: how to differentiate find data

    rtolliver

      I have a Find script that returns data that is based on criteria set in 2 fields. The script has been working fine until I found that it didn't differentiate between 2 record numbers (54394-1, 54394-10), I searched for 54394-1 and the script returned information for 54394-10.

       

      What do I need to add to my script to get the correct record?

        • 1. Re: Find Script: how to differentiate find data
          erolst

          A search is performed against word starts – and seeing your serial “number” format, this field is text. (In a number field, a search for 543941 would NOT find 5439410.)

           

          Try using the = or == operator to match against the entire word (or field, depending on your data and intentions), like

           

          Enter Find Mode

          Set Field [ Table::serial ; "==" & SomeSerialNumber ]

          Perform Find

          • 2. Re: Find Script: how to differentiate find data
            rtolliver

            I've tried your suggestion and I get "error 401".  When I look on the layout in the field specified in

            Set Field [ Table::serial ; "==" & SomeSerialNumber ] I find "==SomeSerialNumber". The == has been added to serial number which causes the find to fail.

             

            Is there something else needed?