5 Replies Latest reply on Feb 25, 2009 12:46 AM by comment_1

    ANYONE CAN HELP ME~

    ERIKCHAN

      Title

      ANYONE CAN HELP ME~

      Post

      I want to make a report to show in TABLEA FIELDA=RICK

      HOW MANY RECORD FIELDB = In Progress

      HOW MANY RECORD FIELDB = Begin

      HOW MANY RECORD FIELDB = Finished

      The report look like that

      RICK

      IN PROGRSS : XXX (TABLEA::FIELD_R1)

      BEGIN : XXX (TABLEA::FIELD_R2)

      FINISHED : XXX (TABLEA::FIELD_R3)

      Below is my script...

      Enter Find Mode []

      Set Field [TABLEA::FIELDA; "RICK"]

      Set Field [TABLEA::FIELDB; "In Progress"]

      Perform Find []

      insert Calculated Result [Select; TABLEA::FIELD_R1; Get ( FoundCount )]

      New Record / Request

      Enter Find Mode []

      Set Field [TABLEA::FIELDA; "RICK"]

      Set Field [TABLEA::FIELDB; "Begin"]

      Perform Find []

      insert Calculated Result [Select; TABLEA::FIELD_R2; Get ( FoundCount )]

      New Record / Request

      Enter Find Mode []

      Set Field [TABLEA::FIELDA; "RICK"]

      Set Field [TABLEA::FIELDB; "Finished"]

      Perform Find []

      insert Calculated Result [Select; TABLEA::FIELD_R3; Get ( FoundCount )]

      Go to Layout ["Report" (TABLEA)]

       

      Unlucky, The result cannot show correctly. Can anyone tell me how can I do?

      I think my script have problems. But I don't know how can I do? Please Help~

        • 1. Re: ANYONE CAN HELP ME~
          ERIKCHAN
            

          I solved the problem.

          I edit all value field to be a global field.That can solve the problem.

           

          On the other hand, I need to find out not equal record by using script.
          Because this is a part of script also.

          I need to find a people who all records not equal to some wordings in a field.
          For example.
          I want to find All RICK records
          All records not equal to FIELDA="A" and FIELDA="B" and FIELDA="C"

          How can I write this script?

          Thanks a lot





          • 2. Re: ANYONE CAN HELP ME~
            comment_1
              

            hiatts wrote:

            I have never found filemaker to have a find when not equal... 


            Checking the 'Omit' flag does that.


            • 3. Re: ANYONE CAN HELP ME~
              ERIKCHAN
                

              Yes, I know I can use omit function to do that.

              But how can I write the script to find a people who are not equal to some wordings records?

               

              If I develop this scipt

               

              Enter find mode[]

              Set Field[Name: "RICK"] 

              Set Field[FIELDA; "A"]

              Set Field[FIELDA; "B"]

              Set Field[FIELDA; "C"]

              Omit Record

              Perform Find[] 

               

              That script only can show all not equal to "RICK" , "A" , "B" , "C" records,

              But I want to find All RICK's records that not equal to  "A" , "B" and "C". 

              How can I write the script?

              Thanks~ 

              • 4. Re: ANYONE CAN HELP ME~
                comment_1
                  

                 Try it this way:

                 

                Enter Find Mode []

                Set Field [Name; "RICK"] 

                New Record/Request 

                Set Field [FIELDA; "A"]

                Omit Record

                New Record/Request

                Set Field [FIELDA; "B"]

                Omit Record

                New Record/Request

                Set Field [FIELDA; "C"]

                Omit Record

                Perform Find []

                 

                 

                • 5. Re: ANYONE CAN HELP ME~
                  comment_1
                    

                  hiatts wrote:
                  omit in find mode is the same as finding in a script then showing omitted

                  Not really - esp. when you are using multiple requests, as you must here.