Skip to main content

Select values from another table

  • January 30, 2019
  • 1 reply
  • 14 views
C

Hi,

I have a base set up for my work projects and have separate tables for labour, material, and travel linked to my main projects table so I can sum up total cost estimates. I also have a separate table with the individual services I provide with fields for units and unit cost. Example-painting-unit is square foot and unit cost is $1.00. When adding new items to my “labour” table, I would like to be able to select the “painting” service from my “Services” table and have the “unit cost” field in my “labour” table populate based on the service I selected. Is this possible? Thanks.

    1 reply

    J
    Forum|alt.badge.img+18

    Yes… if you already have the tables linked, such that you are selecting the service from the Services table, then you can use “Lookup” fields to pull data out of your Services table that is on the record you linked.

    Here’s some more info about Lookups:

    Guide to formula, lookup, count, and rollup fields

    Formula, lookup, count, and rollup fields (columns) are powerful field types that allow you to compute a value based on values in other cells. These fields are configured in the field configuration...

    B
    E
    2 people like this
    • B
      bob_aycock
    • E
      Elias_Gomez_Sai

    Reply


    Most helpful members this week

    Terms & Conditions