Re: Need help???

Newsgroups	comp.databases.filemaker
Subject	Re: Need help???
From	jrijnb@xs4all.nl (Hans Rijnbout)
Date	2011-12-24 01:19 +0100
Message-ID	<1kcr9v4.16a8pn47vfrb4N%jrijnb@xs4all.nl> (permalink)
References	<tE7Jq.391$zj4.201@newsfe03.iad>

Show all headers | View raw

Iced Tea <icedteas@cox.net> wrote:

> I am using Filemaker Pro Advanced 8.5.

> Here is a sample of data from one of the records.
> 
> Official Name: TUBE
> Year: 2011
> Record Number: 4210
> 
> I want the filename to look like the sample I have below and the underscores
> are actually spaces.
> Filename example: TUBE_(2011)_R#-4210

Filemaker has a lot of text functions and formulas that you may use in
calculations or scripts to perform this kind of operations.
You may open Filemaker Help from the Help menu and go to:
"Designing and creating databases > Creating a database > Working with
formulas and functions"

In your case the formula would be:

(filename = ) Official Name & " (" & Year & " )#-" & Record Number
(Mind the spaces within the quotes)

Most of this stuff is being covered in the User Manual.

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

Thread

Need help??? "Iced Tea" <icedteas@cox.net> - 2011-12-23 16:54 -0600
  Re: Need help??? jrijnb@xs4all.nl (Hans Rijnbout) - 2011-12-24 01:19 +0100
  Re: Need help??? HelpfulHarry@BusyWorking.com (Helpful Harry) - 2011-12-24 13:26 +1300

csiph-web