 0 Points
Posted 3 years ago
QuickBaseCoach App Dev./Training, Champion
 65,280 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, Champion
 65,280 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
 2926 Conversations
 75 Followers

Relationships
 2625 Conversations
 47 Followers

Tables & fields
 7210 Conversations
 182 Followers