Jump to content

Need help in CDML to run a script!!

mathur999

By mathur999
in Other Internet Technologies

 Share

This topic is 7793 days old. Please don't post here. Open a new topic instead.

Recommended Posts

mathur999 Apprentice

mathur999

Posted
Posted

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...

mathur999 Apprentice

mathur999

Posted
  • Author
Posted

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.

Garry Claridge Grand Master

Garry Claridge

Posted
Posted

You could do something like this:

<body>

<form action="FMPro" method="POST">

<input type="hidden" name="-db" value="db1.fp5">

<input type="hidden" name="-format" value="thisfile.html">

<input type="hidden" name="-op" value="eq">

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

<input type="hidden" name="-script" value="clockin">

<input type="submit" name="-find" value="Clock IN">

</form>

Good Luck.

Garry

Unable Proficient

Unable

Posted
Posted

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).

This topic is 7793 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.

  I accept