Groups | Search | Server Info | Login | Register

Groups > comp.databases.filemaker > #425

Re: Insert a record

Show all headers | View raw

In article <ws21-0C32B3.14035206102011@newsstand.cit.cornell.edu>,
 Bill Steele <ws21@cornell.edu> wrote:

> In article <slrnj8pf2t.2js2.t-usenet@ID-685.user.individual.de>,
>  Martin ɱrautmann <t-usenet@gmx.net> wrote:
> 
> > On Wed, 05 Oct 2011 16:06:44 -0400, Bill Steele wrote:
> > >  By default, records appear in table view in creation order, so new 
> > >  records appear at the bottom.
> > > 
> > >  Is there any way to insert a new record higher up the list? Or a way to 
> > >  move rows up or down?
> > 
> > 
> > sort.
> 
> Not the whole page. One record at a time. Insert a new row where you 
> want it, like in Excel.

You would need to create a field ("order"), then create a script linked
to a button on each row of your table that will create the new record,
set "order" on the new record to the value from the original record in
that row and renumber all successive records.

It would, quite frankly, be easier to use Excel to do what you want.
Then, if you need that data in FM, import it into an empty clone of the
DB so that the creation order will match the row order in Excel. Clunky,
though, since you'll end up with a new copy of the DB every time you
want to add a single new record.

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Insert a record Bill Steele <ws21@cornell.edu> - 2011-10-05 16:06 -0400
  Re: Insert a record Martin Τrautmann <t-usenet@gmx.net> - 2011-10-05 20:21 +0000
    Re: Insert a record Bill Steele <ws21@cornell.edu> - 2011-10-06 14:03 -0400
      Re: Insert a record David Stone <no.email@domain.invalid> - 2011-10-07 09:12 -0400
  Re: Insert a record John G <greentest@ozemail.com.au> - 2011-10-07 07:55 +1100
    Re: Insert a record clkaufmann@gmx.ch (Christoph Kaufmann) - 2011-10-07 20:46 +0200
  Re: Insert a record Bill Steele <ws21@cornell.edu> - 2011-10-24 13:21 -0400
    Re: Insert a record yourname@yourisp.com (Your Name) - 2011-10-25 13:26 +1300
      Re: Insert a record yourname@yourisp.com (Your Name) - 2011-10-25 16:14 +1300
        Re: Insert a record Bill Steele <ws21@cornell.edu> - 2011-10-25 15:00 -0400
          Re: Insert a record yourname@yourisp.com (Your Name) - 2011-10-26 09:10 +1300
          Re: Insert a record cortical <cb@corticaldata.com.au> - 2011-10-27 09:17 +1030
            Re: Insert a record Bill Steele <ws21@cornell.edu> - 2011-10-27 14:53 -0400
              Re: Insert a record cortical <cb@corticaldata.com.au> - 2011-10-29 08:26 +1030
                Re: Insert a record yourname@yourisp.com (Your Name) - 2011-10-29 11:19 +1300
                Re: Insert a record cortical <cb@corticaldata.com.au> - 2011-10-30 01:41 +1030

csiph-web