Select values from another table

Corinne_Collin · ‎Jan 30, 2019

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.

Jeremy_Oglesby · ‎Jan 30, 2019

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...