I am using Filemaker Pro Advanced 8.5.

I am trying to combine some fields and add a few things to them to make a
filename for a picture file.

These are the fields I am wanting the use:


Official Name (Text)
Year (Number)
Record Number (Number)

I need to use all of the information from the fields listed above but I also
need to add a few things.

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

I have tried a few things but can't seem to get it they way I need it.

Any help would be greatly appreciated,

Thanks,
Carl

Iced Tea <icedteas (AT) cox (DOT) net> wrote:

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.

In article <tE7Jq.391$zj4.201 (AT) newsfe03 (DOT) iad>, "Iced Tea" <icedteas (AT) cox (DOT) net>
wrote:


I'm not sure what you've tried, but all you really need is the
concatenation / appending function "&" in a calculation (depending on how
you're using it it can be a Calculation Field, a Text Field using an
Auto-enter Calculation, a Script's Set Field command, etc.).
e.g.
Official Name & " (" & Year &" ") R#-" & Record Number

Of course, if these are real filenames, it will depend on the operating
system being used as to whether it likes spaces, how many characters it
will accept, or whether it allows enough characters for each name to be
unique (it might be better to put the Record Number at the start).

You will also probably need to add a suffix to match the image's filetype.
e.g.
Official Name & " (" & Year &" ") R#-" & Record Number & ".jpg"


Helpful Harry )