stevec

This helped and I think we nailed it. Thanks very much for the help!!

Hi! A strange thing is happening in our scripts menu. After all of our files that are linked together open up, if you go under the scripts menu, all of the normal scripts are gone and only one shows up - which doesn't even exist in the file we're looking at, but DOES exist in one of the other files that opened up. If you go to a different file then come back, then the list shows up correctly. We've been using these files for years and have never had a problem, just started showing up, but not on everyone's computer. Any ideas? Thanks!

Hi! We have a FM6 database in which we "draw" up a layout with numbers and drawings in Excel. On a PC, we can copy the rows/columns/drawings we need, then paste into a container field in FileMaker. The problem is our Macs don't recognize this, we get a "Windows OLE object" icon and that's it. (I actually have the same problem when coloring fields via the getrepition calc, Macs can't see it.) However, doing it on a Mac and then pasting works on both platforms, unfortunately that isn't an option for us, we need to do it on a PC, and our Macs don't have Excel. Any ideas? Thanks!!

Hi, I'm trying to make a field display something that could be either text or a SORTABLE date (otherwise I'd just make it a text field with no problem). Here are my 3 fields: AtPrePressDate (date field) Completed (text field, which is a checkbox giving "x" when checked) Status (a calculated date field) if(Completed="x", "Completed", AtPrepressDate) AtPrepressDate obviously displays a date ok, otherwise I get the "?" in the field. I played around using the Case function instead, but couldn't really get it to work sufficiently either. Any ideas? I'm probably forgetting something simple, I always do that.

I think I found the answer - printing in list view in the other table instead. I'd still be interested if there's a way to do it in the portal, if anybody has any ideas!!

(we're still using FM5&6) In a portal, I have a field that may be one line of type, or may take up to several lines. Is there a way to make the field the size of the data entered into it when it prints? (i.e. if the size of the field in the layout allows for 5 lines of type, but sometimes when entered, only takes up one line, is there a way to omit all that extra space) I've been playing around with things, including the sliding/printing features, but can't seem to get this to work WITHIN A PORTAL. Thanks in advance for any input!!

perfect, Thanks Ralph!!! (wow, sometimes you try so hard to come up with something that you forget the completely simple and OBVIOUS) :

Hi! Working in FM5, mac and PC... we have a database of a few thousand customers that includes an email address, each customer having it's own record. Is there a quick way to make those email addresses into a list, separated by a comma, so could easily copy/paste into an email program? Thanks for any help!

Hi! I'm wondering if there's a way to display portals in columns instead of rows? Thanks for any input!

Hi! Not even sure if this would be a "scripting" issue or not... Here's my question...is there a way to do a sort within a sort? Example: I have twenty records to display. Each record has a 'title' field, a 'part' field, a 'status' field, and 6 different 'date' fields (date1, date2, date3 etc). Is it possible to sort by title, then depending on what the status field says, by the appropriate date field? i.e. the first 8 sorted records are for the title "Eagles" The first 3 of those 8 records are status="A", which would need to be sorted by the date2 field...The next 4 records are status="B", which would need to be sorted by the date3 field, etc. Then the next 3 sorted records are for the title "Owls", etc etc etc. Does that even make sense? Any help greatly appreciated!!

PERFECT. I appreciate the help!

Hi! using FileMaker 5. I need to figure out a simple "expiration date" I have a DealDate field (xx/xx/xxxx date format), a TermsInMonths field (number format) and need a calculation that shows the date the terms expire. For example, if the DealDate is 1/13/2003, and the Terms field is 18, the result should say 7/13/2004. What's the simple way to do this? (I tend to overlook the obvious and make it way too complex! heh) Thanks for any help!