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

    Bulk Add new records

    thumper

      Title

      Bulk Add new records

      Post

      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
          davidanders
            

          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
            MikeyG79
              

            make a script

             

            $count=0 

            loop 

            if ($count<File::NewRecords ){

            Create New Record

            $count = $count+1

            }

            else

            Exit Loop

            }

            end loop

             

            something along those lines 

            • 3. Re: Bulk Add new records
              thumper
                 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
                thumper
                  

                elizas,

                 

                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.