Need help in CDML to run a script!!

cdml

October 1, 200322 yr

I have a database of two files in FM Pro6.0 on a Mac. The files act as a time card for 200 employees to punch in and punch out for their hours worked. The first file shared has two variables, employee number and password both are global variables and two buttons on the layout, one to run a script to clock in and the other to run a script to clock out. The scripts validate the entry info and pass it to a second file to create a time card record for that day for the employee. I want the 200+ employees to be able to clock in and clock out by accessing the layout through a web page with CDML tags that will pass on the employee number and password and the a click of the first button on the web page would run the first clock in script and a click of the second button would perform the clock out script.

Is this possible with CDML or are there anyother easy ways to do this where the employee can do this with their browser...

Thanks in advance...

October 1, 200322 yr

Yes it is possible. An example:

http://myurl/FMPro?-db=mydb.fp5&-format=clockin.html&user=....&passw=....&-script=clockin&-find

Check the CDML Reference database. It has some more details. You may be able to find a link to the database through a search of this forum.

All the best.

Garry

October 1, 200322 yr

Author

Thanks Garry. Do you know if there is an easy way to have a button on the screen to initiate a script. The employees may login from different machines and therefore I would like a web page to use for clocking in and out.

Thanks for the help.

October 1, 200322 yr

You could do something like this:

<body>

Emplolyee ID: <input type="text" name="emp_id" value="">

</form>

Good Luck.

Garry

October 1, 200322 yr

Whether CWP or IWP, you should look to do this with calculations and/or JavaScript. If a lot of the 200 folks are going to clock near-simultaneously ScriptMaker will cause you to have problems (which have been widely discussed here).

If you are using IWP, only certain scripts are allowed (which affects whether or not the buttons on the db file layout function on the browser).