steigrafx

Thanks so much. As you can see, I'm no Filemaker expert and sometimes I hit a wall and need a shove in the right direction. Thanks again, and have a great day. Kevin

I currently have a field that takes the first line from an address field (could be a law firm or an attorney's name): GetValue ( Customer ; 1 ) (for example, John Smith, Esq.) I also have a second field which takes the data from the above field and, if that address line is an attorney's name, removes the trailing ", Esq." leaving only the attorney's name: Case ( Right ( PDF_BillTo ; 6) = ", Esq." ; Left ( PDF_BillTo; Length ( PDF_BillTo ) - 6) ; PDF_BillTo ) (for example, John Smith) Is there a way to consolidate both calculations into one field so it's more eff

I have a layout that performs a script OnRecordCommit. The script includes a sort. How can I "mark" the record and then, after the OnRecordCommit script finishes, return to the same record? Thanks, Kevin

Thank you!

I need a push in the right direction. I have a value list from a related table. All is well; however, most of the value lists contain numerous choices, but some of the value lists contain only one choice. Is there a way to automatically populate the field when there is but one choice in the value list? Thanks, Kevin

Thank you, Comment. I did not know that summary fields ignore empty values. And yes, I would need four separate summaries. Sorry it took so long to reply...I just returned from vacation in Aruba. Wish I was still there. Have a nice weekend. Kevin

Hello, all. I hope you're enjoying your summer. I'm trying to add trailing subtotal average fields to my wife's insulin database (she has fields for breakfast, lunch, dinner and bedtime), but sometimes she doesn't make a record of her blood sugar reading. How can i create a calculation that will average a field without counting blank fields, which would of course skew the average downward? Thanks, and have a great day. Kevin

Thanks for the response. Adobe Acrobat Reader.

Not sure if this is where to post this... One of my users can insert references to PDF files in a container field, but double-clicking to open them does nothing. I've uninstalled and reinstalled Filemaker 11 to no avail. The actual PDF files are located on a PC in my office and are accessible to all my users. She has no problem navigating to the PDF's using Windows Explorer and opening them directly, so I think this may be an operating system issue (Windows 7 32-bit) or some dependency is missing. All other users with identical Windows 7 PC's can open the files without a problem.

Of course you are right, comment. My variable was to blame. Thanks, Kevin

Yes, of course you're right. It won't happen again. And please, Lee, have mercy on me!

Sorry, EOS. I didn't mean to ignore you. I appreciate your help. It's funny how you look at something over and over and still don't see the mistake. You're absolutely right. I made the correction and the case calc works as it should. And sorry for the double-post -- please don't string me up for it! Thanks again, and have a great day.

Thanks, Comment. Your calc works except for one small glitch. The result I need would be 13KS063, whereas your calc returns 13KS13063. There's an extra "13" in there. How can i get rid of that? I was also wondering why my Case calculation failed. It looked straightforward to me, but I'm certainly no Filemaker expert! Thanks again.

I have a case calculation in a script to determine whether the current date is within January, February or March, in which case I need the prior year's two-digit number returned. Otherwise, from April through December, I need the current year's two-digit number returned. This calculation returns the correct year (I changed my system date to test it): Case ( Month ( Get ( CurrentDate ) ) < 4 ; Right ( Year ( Get ( CurrentDate ) ) ; 2 ) -1 ; Month ( Get ( CurrentDate ) ) > 3 ; Right ( Year ( Get ( CurrentDate ) ) ; 2 ) ) But, I need to use this to create a "Voucher Number" wh

Thanks, Comment. I'll give it a try tomorrow morning when I'm back in my office. As always, I appreciate your input. Kevin