Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

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

Recommended Posts

Posted

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

Posted

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.

Posted

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

Posted

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.

Posted

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!

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 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.