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.

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

that worked exactly the way I wanted it too THANK YOU VERY MUCH Thomas

is there a way setup a button to delete the first line of text in a field? I have a field on my layout that I parse address info from into the corresponding fields in my database. after I parse the text I'd like to click a button and delete the line of text from my copypaste field I just want to remove the first line of text without having to manually highlight the text then delete it. I'ts actually going to be removing the top 6-10 lines but I figure I can have it repeate or just press the button a couple times if I need to remove more than one line. I tried a Trim function and replace but the text varies each time so it's not always a set number of characters Thanks Thomas

Thank you again I found the function under text functions. Just going to have to learn where the diffrent functions are practice and keep at it. Thank you for the pointers Thomas

This worked exactly the way I wanted it too THANK YOU VERY MUCH just one question though. When I made the script I could not find the function " GetValue ( ) " where did that one come from looking through all the Get functions there is no GetValue listed so I was a little confused for a moment but typed it in and it worked. If i had know about that function I probobly could have gotten this to work myself grrr.. guess I've got some more studing to do to find out functions that are there but not there if ya know what I mean lol Once again THANK YOU for the help works great Thomas

Greetings all and thanks in advance for any help. I'm very new to FMP and am trying to setup a database at work for customer contact managment. Mainly it's just to make my life easier because my employer dosnt have any system in place and I've been given the wonderfull task of making cold call inquiries. FUN... Anyway so far I've got things workeing pretty well I can create a record search even set up a special field to make checking the company names against those already in the database so I wouldnt end up with too many duplicates and didnt have to retype the company name over and over. Any way that's beside the point. What I'm looking to do now is even more to make the data entry part easier. at the moment I lookup business info online for example with yellowbook.com I then just copy the results from yellowbook to a global field in my database window so that I can parse the info out into my database. now what I'm doing is because the way the info copies from yellowbook it's real easy for me to clean it up real fast and have a readable address list which ends up looking like Company Name Address City State Zip Phone Website (sometimes) then repeats same 7 lines every time sometimes only 6 lines because of no website but it's all one long qlobal field I then just copy past the info starting at the top into a new record for each company. what I want to do is after I have the global field list I'd like to just clcik a button or copy all 7 lines of an contact into a new field and parse the infor into the coresponding seperate fields. I know this can be done but I just dont know how to do it. thank you for readiung this and any help is very much appreciated. also please try to keep it simple I'm VERY NEW to this and am still having to look up deffinitions on functions and stuff and piecing together an understanding on paramiters for stuff. So if ya can explain it to me like I'm a 5 year old YOUR THE BEST. but I do catch on quick.