6 Replies Latest reply on May 19, 2016 1:32 PM by atwocon

    Search Script Query

    atwocon

      Hi All,

       

      I am new to FileMaker and currently using FMA 10. I have been trying to make a script to perform a serarh and retrieve task, but struggling to say the least

       

      At present i have two tables, one is Server Stock, Global stock and a table with a (Search) global field for the purpose of the search script.

       

      I am trying to achieve the following;

       

      upon entering a number into a field on thr server layout linked to Search, the below script 'concept' is triggered

       

      Goto Table (Search)

      Get value from name field

      Goto Global table

      Find matching values

      Import finding into server stock

       

      Any help would be appreciated.

       

      Kind Regards

        • 1. Re: Search Script Query
          beverly

          Can you print (or screenshot) the actual script and post?

          beverly

          • 2. Re: Search Script Query
            atwocon

            Hi Beverly,

             

            Thank you for coming back to me on this,

             

            the script i currently have is below, I fear that it may be quite a way 'off the mark' for what I actually need

            script.png

            Below is the (unfinished) Server Stock layout with a field linked to the Search Table (global field called Search)

            search field.png

             

            I am trying to get the script to trigger when a value is enter via my barcode scanner, once start it gets the value in the search field, then searches for matches in the Global stock table and imports all found results to the Server stock table.

             

            the search is looking in a field called Cage ID in Global stock table

            global table.png

             

            Any help would be greatly appreciated

            • 3. Re: Search Script Query
              atwocon

              I think I am closer to achieving my on this

               

              My only issue is for some reason the script is importing all of the Global Table contents and not the contents that match the global search value which for the purpose of testing is one Cage ID (111)

              222.png

               

               

              Please could someone kindly advise where I am going wrong?

               

              Kind Regards

              • 4. Re: Search Script Query
                beverly

                I'll have to study this further. I'm not sure "Import" is the method I use. I believe mostly, I loop and Set Fields.

                beverly

                • 5. Re: Search Script Query
                  SteveMartino

                  After you Enter Find Mode, don't you need to set a field before you perform the find?  Just wondering.

                  • 6. Re: Search Script Query
                    atwocon

                    I managed to get it working!

                     

                    haha. yuuussss.png

                     

                    Some tweaking and typo correction still required but it works