2 Replies Latest reply on Mar 16, 2009 11:07 AM by philmodjunk

    moving the 'record pointer'

    synergy46

      Title

      moving the 'record pointer'

      Post

      I have a found set of records in list view.  I want to examine each field in the record, concatenate the date field with the record before and the move the record pointer down and do it again.

       

      I got everything working except I can't figure out how to move the record pointer to the next record???

       

      Thanks for your ideas.

       

        • 1. Re: moving the 'record pointer'
          obeechi
            

          Script Steps: 

          Go to Record/Request/Page[Next] -- specify Next using the drop down menu in ScriptMaker

          Go to Field[...] -- where "..." is what you specify in ScriptMaker

           

          Mind you, I don't think the Go to Field[] step will work if you're not in a layout that contains/shows the field ... so set context in the script by using a Go to Layout script step before the Go to Field[] step

           

          Let me know if the works, and correct me if I'm wrong ...  

          • 2. Re: moving the 'record pointer'
            philmodjunk
              

            Set Field [gDateList,""]--gDateList is a global text field

            Loop

               Set Field[gDateList,gDateList & getastext(datefield)]

               Go to next record [exit after last]

            end loop

             

            Alternatively you can use set variable instead of set field, depending on what you want to do.

             

            Believe it or not, there once was a time when "Go to next record" with the exit after last option was the ONLY type of repetitive task you could script in FileMaker!