if i wanted to give specific fields an ID/tag mark, so i can leverage that field within an "IF" formula, could i do that, and how?
 940 Points
Posted 1 year ago
QuickBaseCoach App Dev./Training, Champion
 57,308 Points
I'm not understanding. All fields have names. You just use the field name in your formula.
Are you asking about the syntax to write a formula?
Are you asking about the syntax to write a formula?
 940 Points
if i wanted to create a formula that would take the amount paid in payment #1, generate a "auto/default payment" for payment #2 & #3, wouldnt the individual payments need a tag? I tried using the actual numbers, but because they are related to a specific invoice the sum changes when another payment is created.
 940 Points
i'm trying to automate each payment amount with a ridiculously confusing formula to generate the amount automatically
QuickBaseCoach App Dev./Training, Champion
 57,258 Points
Each field is like a cell in Excel and it can be a formula field.
What is the calculation for the field Payment 2.
Or are you saying that each separate record is a payment and the payment calculation depends on the value entered on another record.
What is the calculation for the field Payment 2.
Or are you saying that each separate record is a payment and the payment calculation depends on the value entered on another record.
 940 Points
yes to your last point. Confusingly, whatever the last payment is it has to be 1000 more than the others. so if it was 2 payments and total is 25,000 then payment one would be 12,000 and payment would be 13,000. The 1K sum difference is another field in the invoice that this business adds to final payment. Its confusing and complex and i'm not sure how to do it.
QuickBaseCoach App Dev./Training, Champion
 57,258 Points
It is typically very difficult in QuickBase to do calculations where one record affects the calculation on the next sequential record. However if the nature of your payment calculations are such that they can all be on one record than any calculation as possible.
If that is the case, then each of your payment records will be a separate field and the formula can refer to the value in other fields on that same record.
If that is the case, then each of your payment records will be a separate field and the formula can refer to the value in other fields on that same record.
 940 Points
Yeah, that's what I was figuring reading others problems.
Related Categories

Formulas & functions
 2779 Conversations
 64 Followers

Relationships
 2539 Conversations
 39 Followers

Tables & fields
 7039 Conversations
 153 Followers

Tips & tricks
 314 Conversations
 25 Followers