Redefine a field based on criteria

[cricket]

I have a field set as a pop-up list with two options for billing people: "Hourly" and "Flat Fee". Then I have a number field called "Fees" in another table.

What I would like to happen is if I choose "Hourly" as the billing type, then the Fees field is a calculation of an HourlyRate * NumberOfHours (each of those is specified in other fields).

If I choose "Flat Fee" for the billing type, I would like to be able to enter whatever amount I want in the "Fees" field.

So, if the billing type is "Hourly" the Fees field need to be a calculation and if it is "Flat Fee" it needs to be a regular field.

Is this possible?

Thanks for your time.

[Zero Tolerence]

Set your Fees field as an auto enter calc with Do not replace exisiting unchecked. Then make this the auto enter calc for that field.

Evaluate(Quote(If(BillingType = "Hourly"; RelatedHourlyRate; ""); BillingType)

What this does, is everytime your pop-up list is changed, it updates that calc, it will either be an hourly rate, or blank. If it is blank, type in what you want in there.

[Lee Smith]

Here is an older approach.

Lee

BillingSelect.fp7.zip

[cricket]

Thanks for you responses guys.

Zero, when I enter yours FM say "Too many parameters in this function" and highlights the semicolon before BillingType) at the end.

Thanks also Lee, however, I need to be able to enter my own values in the Fees field rather than one overall value for a flat fee, because I need to break out different parts of a job into different line items.

Set your Fees field as an auto enter calc with Do not replace exisiting unchecked. Then make this the auto enter calc for that field.

Evaluate(Quote(If(BillingType = "Hourly"; RelatedHourlyRate; ""); BillingType)

What this does, is everytime your pop-up list is changed, it updates that calc, it will either be an hourly rate, or blank. If it is blank, type in what you want in there.

[Zero Tolerence]

Thanks for you responses guys.

Zero, when I enter yours FM say "Too many parameters in this function" and highlights the semicolon before BillingType) at the end.

Thanks also Lee, however, I need to be able to enter my own values in the Fees field rather than one overall value for a flat fee, because I need to break out different parts of a job into different line items.

Evaluate(Quote(If(BillingType = "Hourly"; RelatedHourlyRate; "")); BillingType)

:

[cricket]

I guess I should ask...

If I want it to calculate the Hours * HourlyRate, is that what I put in your equation where it says RealatedHourlyRate?

Thanks.

[Zero Tolerence]

Yes, put in whatever calculation you want to in there.

Could be like Table1::Hours * Table1::HourlyRate

will work fine.

[cricket]

Cool. It is working.

However, it is not letting me enter a number. It says "This field cannot be modified."

I have it set as a decimal number field, with the enter in browse mode set. Is it because it's a calculation that it's not letting me enter anything?

[cricket]

oops, I'm dumb, nevermind. I had it set as a calculation rather than a number that auto-calculates.

Thanks!

[Lee Smith]

Thanks also Lee, however, I need to be able to enter my own values in the Fees field rather than one overall value for a flat fee, because I need to break out different parts of a job into different line items.

These fields are modifiable? However, you can use the basics of this to set up a Auto Enter, which can then be overridden if you want.

I modified my sample file to show how you can do this using the Auto Enter.

See the second layout and the field named a_charge to see how this can be set up.

HTH

Lee

BillingSelect.fp7_2.zip

[cricket]

Cool. Thanks guys. I got it working.