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

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

Recommended Posts

  • Newbies
Posted

Could you help me out with a problem, i'm kinda new to this program, I know the basics though..

Here's my problem

I have one field called GROUP: this field has radio buttons ( 4 different ones, "3hours", "6hours", "12 hours", Other) I have another field called AMOUNT DUE

I want a value entered in the AMOUNT DUE field depending on what radio button I select in the Group Field...

Ex: If I select the "3hr" button in the GROUP field, then I want $50.00 to automatically be entered into the AMOUNT DUE field.

Is this possible??

Posted

You can make Amount Due a calculation field with its value based upon the Group field.

Amount Due (calculation, number) =

Case(

Group = "3hours", 50,

Group = "6hours", 100,

Group = "12hours", 200,

"")

The exact calculation will depend upon the exact values entered in the Amount Due field. If Amount Due is a number field, not a text field, the calculation should look like:

Case(

Group = 3, 50,

Group = 6, 100,

Group = 12, 200,

"")

A really exact answer depends upon a really exact specification of, for instance, what needs to happen when "other" is selected, but this is the method.

-bd

This topic is 8084 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.