Jump to content

Performing a calculation automatically


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

Recommended Posts

  • Newbies

On an input screen the inputter will enter a leave date, leave hours and then select from an popup menu a three letter code. I want to transfer the leave hours to a field which name is the same as the three letter code. e.g. 1/21/01,8 hours, CWL. Transfer 8 to a field called CWL. Right now I accomplish that by clicking on a button that runs a script. However it requires the inputter to not forget to push the button. Is there a way to automate that?

Link to comment
Share on other sites

If you don't want to use a button and a script, then you have to use calculated fields. For example the CWL field would be set up as the following calculation:

CWL = If(Patterncount(Code,"CWL"),Hours,"")

and so on for each of the various fields that you want to conditionally transfer the hours into.

I'm assuming that the date, hours and 3-letter code are entered by the user into separate fields. If not, they really should be.

Link to comment
Share on other sites

This topic is 8524 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
×
×
  • Create New...

Important Information

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