Combine 7 fields into one field with custom inserts

[MachineMan]

Hey all,

Ok so here is what I am trying to figure out.

I have a layout with 7 fields in it.

they are [machine name, model, serial#, specs, equiped with, price, and FOB]

what I want is to gather the data from all 7 fields and place it into one large field for copy pasting into an email. but I need to insert the field names into the data also.

for example say I have a record like this

machine name: mill

model: a1

serial#: 1234

specs: 9x32 table

2hp motor...

may be anywhere from 1-15 lines of text in this

equiped with:again could be several lines here

Price: $1,000.00

FOB: somecity, USA

I want to copy all the data from each field into one big field we will call

it email. but before each piece of data I want the field name placed also.

so taht basically the field looks like

mill

model: a1

serial#:1234

specs: and all info from the field

Equiped with: info from field

Price: $1,000.00

FOB: somecity

that way I just copy the one field of data instead of having to go field to field to copy paste it all.

thanks for your help

Thomas

[Fitch]

Create a calculated field:

(I'm using PP as the carriage return symbol)

"mill" & PP &

"model: " & field A & PP &

"serial#: " & field B & PP &

"specs: " & field C & PP &

etc.

That's the basic technique of putting blocks of text together: any text that's not in a field needs quotes around it, and you string it all together with ampersands.

Alternatively this could be done with a script that creates the email, no copy/paste required. The calculation would be the same, but you could do it without the extra field.

[MachineMan]

Thanks Fitch,

That was actually easier than I expected and making it as a script to put the info right into the email message body takes one more step out of the process. I swer anyone that does work in an office should be using FMP it makes life so much easier for repetitive tasks and keeping track of data. That can be completly customized to your needs.

Create a calculated field:

(I'm using PP as the carriage return symbol)

"mill" & PP &

"model: " & field A & PP &

"serial#: " & field B & PP &

"specs: " & field C & PP &

etc.

That's the basic technique of putting blocks of text together: any text that's not in a field needs quotes around it, and you string it all together with ampersands.

Alternatively this could be done with a script that creates the email, no copy/paste required. The calculation would be the same, but you could do it without the extra field.