onlyu2 Posted February 6, 2002 Posted February 6, 2002 I'm just starting out, and I'm working with a pop-up menu. I have three fields, one of which is a total of the first two fields, and which is affected by the pop-up menu. What I can't figure out is how in the total-field to have whichever choice from the menu affect the total. Basically, if you choose "Boston" from the menu it has a number associated with it, and should be placed in the script on the field which holds the total. Ifall that makes sense, I'd really appreciate any help on this! thanks! Ben
JPaul Posted February 6, 2002 Posted February 6, 2002 The pop up field is it "buttonized" or not ? To launch a script, after the selection, it MUST be buttonized or you MUST have a pklug in. Please clarify.
Korky Posted February 6, 2002 Posted February 6, 2002 I think you have to use the 'Case'Function in your calculation. i.e. Case(ChoiceField;Boston;result 1;Chicago;result 2etc) Refer to Functions in the user manual or Help
JPaul Posted February 6, 2002 Posted February 6, 2002 Korky, if you place the calculation in the TOTAL FIELD, as i presume, you create a circular reference when you try to sum to itself the content of the pop up and you get an error.
onlyu2 Posted February 7, 2002 Author Posted February 7, 2002 Thanks for all the replies! To clarify a bit, I have now chnaged the pop-up menu to a button so that it can run a script. What I'm wondering is does IT need to run a script? The calculation I have the field that shows the "total" in reads lik this: (DesignHeatLoad * 24 * BostonBTUH) / (Efficiency * 139000 * 83) -- The BostonBTUH and the amount of "139000" will both be changed depending on two different pop-up menus. Can the case, or if statements, be placed inside the calculation, such as "if [boston, 13, Manchester, 14]" etc? And do the pop-up menus have to have a script attached to them at all? Thanks everyone!
Recommended Posts
This topic is 8329 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 accountSign in
Already have an account? Sign in here.
Sign In Now