4 Replies Latest reply on Jan 14, 2010 7:11 AM by thumper

    Bulk Add new records



      Bulk Add new records


      hey guys!


      i see how everyone is bulk editing records, but i cant find any documentation on bulk adding records, i have a number field in the table i want bulk records added to, and i want the script (button) to add as many records as in the bulk "how many to add" field , anybody have any knowledge on this?



      Thanks in advanced.

        • 1. Re: Bulk Add new records

          When adding fecords, from an excel file, for instance, the import will add as many rows as in the excel file.

          When adding records, from another filemaker database, import will add as many records is in the found set of the database.

          The control is in the originating file, not the recieving file.

          Although, after the import, a find and delete could be done. 

          • 2. Re: Bulk Add new records

            make a script




            if ($count<File::NewRecords ){

            Create New Record

            $count = $count+1



            Exit Loop


            end loop


            something along those lines 

            • 3. Re: Bulk Add new records
                 this is not to import any files, its strickly creating new records from scratch using pre-enterd fields, but i just need it to loop the amount of times that the number in the "how many to create" field is .
              • 4. Re: Bulk Add new records



                thanks for the link, although it doesnt help me much with this problem, it really helped me out with another issue i would have probably had trouble with in a couple days and i learned a few new things which is always good lol, thanks again.