I would like to create a text file from a global field. Ultimately i want to turn it into a .ics file and open it in iCal. This is an example of the field need to copy. Its important to keep the returns.

BEGIN:VCALENDAR

VERSION:2.0

METHOD:PUBLISH

BEGIN:VEVENT

DTSTART;VALUE=DATE:20080610

DTEND;VALUE=DATE:20080613

SUMMARY:Josh Allen (Annual): 3 days

UID:242

END:VEVENT

END:VCALENDAR

thanks

Take a look here:

http://www.fmforums.com/forum/showpost.php?post/296004/

--sd

thats excellent - thanks Søren. Just one follow up question. Im trying to pick up the data from fields in a portal record. Is that possible via applescript. The script is activated by clicking on a button in the portal row.

eg

tell application "FileMaker Pro Advanced" to set filename to cellValue of cell "booked Leave::start" of current record

thanks

Edited July 8, 200817 yr by Guest

Why not make a GTRR before the Applescripting is done?

Otherwise do you need to get the right of the inner clauses ... since the portalized is stuffed inside clauses ... like this:

{"1", {"Mr."}, {"Elvin"}, {"Blues"}, {"Chicago"}}

...where the "1" is in the main record, and the fields in extra clause is each of the fields in the portal row. How should your applescript BTW know which portaline you're in?

No the simplest way to obtain the correct focus, must be hybriding the scripting a bit, singling out the correct set of data with native scripting, and then fire the AS later.

--sd