David Maffucci

Bingo, I didn't do the define variable bit but yours is cleaner. Nonetheless it works!

I'm glad I played, I made a change. I added a Round function in the Mod calculation. Without it, the formula was only right when the amount was rounded down. Using Round solved that problem.

An answer AND an eduction! This is terrific! I'm going to play with the formula a bit so I am sure I understand it. Again, many thanks!

I was creating an email via script. Your link gave me what I needed! I'm using: "$" & Int ( Amount ) & SerialIncrement ( ".00" ; 100 * Mod ( Amount ; 1 ) ) And it works! I'm not quite sure how that last part works but it does! Thank you,

Hello, I have what I hope is a simple issue but I can not figure it out. I'm using FileMaker to create an email message. It works like a champ except that part of what's created is a line of text that includes a number that's formatted as currency in my layout but often comes out wrong in email. So, for example, if the number (which is called "AmountDue") is $50.50, then it exports as 50.5 and drops the last zero. How can I get it to format correctly and show the two digits? Thank you! DM

Yikes, this is already beyond me. I've done plenty of relational databases but I'm not sure I understand the variable part. Also, how do I break the owners list into separate owners? I was thinking it would be done using text functions like left and right and such... I may need to go back to FileMaker School just to follow your very likely brilliant advice.

Hello FileMaker Wizards, I'm helping a car club with a task that either is beyond me or may be impossible given the structure of their poorly designed database. To ultra-simplify, I've exported all of three fields which are all we need to accomplish the task...here goes. Every car has a 4 digit serial number, a current owner, and a list of past owners. All we want to do is generate a list, sorted by owner's name, showing all the cars they own or have owned in the past. If they currently own a car, it's serial would show as bold. That's all! It should look like this (fake data): John Doe - 0075, 1736, 2567 Jane Smith - 0362, 1883, 3002, 3182 The problem is, the past owners is a big text field with no real structure. Some owners have middle names, some owners are actually companies, most have a location in parenthesis which should be removed, some have a year they owned the car. All that is irrelevant for the purpose of this list. There could be one past owner or as many as a dozen. I know there are some text tricks that can be used to both isolate the lines in the text field and maybe even clean up the names but how to do it, and attach the serial, and identify them as past owners so the name is not bold is the hard part. Any thoughts on how to take this mess of a text field and break it up so we can just have the owner's name? To help make this easy for you to understand and offer your saga advice, I'm attaching the database here so you can see it...I appreciate any advice or tips you guys can offer. Thank you, David Owners List.fmp12

That's for the advice! Two EXCELLENT suggestions: Setting a new field to show a calculation works like a champ. I think this is my fix! The tooltip works pretty well too...is there any way to control how LONG you have to hover before the tooltip pops? Thank you both! DM

Hello everyone. Pretty sure you guys are going to tell me to rework some things here but I've got a seemingly simple question. I have a database which has a layout that's view only, I don't want the user to modify the data. In any case, one of the fields is a description text field and on some of the records, the text is larger than can fit on the view of this layout. Normally, if you click a field, it will show the scroll bars to allow you to view all the text but because we are not allowing entry to the field, clicking has no effect. Is there any solution, short of making the description field larger on the layout? Thank you, DM

Thank you for your reply. I honestly don't recall why I made it a global all those years ago when I made the database. Is there a way to make a standard field behave like a global? So what happens in the Incriminator database table is it basically counts up 18 records (lines on the deposit ticket), then it ads one to my global field. That's all it does. However if the ticket number were not a global, I don't know how to keep it consistent among the 18 records. Again, thank you (and anyone who cares to offer advice) for your time.

Hello FMP Wizards, A few weeks ago, I had to switch to FMP 14 Server. Prior to that our little group was able to get by with hosting on one Mac but we had too many times when someone had to leave FMP so another person could get in. Anyway the transition was very smooth for all but one of my databases. I have one task that only I do. It's accounting related and I use three external files to do it. One is a deposit ticket, one is a table of the ticket lines and one I call "Incrimentor" which simply counts up the lines of the ticket and increments a global field when one of the tickets is full. It all works great BUT when it starts up, the global field I use to keep track of what ticket we are on ALWAYS resets to the number it was when I first moved to server. I have to manually kick it up to the last ticket. It's not the end of the world but in the past it just worked. Seems Global fields and server don't work like they used to...anyone have any suggestions or advice? Thank you,

I had to figure this out...so I did! Understand, my AppleScript is nonexistent. I did some searches to come up with this... (The AppleScript is clipped so here it is:) tell application "Finder" get bounds of window of desktop set the clipboard to result as text end tell

Thanks for the reply. I'll update my profile because I'm running 11 now. In any case, My layouts all work fine on small screens, the problem is the location of the windows. I have an open script which positions the window. At present, on 13, 15 and 17" screens it positions the windows either off the screen or very close to it. I'm wondering if there is a way to find the screen size and using that info change where the window is positioned on the screen. I'm using a "Move/Resize Window" command to do it now. Maybe embedding it in an If/then would allow me to have a small screen/big screen position.

Thanks for moving the thread and the link. I looked at the PDF and didn't find any instructions telling me how to effectively merge multi-file databases into one...is this possible?

Hello, My Mac has a huge 27" display. When I made my database, I made use of all the screen real estate I had and I've got scripts which open and size all the files which makeup my database (about 8 or 9 files pop open when I open the "main" file) In any case I've now got a few users sharing the database with me but some are using Laptops which have small screens. As a result, some windows open off the display area of the laptop! Very odd. Is there any way to set the coordinates differently depending on which screen the user happens to be using when opening the file? Bonus 2nd question... Each of my files have carefully designed and tweaked layouts. Can I create ONE big window with a tabbed interface and then just copy and paste the layouts from the individual files into one? Crazy sounding but maybe so crazy it will work?! Thanks for any advice