Forum Discussion

8 Replies

  • 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?
  • RyanRyan2's avatar
    RyanRyan2
    Qrew Assistant Captain
    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.
    • RyanRyan2's avatar
      RyanRyan2
      Qrew Assistant Captain
      i'm trying to automate each payment amount with a ridiculously confusing formula to generate the amount automatically
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      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.
    • RyanRyan2's avatar
      RyanRyan2
      Qrew Assistant Captain
      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.