January 21, 200124 yr 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?
January 21, 200124 yr 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.
Create an account or sign in to comment