?? Create a folder from within Filemaker

[elwood00]

Anybody know of a way to create a subfolder in the my documents folder through a filemaker script, without dropping $60 on a plugin?

 

Thanks

[Maarten Witberg]

If you're on a mac:

 

create a text field NameOfFolder

validate this field: it should be unique and contain only alphanumeric and _

 

Code:

---

copy[select, "NameOfFolder"]
perform applescript["blahblahblah"]

---

 

add the following applescript lines in the dialog box of the "perform applescript" script step:

 

Code:

---

tell application "Finder"
	set my_folder_name to the clipboard
	set the date_stamp to ((the current date) as string)
	make new folder at "YourHardDisk:users:YourName:documents"
	set the item_list to list folder "YourHardDisk:users:YourName:documents" without invisibles
	repeat with i from 1 to number of items in the item_list
		set this_item to item i of the item_list
		set this_item to "YourHardDisk:users: YourName:documents:" & this_item as alias
		if creation date of this_item as string is date_stamp then
			set the name of my this_item to my_folder_name
		end if
	end repeat
end tell

---

 

this script was tested in OSX. there could be differences when in OS9. I could not figure out how to set the name of the folder in one go so I had to create the test-for-datestamp loop.

 

kjoe

[Hartger]

Kinda makes me feel stupid changing to Win....

 

Hartger

[Maarten Witberg]

Not that I'd advise anyone to switch from mac to win , but can't you do the same with VisualBasic or something?

 

kjoe

[-Queue-]

Yes, you can make a batch or WinBatch file and call it via Send Message/Send Event.

[elwood0000]

Of course I am on windows....

 

But thanks for the pointers - I have it figured out - and I found a free solution, rather than the $90 that WinBatch wants from you. It is called AutoIt by Hiddensoft - http://www.hiddensoft.com/autoit3/

Great program - even comes with a compiler.

[Ted S]

Try this using Send Event:

 

cmd /c md "C:\Documents and Settings\UserName\My Documents\NewFolder"

 

Of course you can make this a calculation by using some parameter from your DB.

[Redu]

How can you make this a calculation from a parameter?

 

I'm playing around with FMPro8 at the moment and this could prove very useful.