Path to Variable Folder

[Skipi]

Hi,

 

I have a script that maker a folder based on the product ID (always unique) and then generates several PDF certificates from a FM record.

 

I then have a script that I can choose the folder (choose folder/set result) to combine all the PDF files inside it into 1 file.

 

I'm looking to automate this process fully, by removing the user step of having to choose the folder.

 

I thought it would be a reality simple process of setting the  variable FolderName to the ProductID as I have for making the folder, but I'm getting -1727 errors, parameter is not an object specifier.

 

I feel that I'm quite close to a working solution, but I'm stumbling on something.

 

Any advice would be greatly appricatied.

 

Regards,

 

Skip

 

 

 

set workflow_path to "/Users/skipi/Desktop/CombinePDF.workflow"

 

tell application "FileMaker Pro Advanced"

set FolderName to cell "Product ID" of current record

end tell

 

 

set the theFolder to "Fusion:Users:skipi:Documents:TempCertsFolder:" & FolderName as alias

 

 

repeat with this_folder in the theFolder

 

-- get name and posix path of a folder

tell application "System Events"

set the folder_name to the name of this_folder

set the folder_path to POSIX path of this_folder

end tell

 

-- call automator workflow to process pdfs

do shell script "automator -D NewName=" & quoted form of folder_name & " -D FolderPath=" & quoted form of folder_path & " " & workflow_path

 

end repeat

[Skipi]

Sorted.

 

 

set workflow_path to "/Users/skipi/Desktop/CombinePDF.workflow"

 

tell application "FileMaker Pro Advanced"

set FolderName to cell "Product ID" of current record

end tell

 

set thefolder to  "Fusion:Users:skipi:Documents:TempCertsFolder:" & FolderName as alias

 

 

set the this_folder to thefolder

 

 

-- get name and posix path of a folder

tell application "System Events"

set the folder_name to the name of this_folder

set the folder_path to POSIX path of this_folder

end tell

 

-- call automator workflow to process pdfs

do shell script "automator -D NewName=" & quoted form of folder_name & " -D FolderPath=" & quoted form of folder_path & " " & workflow_path