 0 Points
Posted 3 years ago
QuickBaseCoach App Dev./Training (Mark Shnier), Champion
 72,086 Points
It's really not possible to do that. But I'm sure that there is a way to accomplish your needs another way if you can explain your objective.
 0 Points
I am writing an estimating tool that has various electric rates and monthly bills. The rates have similar structures rate to rate, but the way they are calculated are different. I wanted to use the rates (Rates have many Bills) as the parent and lookup the formula to calculate the bill.
QuickBaseCoach App Dev./Training (Mark Shnier), Champion
 72,086 Points
You do not need to carry down the actual formula to use. You just to carry down the information about WHICH rate formula to use.
So come up with a multiple choice field on the parent rates table and look that up down to Bills.
Then use an IF statement or a Case statement to calculate the amount.
For example
Case([Rate Plan],
"A", then out your formula here,
"B", then out your next formula here,
"C", then out your other formula here,)
So come up with a multiple choice field on the parent rates table and look that up down to Bills.
Then use an IF statement or a Case statement to calculate the amount.
For example
Case([Rate Plan],
"A", then out your formula here,
"B", then out your next formula here,
"C", then out your other formula here,)
Related Categories

Formulas & functions
 3045 Conversations
 82 Followers

Relationships
 2675 Conversations
 51 Followers

Tables & fields
 7336 Conversations
 200 Followers