AnsweredAssumed Answered

Duplicating a set of records and loop

Question asked by VictorWarner on Sep 11, 2015
Latest reply on Sep 11, 2015 by erolst

I am new to Filemaker and particularly scripts.


I would like to duplicate a set of records which I have found used Find. From searches on the internet I know I need to use a script and the loop command.


The database has 4 fields:


Serial Number, Name, First name, Record Number.


I find a set of records based on the Name field, and say returns 4 records and I wish to duplicate all of them.


The script is a follows:


Go to Layout [ “Layout #2” (TableTable) ]

Show All Records

Go to Field [ TableTable::Name ]

Enter Find Mode [ ] [ Pause ]

Perform Find [ ]

Sort Records by Field [ Ascending; TableTable::Name ]

Go to Record/Request/Page

  [ First ]


  Duplicate Record/Request

  Go to Record/Request/Page

  [ Next; Exit after last ]

End Loop




The above script only duplicates the first of the 4 records.


The examples I have seen from my searches seem too complicated for my simple needs.


I would be grateful for any help.