Ryusui

Thanks for the suggestion, eos. I added that extra bit to my calculation but unfortunately it still allows for multiples of the same item to be added.

Of course it figures that when I finally break down and ask for help on a forum, I finally stumble across some of the answers I've been looking for. I finally figured out what AppleScript is needed to have FileMaker create a Reminder item and a Calendar event. But there are still a few hiccups. Firstly: I managed to add a button to my database that will create a new Reminder item for me: List ( "tell application " & Quote ( "Reminders.app" ) ; "set mytitle to " & Quote ( Events::event_name & ":" & " " & "Invoice Due" ) ; "set mybody to "& Quote( Events::notes ) ; "set mydate to date " & Quote ( Events::date_due_invoice ) ; "set mylist to list " & Quote ( "Business" ) ; "tell mylist" ; "make new reminder with properties {name:mytitle, body:mybody, due date:mydate}" ; "end tell"; "end tell" ) This works without fail. If I hit the button, a Reminder item is created in the right list with all the info I asked for. But now I am not sure how to automate this when the "date_due_invoice" field is auto-populated after choosing the event's date. The first thought I had was to create a script to run multiple AppleScripts when the event date is chosen and the field is validated. But this presented a problem - being that the script runs before the various task fields have a chance to auto populate, I get "invalid date" errors because the script is, of course, trying to pull dates from fields that have no dates yet. Though if I go back into the field after the date has been chosen, then re-validate it, it will run the scripts just fine and enter the Reminder items into the app. Obviously this is not an ideal way to do this. And I haven't yet figured out a way to run the script after the task fields have been populated. So I'm stuck here. This also brought up another problem - if I happen to validate the field again after the Reminder items have been added, it will add them yet again. So I end up with duplicates. Is there even a way for Filemaker and Reminders to talk to each other bi-directionally so that I don't get duplicates created? Or to have a Reminder item updated if I change the date in one of the task items as opposed to creating a second Reminder item with the new date? Even if it can delete the first one when creating the new one, that would be acceptable. I also managed to add a button that adds an event to the Calendar. And while this script can be run after validating the event date field, I am still left with the issue of duplicate events if I ever re-validate the date field, as well as trying to change or delete the old event if the date changes.

Greetings, all. I have been researching for a few weeks now with few results, so hopefully someone here might be gracious enough to help me out. I have an event database that, after setting the event date for the new record, will auto-populate a number of fields with due dates for a bunch of different tasks. My understanding is that I should be able to use AppleScript for this, but I have not been able to figure out how. My first question: is there a way to have Filemaker add an event to my Mac Calendar once I set the event date and start and end times in the record? I'd like it to be added to a particular calendar - that is, the "Business" calendar in the Calendar app - with a predetermined format that is a mix of static text and info from fields. So for example, when it adds the event date and time to my calendar, the event would be titled: EVT: [FIELD1] & [FIELD2] In addition, is there a way to have the new calendar event set the "location" field in the Mac Calendar app utilizing one or more of the fields? So if it has one location, it would just insert that location in the the Mac Calendar location field. If it has 2 or three, it would be like: [LOCATION1] / [LOCATION2] / [LOCATION3] Finally on the calendar topic, I need to make sure that if I change something like the times or location(s), that it auto-updates the calendar event once I validate the field. Or if I mark the event as "INACTIVE" (they have three statuses: ACTIVE, INACTIVE, COMPLETED) that it removes the event from the calendar completely. For reminders, as mentioned my record contains a task list that will auto-populate due dates based on when I choose the event date. Once these fields have their dates auto-populated, I want it to automatically create reminders for each one of the task items in the "Business" reminder list of the Mac Reminders app. Again, it needs to have a set format so that if I have 30 events going on at once, I know which task is for which event. So maybe something like: [EVENT NAME FIELD]: [INVOICE DUE FIELD] [EVENT NAME FIELD]: [LAYOUT DUE FIELD] And so forth. Also, my tasks don't have due times, but is there a way, upon auto-export to the reminders, that I can tell it to set them all to the same due time? Say 10am? Lastly, can this sync two-ways? So if I delete the task from the Reminders app, or mark it as complete, it will delete the date from the field, or mark the task complete in the database record? Or if I delete the date from the record's field or mark that field as complete, that it deletes the reminder from the app or marks it as complete. For the task list, I have a checkbox list that has a box connected to each one of the task fields. If a field is past due, the field's title will show in red. If I click on that field's checkbox, or if I delete the date from the field, the field title will revert back to black. I hope someone can either assist me or direct me to a link I can accomplish a task that has been haunting me for a while. Thanks for your time!

It's indeed quite likely. I just started with FMP last month and have only been able to work on it sporadically between other projects. Anyway, attached is my database. (Thanks BruceR for the heads up that I needed to ZIP it) I created two sample records in the Contacts table. In the Events table, I want to have the "First Name" and/or "Last Name" fields under "Client Info" linked to the Contacts table so that if I start typing in a name, it will look for an existing person of that name and if one exists, fill in all the fields below up to the "Email" field. I started trying to do this by copying the field calculations I saw in the Event Managment.FMP12 file, but that was as far as I could go. Hopefully seeing the file will help a little to understanding what I'm trying to do. I greatly appreciate the help so far! Events & Contacts.zip

My biggest problem with the Event Management Starter Solution is that the Event Details table doesn't have two fixed fields for a bride and groom; it has a "Guests" section and a "Contributor" section, which don't act the same way I need the "Bride Info" and "Groom Info" to act. Also, neither has all the required information fields to pull from its Contacts table.

Yes. Sorry, that is the "Events Starter Solution with a Contacts table" to which I previously referred. As stated, I have tried to reverse engineer it to my needs, as well as modifying that particular database, but neither option has worked well.

Hey guys. I'm new to FM and while the database creation itself is extremely simplistic, having multiple tables talk to each other is just going way over my head. What I have: I'm using FM Pro 12. I started with the Contacts Starter Solution, and then created a new table - Events. I plan on using this table to create a database of client weddings. In Events I have a tabbed panel, one tab being "Client Info" in which I have two identical forms: Bride's info and Groom's info. Things like first name, last name, address, phone numbers, etc. What I want: When entering a name into the Events table's "Client Info" fields, if that client already exists in the Contacts table, I want it to have their info auto-populate in the corresponding fields below it. FM Pro 12 has its own Events Starter Solution with a Contacts table, in which there is a "Contributors" area which does close to what I want, but because of differences in layout and execution, I haven't been able to reverse engineer it for my purposes. Seems simple enough, but for whatever reason I just can't seem to find any explanations that lay it out for me so I can understand how to do this. Ideally, I'd like to have the Events table create a new record in Contacts if that person does not exist, but from what little I understand about relationships in FM, this is a bit more complicated and so I can very easily do without it. It's that first relationship that I absolutely need. Eventually I want to have this database create a new contract and invoice for me as well, but I figure that once I can understand this first basic part, that should come with a little work. If anyone can help me with this, I'd greatly appreciate it! Thanks!