Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Get value from linked table based on input

Topic Labels: Formulas
Solved
Jump to Solution
738 2
cancel
Showing results for 
Search instead for 
Did you mean: 

I have table with pin code, city and state,
Have second table with contacts
In contact record, if I type pin code then how can I get city and state value filled in related field from linked table, IF function not works for me as pin codes are 26k records.

1 Solution

Accepted Solutions

Like this:

  1. In your [Contacts] table, your {PinCode} field should be a linked-record field that links [Contacts] with the [PinCode] table.
  2. In [Contacts], define two lookup fields, {City} and {State}. These would be lookups based on the value in {PinCode} and reference the values in {PinCode::City} and {PinCode::State}, respectively. ('{PinCode::City}’ means ‘the value of the {City} field in the [PinCode] table.’)
  3. When you select the proper {PinCode} for your contact record, {Contacts::City} and {Contacts::State} will be populated automatically.

See Solution in Thread

2 Replies 2

Like this:

  1. In your [Contacts] table, your {PinCode} field should be a linked-record field that links [Contacts] with the [PinCode] table.
  2. In [Contacts], define two lookup fields, {City} and {State}. These would be lookups based on the value in {PinCode} and reference the values in {PinCode::City} and {PinCode::State}, respectively. ('{PinCode::City}’ means ‘the value of the {City} field in the [PinCode] table.’)
  3. When you select the proper {PinCode} for your contact record, {Contacts::City} and {Contacts::State} will be populated automatically.

Thank you very much for your reply, this solved my problem. Much appreciated. :thumbs_up: