February 6, 200224 yr 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
February 6, 200224 yr 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.
February 6, 200224 yr 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
February 6, 200224 yr 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.
February 7, 200224 yr Author 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!
Create an account or sign in to comment