Loop through portal using applescript
Loop through portal using applescript
- Subject: Loop through portal using applescript
- From: Lorne Golden <email@hidden>
- Date: Thu, 25 Jan 2001 15:16:48 -0500
Is there any way to loop through portal data using applescript. Soething
like:
tell app "FMP"
tell current record
go to first portal row
repeat
process row data
go to next portal row
end repeat
end tell
end tell
I was originally using a filemaker script but now need to access an outside
program so can't use the fmp script anymore. My first try was a combination.
script. Looping with the fmp script then calling the applescript to process
the data but could not get this to work. It would run the complete fmp
script before the applescript would run even if it was set to wait till
execution finnished.
One other weird thing without looping I just accesses a related field in the
portal and displayed it and it displayed the concatenated value of that
field for all the related records. So if portal row 1 had field item "apple"
and portal row 2 had field item "orange" The displayed value was appleorange
which I founf strange almost like accessing all the related records with one
pass. I am not sure how this can be made use of because it would take lots
of parsing to reuse the data but I did find this interesting.
So does anyone have an easy solution to loop through the portal with
applescript.
Thanks in advance
Lorne