Shine56
asked on
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_hig h)
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
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
fuel_consumption="med" and rate_based_on ="One Month";monthly_charge_out_
fuel_consumption="high" and rate_based_on ="One Month";monthly_charge_out_
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
You may also want to check the data types of the fields involved, make sure you're not mixing number and text values.
Also might want to make sure the calc solution is unstored...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
And who said that the points will be refunded?
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.
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.
>>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 :)
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 :)
ASKER
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
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
Kevin,
Sure. JUst accept his answer :) (There is a button "Accept" next to his comment)
Sure. JUst accept his answer :) (There is a button "Accept" next to his comment)
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.
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.
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?