Forum Discussion

AlexBennett3's avatar
AlexBennett3
Qrew Trainee
5 years ago

Look Up Field Question

Hey Everyone,

Forgive the question if it is an easy one, I'm struggling on understanding this issue and could use some help! I'm wanting to pull some data (currency) from one table to display into another for calculation purposes, however, I'm needing to combine two fields before displaying the TOTAL as a lookup field. Is this possible to do? Just wondering if anyone knows of any work arounds or solutions! Trying to combine the two currency amounts to display in another table.

Thanks,
Alex

------------------------------
Alex Bennett
------------------------------
Relationships
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    5 years ago
    You would want to build another field at the origin that calculates the total of those two fields and then THAT field will be the field you build a lookup for.

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quick Base Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------
    • AlexBennett3's avatar
      AlexBennett3
      Qrew Trainee
      5 years ago
      Thanks as always Blake!

      ------------------------------
      Alex Bennett
      ------------------------------
      • AlexBennett3's avatar
        AlexBennett3
        Qrew Trainee
        5 years ago
        Can I ask what you might recommend for the Field type for the field that will combine the two? They are currency, but I was thinking it would need to be a formula field.

        ------------------------------
        Alex Bennett
        ------------------------------