Discussions

Expand all | Collapse all

Look Up Field Question

  • 1.  Look Up Field Question

    Posted 27 days ago
    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
    ------------------------------


  • 2.  RE: Look Up Field Question

    Posted 27 days 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/
    ------------------------------



  • 3.  RE: Look Up Field Question

    Posted 27 days ago
    Thanks as always Blake!

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



  • 4.  RE: Look Up Field Question

    Posted 27 days 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
    ------------------------------



  • 5.  RE: Look Up Field Question

    Posted 27 days ago
    yes it will be a formula numeric field with the formula
    [field 1] +  [field 2]

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 6.  RE: Look Up Field Question

    Posted 27 days ago
    Thats what I was thinking. Just wanted to make sure! Thanks Mark!

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



  • 7.  RE: Look Up Field Question

    Posted 26 days ago
    Hey guys,

    So I got the look up fields working, however, in the app that I'm trying to create, there are 7 different departments to display different currencies each by phase(4 phases). Right now each department just has the same numbers in each field (which are the correct totals, but only for one of the departments). I'm thinking I need to create different look up fields be each currency I need to display. And if that department isn't involved in that job, and doesn't have any totals, its left blank. My confusion is if I just create all these different look up fields, how will QB know what I'm referencing so say one department shows the correct total, and another isn't involved and doesn't display anything?

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



  • 8.  RE: Look Up Field Question

    Posted 26 days ago
    Alex -

    I'm not quite understanding what you're trying to do. Could you try explaining this in a different way?

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quick Base Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------



  • 9.  RE: Look Up Field Question

    Posted 26 days ago
    Ok so I'm making a scheduling app to pull budget totals by each department, based on 4 different phases. Right now the totals that are displaying are accurate for 1 of the departments, but the others should be blank referencing the accurate department totals. 


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



  • 10.  RE: Look Up Field Question

    Posted 26 days ago
    So these totals are being pulled from a different table (Jobs) that way I can pick a job, know what department is involved, and all phases of that jobs labor totals, from there I want to calculate those numbers with the avg hourly rate for that department, to calculate the duration for each phase for that job, and then display that in a calendar report so my company can easily see an estimation on how long this specific job should take based on how many employees assigned to that job department. So now I'm just pulling those currency totals over from the jobs table. It's working accurately for 1 of the departments, but they are all displaying the same thing since i'm using the same fields(look up) for each section in the form. I guess my question is how can I go about making all these different based on Department.

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



  • 11.  RE: Look Up Field Question

    Posted 26 days ago
    So these totals are being pulled from a different table (Jobs) that way I can pick a job, know what department is involved, and all phases of that jobs labor totals, from there I want to calculate those numbers with the avg hourly rate for that department, to calculate the duration for each phase for that job, and then display that in a calendar report so my company can easily see an estimation on how long this specific job should take based on how many employees assigned to that job department. So now I'm just pulling those currency totals over from the jobs table. It's working accurately for 1 of the departments, but they are all displaying the same thing since i'm using the same fields(look up) for each section in the form. I guess my question is how can I go about making all these different based on Department.

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