Mif

Does anyone know of a way to link an email (Mac Mail) to a filemaker record? Ideally I would like to view one or many connected emails by clicking and having the email show up in a container field, or the text content being displayed?

Anyone know the quickest way (with the keyboard) to the "Manage Value Lists" window on the MAC. (OSX)

DJ, your right. I wanted to preserve the field as a date field, for date to be used in date calculations. I see now that I could make it a calculation field that stores it as a date anyway, and this field is working dynamically. Thanks

I have a field that isn't recalculating: Field type; Date Auto Enter Calculation: Get (CurrentDate) Storage: None (Auto create....) Commit record and Refresh Window, flush doesn't cause recalculation either. The field is a date field as opposed to a calc field because I am doing reporting using the date.

dah! I think I need some sleep.

I'm getting a message that "Days Left" is a field that can't be found. What am I missing here? Case ( duedate - z_todaysDate > 0; "Abs ( duedate - z_todaysDate ) & "Days Left"; duedate - z_todaysDate > 0; "Abs ( duedate - z_todaysDate ) & " Days Past"; )

Thanks, that takes care of number one. The "fn" and "return" key works great. For #2, zoom in and out, I created a script for each and place them in positions 1 and 2 on the scripts list so they work with command 1 and command 2. For some reason, the zoom within Filemaker is much sharper than the system zoom. Thanks

Two related questions; 1. Does anyone know the Mac keyboard equivalent of "ctrl + enter" from Windows which takes the cursor out of record editing mode. 2. Is there a Mac keyboard equivalent of "ctrl + f3" and "f3" used to zoom in and out?

Thanks comment, I'm more than half way there now so I think I'll just persist. I have learned allot in the process though so if anyone out there is going through the same thing, I'd be happy to share. One real help was in creating a valuelist of table occurences and using that list to build the new table occurences. I stayed away from separate files in this cases for a range of reasons from loss of flexibility inherent in the built in nested table functionality that I didn't have in other multi-file solutions I worked on in the past, to fear having to adjust too many scripts, value lists, calculations, etc. I did have another post inquiring about the use of XML data and whether or not that could be used (when imported), to build the relationship graph but I haven't had any answers yet and have to keep moving on this. Thanks again

Assuming you need to keep the portal row count the same, one thought would be to remove the fill and lines from the portal and create borders around and fills in the fields in the portal to create the illusion of a dynamically expanding portal. :(

I purchased some code which is designed around a "Contacts" table and I am merging it with extensive work already done for a client and their contacts table. There are probably around 150 Table Occurance branches which branch off the clients Contact table and 50 currently branching off the new code. Both need to be preserved. I am merging the client solution into the purchased code. Thanks

Yes, I have a clone that I use on another computer so I can view the relationship links from the other file, but still have to manually link them in the new file. I'm still wondering if there is a way to copy those links from one file to another. Is there another way I could be using the clone? Thanks

I believe you need to have a minimum of two objects selected in order to activate it.

I'm looking for the easiest way to copy a relationship graph from one file to another. Thanks

If I understand you correctly, you want to be able to go to an individual booking record related to the selected booking from the portal list you place on your customers layout. Assuming this, here is an approach: 1. create a field in your customer table called "bookingID_temp" and make it a global number field. 2. create a relationship from that field in the customer table to the bookingID field in the bookings table. (I am assuming you have a bookingID field that is automatically serialized and unique) 3. create a script with two steps. a/ Set Field - set the "bookingID_temp" field with bookingID number from the portal. b/ Go to Related Record - go to the related booking record (based on that new relationship) and make sure that you go to a layout that is based on the bookings table. Also click the checkbox tell it to match only the current record an not all the records in the found set. 4. place a button in the bookings portal row on your original customer layout and assign the new script to it. When you click the button, the script will assign that bookingID to the tempglobal field and then go to the related booking record on a the booking layout you specified.

I'm merging two files into one and wonder if there is a quicker way to rebuild TO's in the relationship graph, perhaps by using XML data?

Anyone know why the "Value is" condition in the conditional formatting drop down would be grayed out? I have one condition already set based on a "Formula" and need another using "Value Is".

Thanks comment, You're right, it is redundant. Maybe that's why it didn't take. Instead I just set a temp field with the script parameter directly and it works fine.

I don't get why this script isn't working. Is there a better way? Set Variable [$scriptP;Value:Get(ScriptParameter)] I have several buttons that would use the same script other than a value unique to the button so I am trying to modularize my scripts and use a script parameter instead.

Lee, Mr_Vodka and Aldipalo Good news and bad news Good - I have it working Bad - I'm still not sure what solved it. 1. I had all 3 views checked in layout setup 2. I was sorting the found set in the script (I assume that was the goal since it is working 3. I couldn't view records in preview but could pg down/up between them in browse mode Lee, regarding your comment "are you doing this with scripts?...If so, be sure you don't have the Restore set in the script." I wasn't exactly sure what you meant by not having the restore set in the script but I did go to each layout and from browse mode, erased the sort default data and then set it up in the script. Also Lee you asked if I was doing subsummary reports. Yes and in regard to this, I when through each part and reset the leading/trailing settings. Thanks for your help gentlemen!

Yes with scripts. In regards to taking the restore off, do you mean to not set a sort at the layout level?

Yes

Print is set to "records being browsed". Actually I still have the same problem just viewing it in preview mode as well. Another strange thing is that while in Browse mode, I displayed "Show omitted only", did the appropriate sort, and all the omitted show up in the preview of the report correctly. Then I when "Show omitted only" to go back to the first found set and do the sort, It still only previews one of the four records in the original found set.

A report while in browse mode (after being sorted properly) shows 4 records. When switching to preview mode only the 4th record displays and/or prints.

Is there a way to create a multi value field from another field specifying a range. eg: Range field = 11/24/2008...11/28/2008 I need a new field to return 11/24/2008 11/25/2008 11/26/2008 11/27/2008 11/28/2008