I've written a FMP8 database to track requested vacation and personal days. I have a screen that the end user would use to put a request in and then when they accept it an e-mail is generated to the manager saying there is a request that they need to review. After they accept or deny the request it sends another e-mail back to the end user. The problem I've run into is this needs to be web based, but I can't get the send mail parts of the script to work through the web. Is send mail a script step that is supported by the web interface?

Are you using Instant Web Publishing? Then no it probably doesn't work. There is a checkbox in your script screen that says "Indicate Web compatability" I suggest going back through your solution with that checked, who knows what else might not be working.

But this will do:

http://www.fmforums.com/forum/attachment.php?attid/5649/

--sd

I'm having trouble opening the file SD. It's asking me for a password.

Is there a way other then Instant Web Publishing?

The template stem from this thread:

http://www.fmforums.com/forum/showtopic.php?tid/171558/hl/mailto/tp/0/all/1/

and the pass is:

Admin

foo

--sd

sd - do you know if there is a way to get this mailto script to work other then using the open url script step? it's opening not only the e-mail, but also a blank web page and I'd like to avoid that if there's another way.

Thanks for your help yesterday.

Sarah

If real 'botting is without reach, could you split your server into several workstations by using VMWare virtual server that makes you run webbrowser accessing your IWP solution on the server machine. It will require some VBScripting to manipulate the web interface to perform the transmission of the mails.

Another solution is to have a java virtual machine running this:

http://www.myfmbutler.com/index.lasso?p=371

...but I have reservations - the java is hogging processingpower en masse!

If you move your solution to OSX could shellscripting apparently via a clever combination of curl, grep and sed be made into a very fast robot directing the unix application pine into performing the task, with very little footprint.

But I would need a unix geek to assist me with it.

--sd