Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #2012

Re: Filemaker - sorting

Show all headers | View raw

In article <e235bb69-7dae-4489-8e89-8dd0c5c9c2bc@googlegroups.com>,
<viking.1943@hotmail.com> wrote:
> 
> Is there anyone out there who can do some programming and write something
> that will enable me to do something that the basic Filemaker program
> apparently does not have any provision for?
> 
> I want to establish a new field, that is not a problem, but the only present
> way to put information in that field is to type it in, so if there are 50,000
> records it has to be done 50,000 times. Very impractical. I would like to be
> able to do it with one command, such as replace '    ' with 'abcd' next xxxx
> number of lines. 
> 
> In Filemkaer now you can go to the edit command and then go to "find, 
> replace" and this can be accomplished. HOWEVER you need to have something to
> find for it to be replaced. I want to be able to enter something where 
> nothing presently exists only I want to do it many times.  


1.  Create the new field as a Calculation field and set the 
    calculation as whatever text you want.
    i.e.
            NewField     (Calculation, Text Result)
                = "MyTextHere"

2.  Click the OK buttons to close all of the create field 
    windows until you are back at your usual FileMaker layout
    window. FileMaker will create the field with and 
    automatically enter the "MyTextHere" data for each
    record.

3.  Go back into the create fields window and change
    NewField to be a normal Text field (instead of a 
    Calculation field).

4.  Click the OK buttons to close all of the create field
    windows until you back at your usual FileMaker layout
    window. FileMaker will retain the calculated data 
    "MyTextHere" in NewField in each record.


Helpful Harry  :o)

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

Thread

Filemaker - sorting ihp98230 <viking.1943@hotmail.com> - 2015-02-18 14:41 -0800
  Re: Filemaker - sorting Ursus <ursus.kirk@ziggo.nl> - 2015-02-19 00:03 +0100
    Re: Filemaker - sorting ihp98230 <viking.1943@hotmail.com> - 2015-02-18 15:29 -0800
      Re: Filemaker - sorting Ursus <ursus.kirk@ziggo.nl> - 2015-02-19 00:51 +0100
        Re: Filemaker - sorting ihp98230 <viking.1943@hotmail.com> - 2015-02-18 17:25 -0800
          Re: Filemaker - sorting dempson@actrix.gen.nz (David Empson) - 2015-02-19 16:08 +1300
            Re: Filemaker - sorting ihp98230 <viking.1943@hotmail.com> - 2015-02-18 19:38 -0800
              Re: Filemaker - sorting dempson@actrix.gen.nz (David Empson) - 2015-02-19 17:25 +1300
                Re: Filemaker - sorting Ursus <ursus.kirk@ziggo.nl> - 2015-02-19 09:59 +0100
                Re: Filemaker - sorting viking.1943@hotmail.com - 2015-02-22 06:00 -0800
                Re: Filemaker - sorting Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-02-23 08:54 +1300
  Re: Filemaker - sorting Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-02-19 13:16 +1300
    Re: Filemaker - sorting John G <john.g@green.com> - 2015-02-23 11:01 +1100
      Re: Filemaker - sorting Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-02-23 16:38 +1300
        Re: Filemaker - sorting John G <john.g@green.com> - 2015-02-23 15:39 +1100
          Re: Filemaker - sorting viking.1943@hotmail.com - 2015-02-23 19:25 -0800

csiph-web