Attempting to open a folder based on a field name.

[eyeballs]

Hi, I am having a problem with this... I wish to open a folder in MS windows with the "send event" command. The following script shows my attempt to open a folder who's name is a fieldname. No matter what I do, scriptmaker always reads the field name as a text, not at the contents of the fild.

Enter Browse Mode []

Set Field [GLOBALFIELD; "cmd /c explorer c:FIELD_NAME"]

Send Event [aevt";"odoc";GLOBALFIELD]

When I run this script, the command is sent to windows, but it tells me that "The path 'c:GLOBALFIELD' does not exist or is not a directory"

Can anyone see what I am doing wrong and how this can be changed to open the folder that is call what GLOBALFIELD contains?

Thanks so much!

-Steve

[Ted S]

Steve,

Make sure you don't have quotes around the field name.

[Munchie]

I have scripts that open files and folders from a field name. I simply put the path in the field, and use the Send Event script step.

Do what you are doing without the extra characters.

Set Field [GLOBALFIELD; "c:FIELD_NAME"]

Send Event [aevt";"odoc";GLOBALFIELD]

[eyeballs]

Thanks Guys, I have tried deleting the quotes and scriptmaker prevented me from saving the script becasue it was expecting an end quote. I will try playing around with it some more and I will remove the cmd/ c stuff. thanks again!

-Steve

[eyeballs]

Hoping to get help one more time regarding this issue.

I am using a date in the calculations of a script and I cant get it to show the date as "4-23-2005", it always shows it as "4/23/2005", which cannot be part of a windows forder becasue of the slashes. I have gone into the date settings of the date field involved in the calculation, and I have changed it to the "4-23-2005" format, but the script still puts the old format in the field. Any Ideas? Thanks

-Steve

[BobWeaver]

The most reliable way to get the date in the format you want is to explicitly format it like this:

Month(DateField)&"-"&Day(DateField)&"-"&Year(DateField)

If you need to include leading zeros in the month and day, you can use this:

Right("00"&Month(DateField);2)&"-"&Right("00"&Day(DateField);2)&"-"&Year(DateField)

[comment]

Or:

Substitute ( GetAsText ( Datefield ) ; "/" ; "-" )

[eyeballs]

Did the trick, thanks guys!