Exporting found set to excel

[bcolburn]

Hi all. I'm a relative newbie to FileMaker and I'm struggling with a script that, if I pull it off, would make me look REALLY good to my boss. Anyone able to help?

I'm trying to perform a find based on a single field ("MARK PCP Info Unknown") for all records with a response of "Yes"

I then want to sort those records alphabetically by last name and export the fields I want to an Excel spreadsheet. I am ultimately repeating this process with several other fields and would ideally like to put them all on different sheets of the same Excel file. Not sure if that's possible, but just putting it out there.

Here is the Script I have so far, but it keeps saying that no records match my search parameters:

Loop

Show all Records

Go to Layout ["Checklist" (Checklist)]

Enter Find Mode [Restore] <------ Specified find: Find Records, Checklist::MARK CP Info Unknown [= "Yes"]

Perform Find [] <------ I have tried specifying the same find again here too, but no dice

Sort Records [Restore]

Export Records [No dialog; "PCP Info Missing 2"; Automatically Open; Unicode (UTF-16)]

Enter Browse Mode []

End Loop

I'm basically just flying by the seat of my pants here. Am I even on the right track? HALP!

[Fitch]

Why don't you try scripting ONE Find first. I don't see how a loop is going to work for you, unless you plan to pause and enter the Find criteria each time around.

You should be able to specify the Find requests in the Perform Find script step, in which case you don't need Enter Find at all. However, if that doesn't work for you, try it with not using Restore on either step, but rather:

Enter Find Mode

Set Field( Checklist::MARK CP Info Unknown ; "Yes" )

Perform Find

PS: You don't need Show All or Enter Browse.

[bcolburn]

Oh. My. G-d. You just saved my life and made me the hero of my study team. THANK YOU!!!

[Fitch]

Haha, you're welcome, that was a nice way to start the day!