Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Performing Calculation Using Custom Office?

Status
Not open for further replies.

tpsiks

IS-IT--Management
Jul 30, 2007
42
US
Hi,
I'm fairly new to MAS90, my company worked with a local JOBOPS Configurator and they customized a form for us. They did this in Custom Office,I was told, where after a user enter in a work ticket number and if a VALUE of "MSI" [a unit of measure] appears in a text box, then >>>This is their work>>>>it will tab to a text box they made called "Length" [you enter the length], next tab is "Width" [you enter the width]. It will multiple the two values together to get the AREA[length * Width] and display the resultant value to a text box.

Before this was done, we had to manually multiply the length and width with a calculator and type in the result.
This part of MAS90 is being used in the shop and not for the office people, it makes it very convenient for them.

What I want to do is: detect the value[unit of measure]of "/M" from a textbox within the form and ask the user to enter a value then DIVIDE it by 1000 or multiple by .001, then display the result in a text box. I can add text field, text boxes and so on with Custom Office, but I don't know if I can use script or something to calculate my added field.
The company that did this said they did it in Custom Office.
I couldn't find anywhere in CO to see the calculation scripts.

My question is, is this possible to do in Custom Office?

Thanks,
 
Yes but based on your questions I would STRONGLY suggest having the original JOBOPS configurator do this for you. If you don't know what you are doing it is possible for you to "break" what they did.
 
They might have done it with a code snippet in the configurator.

Dawn
 
Dawn,
That sounds more like what I was thinking. It was very quick of what they did. They added two multiline text boxes and added a script somewhere to calculate the two together. I have multiple copies of MAS90 on my computer to try things before going live, so I'm not concern with messing it up. This tweaks does not alter/change the data table in anyway.

If anyone knows how of any door/access to this coding/configurating please do post.

Thanks
 
You can get to the code snippets right from within the configuration steps.

Dawn
 
How do you go into the configuration steps?
From Custom Office? Only thing that I have is Customizer Selection, which I can add links and couple other minor things but I couldn't find anything else.
We have JobOps product configurator but we only use it for our 3 products that we have. It doesn't tie to the form that I am looking at [JT_PARTS].


Thanks so much for the helpful responses.
 
No the code snippets don't have anything to do with Custom Office; it's a separate thing. You get to them from within the configuration maintenance.

Dawn
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top