Abaworld

Yes, as well as the option to attach pdf to send mail. I would prefer to not save the invoice confirmation as a pdf - just send it via FM, but, alas, I haven't figured out to do that... Your response initiated the thought that there must be other ways to send the email. So, now I have discovered scripting. Digging in to find out what I don't know (quite a bit...) after dinner.

Of course ---- Hmmm, you must be British... : Since you asked -- next question is: Can FM prevent a form with critical info, being mistakenly emailed? example: reservation form has credit card info, invoice confirmation does not. Extreme possibility for reservation to be emailed instead of invoice (been done already...). I want to make it ***impossible*** to send the reservation form. Pete

Thanks, Lee. jamesducker's solution did everything that I needed, but I will store your suggestion away for future possibilities. Pete

It worked perfectly!!! Thank you, again! Pete

Thank you, jamesducker, for the response! Actually, the current format is mmddyy***, but I can see valid reasons for having the year, first. Thanks for that hint. Now, let's see if I can get it to work...

I see a lot of great posts here, but none that address my issue. The main "problem" is that I am new to FileMaker (and databases in general) and I have to tackle the reservation, invoicing, etc project created by a former employee. They did not complete the project but it is usable with some limitations/errors. The first issue: We have a 'booking number' field that is calculated using the 'arrival date' and first 3 of 'customer's last name'. The 'arrival date' is entered via calendar. Problem is that if the month and/or day is a single digit, the 'booking number' field will have slashes inserted in place of the number. If I setup the calendar to insert leading zeroes, they appear in the field, but not in the calculated 'booking number'. However, they do appear in the 'booking number' if the date is entered manually. The easy fix would be to enter the date manually instead of using a calendar, but I would prefer an easier and less likely to error method. These are the two fields used for the calculation: 'booking number' = (trim booking number)&Left(client Last name;3) 'trim booking number' = Middle ( arrival date ; 1 ;2)&Middle (arrival date ;4 ;2 )&Middle ( arrival date ; 9 ; 2 ) I have tried a number of different functions in place of "middle" without success. There is a "part 2" to this that I have absolutely no clue: Sometimes, the booking requires a one-way departure, so no entry in the 'arrival date'. My fix is to enter the 'departure date' in the 'arrival date' field so that the booking number can be calculated. Is there a way to have the program look into the 'departure date' if the 'arrival date' field is empty and then use that date for the 'booking number' calculation? I appreciate any help provided and will, very likely, have a few (probably many...) more questions. I hope that my explanation is understandable. Thank you! Pete