• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 200
  • Last Modified:

Case Structure and a Text Box

Help!

I am working with a form that retrieves a value using a case structure;

Case(
fuel_consumption="low" and rate_based_on ="One Month" ;monthly_charge_out_rate_1_low;  
fuel_consumption="med" and rate_based_on ="One Month";monthly_charge_out_rate_1_med;
fuel_consumption="high" and rate_based_on ="One Month";monthly_charge_out_rate_1_high)

Now according to which ever radio box is selected, Low, Medium, High, fuel_consumption value is changed. The problem is the only value that shows is the high value. Should I be using something like GetField to retrieve the value at the end and why isn't my text box receiving the evaluated case calculation?

Thank you!

Kevin
0
Shine56
Asked:
Shine56
1 Solution
 
lesouefCommented:
First, if only high works, it means there is probably a spelling error, or a trailing space in the radio box choices.
Second, if the result does not turn up in yr resulting text box, then the calculation is nto triggered when expected I guess?
Is this controlled by a script?
Used in an auto-enter field?
Used in a calculated field?
0
 
billmercerCommented:
You may also want to check the data types of the fields involved, make sure you're not mixing number and text values.
0
 
mx4pxCommented:
Also might want to make sure the calc solution is unstored...
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
lesouefCommented:
btw I think it's probably an auto-entered field from a calculation and the "do not overwrite existing value" checked.
and as usual I see no reason to refund the points when the question had been abandonned by the questioneer... but up to you.
0
 
VenabiliCommented:
And who said that the points will be refunded?
0
 
lesouefCommented:
nobody; you suggested it! so I guess you'll do it if nobody complains. and you know my point of view, I already wrote it in other threads.
It is not for me, I absolutely don't care, I am here for fun, but I think it is not fair to abandon questions, and therefore I think EE can claim to keep the points.
0
 
VenabiliCommented:
>>you suggested it!
Had I? Read a few comments above and what it is? -"Delete - no points refunded" I thought that the word 'NO' is clear.

I know it is easier to start posting without reading but... :) In such question the recommendation can never be a refund :)

0
 
Shine56Author Commented:
Guys,

Calm down. No fighting just because I haven't checked my e-mail in almost a month. I was in the hospital for reasons I won't discuss. To the admin, do I still have time to award points? lesouef did point me in the right direction, so I would like to give him the points before this topic is destroyed with fighting. Please advise and I will take care of it. Sorry for any inconvience this has caused anyone. Have a great day!

Kevin
0
 
VenabiliCommented:
Kevin,

Sure. JUst accept his answer :) (There is a button "Accept" next to his comment)
0
 
lesouefCommented:
venabili,
sorry, I did read it, but for some reason, the NO espaced my mind, this is called reading too quickly!

shine56,
sorry for yr hospital period, EE has no way to guess and there are about 30% of questions left over, quite disppointing for support people who work here for free, our sole compensation is to know people get their pbs fixed on our recommantions.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now