Can someone help me figure what I need to add to this script or help me rewrite it to do the following:

If you can see the script I need it to send an email (this works) then I need it to fill in current date and check the completed box (this does not work) Please remember this script step is in a portal. How do I tell the script to only fill in the date and check box of the portal row I am on?

Go to Related Record [show only related records; from table:Policy_Notes_LB Etc...]

Send mail to [Person in contact list]

Go to Layout ["Policies"(Policies)]

Insert Current Date [select; Polices::LB_Date]

Set Field [Policy_Notes_LB::Completed_Chk;1]

Set Field [Policy_Notes_LB::Completed_Message;"Done"]

Insert Current Date [select; Policy_Notes_LB::Date_Sent]

Go to Layout ["Policies"(Policies)]

Refresh Window []

You can select a distinct portal row with 'go to related record'.

-jens

I've read over your post several times and composed several different answers. I think I might have figured it out. Is the Policies layout the layout where you initiate the script? If so, the problem occurs when you leave the layout with the GTRR script step. This deselects the current portal row. Since you have FileMaker 8, you can store the Get(PortalRow) value in a script variable so when you come back to the layout with the portal, you can use the Go to Portal Row script step with the variable to reselect the portal row so your Inserts and Set Fields work on the row you want them to.

BTW, I would switch your Insert Current Date steps to Set Field steps. Any step beginning with "Insert" requires the target field to be on the current layout. You can easily prevent problems by using Set Field:

Set Field [Policies::LB_Date; Get(CurrentDate)]

Yes you got it... The script is with the Polices Layout. Can you show me what you mean by store the script step. Thank you for your hard work to help me.

Joseph